Quizalize logo
placeholder image to represent content

Excel Expert Review

Quiz by Jennifer Gallagher

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
45 questions
Show answers
  • Q1
    _______________ is a feature that includes the name of the person who made each change, when the change was made, and what data was changed.
    Report
    Change History
    Record
    Backstory
    30s
  • Q2
    Which of the following is the file extension used for Excel Template files?
    .xlsm
    .xlam
    .xltx
    .xlsx
    30s
  • Q3
    Which of the following demonstrates the general format of a formula that references a cell in a different worksheet?
    CellAddress!SheetName
    SheetName#CellAddress
    SheetName!CellAddress
    CellAddress#SheetName
    30s
  • Q4
    Which of the following statements best describes how to copy macros from one workbook to another?
    Use the Add-Ins button on the Developer tab.
    Open the Visual Basic Editor and type RUN COPYMACROS in the Project Explorer window.
    Use the Record Macro button on the Developer tab.
    Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor.
    30s
  • Q5
    Which of the following represents the syntax for a structured reference to a field in an Excel table?
    TableName[FieldName]
    FieldName[TableName]
    [TableName]FieldName
    [FieldName]TableName
    30s
  • Q6
    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?
    Click the Share Workbook button on the Review tab.
    Send the workbook back to your co-worker and have them fix it.
    Go to the cells with the totals that are not updating, press the F2 key and then press Enter to re-enter the formulas.
    Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.
    30s
  • Q7
    Which of the following methods is used to display a hidden tab on the ribbon?
    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.
    Right-click any tab on the ribbon and select Display Hidden Tabs.
    On the Home tab, in the Cells group, click Insert and then select Show Hidden Tabs.
    On the View tab, in the Show group, click the Tabs button and select the tab you want to display.
    30s
  • Q8
    Which of the following statements best describes how to create a custom template of your own?
    Click the File tab, select Options, click Save, select the Save as Template check box, and save the file as usual.
    Click the File tab, select Save As, click Browse, and change the file type to .xltx.
    Click the File tab, select Save As, click Browse, and change the file type to .xlsm.
    Click the File tab, select Save As, click Browse, and change the file type to .xlam.
    30s
  • Q9
    What is the name of the feature that saves copies of your files at specified intervals?
    AutoRecover
    Track Changes
    Protect Sheet
    Document Recovery
    30s
  • Q10
    Which of the following would be considered a strong password based on the definition in this lesson?
    239OAK$T
    4Nw9!tP@
    927%851*
    Tsj1961x
    30s
  • Q11
    What is the name of the separate worksheet that temporarily lists all tracked changes in a shared workbook?
    Tracking
    Review
    History
    Changes
    30s
  • Q12
    __________ is the text that must be entered before a user can access a secured workbook, worksheet, or worksheet elements.
    Email
    Password
    Name
    Username
    30s
  • Q13
    _________ is a workbook set up to allow multiple networked users to view and make changes simultaneously.
    Master Workbook
    Multiple Workbook
    Shared Workbook
    Secure Workbook
    30s
  • Q14
    _________ is a password that combines uppercase and lowercase letters, numbers, and symbols making the password difficult to guess.
    Good Password
    Weak Password
    Okay Password
    Strong Password
    30s
  • Q15
    __________ is a feature that marks and records changes made to a workbook.
    Track Changes
    History of Changes
    Motion Changes
    Detect Changes
    30s

Teachers give this quiz to your class