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?

Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?

Which option can be used for checking the protection status of a file in Microsoft Excel 2016?

Evaluating cell A1 based on font color:

Excel accepts the following range name:

In order to create a new report in Excel you have to go to:

Which automation function calls a procedure in a dynamic link library or code resource?

If a column is hidden, Excel will not copy the contents of the hidden cells in a copy/paste set of commands.