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'?

In Microsoft Excel 2016, the commands used for recording, creating and deleting macros is accessed from the Developer tab. Which of the following is the correct way of displaying the developer tab on the ribbon?

What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?

In Microsoft Excel 2016, which of the following statements is/are correct about dates? i) The default date format uses 4 digits for the year. ii) The dates are left-justified in the cells by default.

Which command is used in Microsoft Excel 2016 for totaling all the budget spreadsheets prepared by each department in an organization?

Which of the following keyboard shortcuts is used for displaying the Record Macro dialog box that is used for recording macros?

Which is NOT an option for formatting a row?

Which worksheet function returns the maximum value in a list of arguments, including numbers, text, and logical values?

Which worksheet function returns values along a linear trend?

If a file is saved, the actions that preceeded the save command cannot be undone.

Evaluating cell A1 based on font color: