Question

Sheet reference uses sheet name,__________, and cell address. Exclamation Mark Operator Dollar Sign Select the correct answer from above options

Answer 1

Answer: Exclamation Mark Excel uses a special type of notation to handle these types of references. To use a reference to a cell in another worksheet in the same workbook, use the following format: SheetName! CellAddress In other words, precede the cell address with the worksheet name, followed by an exclamation point.