5 – While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named ‘Sheet5’?
A. $Sheet5$B2
B. $Sheet5.B2
C. Sheet5!B2
D. $Sheet5!B2
Answer:C
5 – While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named ‘Sheet5’?
A. $Sheet5$B2 B. $Sheet5.B2 C. Sheet5!B2 D. $Sheet5!B2