MICROSOFT EXCEL EXPERT TEST
QUESTIONS AND ANSWERS
Which of the following demonstrates the general format of a formula that references a
cell in a different worksheet? - Correct Answers -SheetName!CellAddress
Which of the following is the file extension used for Excel Template files? - Correct
Answers -.xltx
What is the name of the feature that saves copies of your files at specified intervals? -
Correct Answers -AutoRecover
Which of the following statements best describes how to create a custom template of
your own? - Correct Answers -Click the File tab, select Save As, click Browse, and
change the file type to .xltx
Which of the following statements best describes how to copy macros from one
workbook to another? - Correct Answers -Drag the module from one project to another
in the Project Explorer window of the Visual Basic Editor
Which of the following methods is used to display a hidden tab on the ribbon? - Correct
Answers -Display the Excel Options dialog box, select Customize Ribbon, and then
select the check box next to the name of the tab you want to add.
Which of the following would be considered a strong password based on the definition
in this lesson - Correct Answers -4Nw9!tP@
What is the name of the separate worksheet that temporarily lists all tracked changes in
a shared workbook? - Correct Answers -History
The value 1 entered into a cell and formatted as a date corresponds with which of the
following dates in Excel? - Correct Answers -January 1, 1900
Which of the following Excel functions returns both the current date and time in a cell? -
Correct Answers -NOW
Your co-worker sent you a workbook to update. You have entered new numbers in your
worksheet, but the totals are not updating. Which of the following statements best
describes how to remedy the problem? - Correct Answers -Click the Calculation Options
button on the Formulas tab and change the calculation setting from Manual to
Automatic.
Which of the following represents the syntax for a structured reference to a field in an
Excel table? - Correct Answers -TableName[FieldName]
QUESTIONS AND ANSWERS
Which of the following demonstrates the general format of a formula that references a
cell in a different worksheet? - Correct Answers -SheetName!CellAddress
Which of the following is the file extension used for Excel Template files? - Correct
Answers -.xltx
What is the name of the feature that saves copies of your files at specified intervals? -
Correct Answers -AutoRecover
Which of the following statements best describes how to create a custom template of
your own? - Correct Answers -Click the File tab, select Save As, click Browse, and
change the file type to .xltx
Which of the following statements best describes how to copy macros from one
workbook to another? - Correct Answers -Drag the module from one project to another
in the Project Explorer window of the Visual Basic Editor
Which of the following methods is used to display a hidden tab on the ribbon? - Correct
Answers -Display the Excel Options dialog box, select Customize Ribbon, and then
select the check box next to the name of the tab you want to add.
Which of the following would be considered a strong password based on the definition
in this lesson - Correct Answers -4Nw9!tP@
What is the name of the separate worksheet that temporarily lists all tracked changes in
a shared workbook? - Correct Answers -History
The value 1 entered into a cell and formatted as a date corresponds with which of the
following dates in Excel? - Correct Answers -January 1, 1900
Which of the following Excel functions returns both the current date and time in a cell? -
Correct Answers -NOW
Your co-worker sent you a workbook to update. You have entered new numbers in your
worksheet, but the totals are not updating. Which of the following statements best
describes how to remedy the problem? - Correct Answers -Click the Calculation Options
button on the Formulas tab and change the calculation setting from Manual to
Automatic.
Which of the following represents the syntax for a structured reference to a field in an
Excel table? - Correct Answers -TableName[FieldName]
