Excel Final Exam questions and
answers rated A+
Which Excel options category lets you modify the QAT? - correct answer ✔✔ Quick Access
Toolbar
Which part of the Excel application provides a quick way to sum or average a range of cells
without creating a formula? - correct answer ✔✔ Status Bar
Which excel options category contains the field to change the show mini toolbar on selection? -
correct answer ✔✔ General
Which keyboard shortcut acts like a toggle to minimize and maximize the ribbon? - correct
answer ✔✔ CTRL +F1
The status bar helpfully displays what information? - correct answer ✔✔ Statistics
The word database means different things depending on the software. What does excel
consider a database? - correct answer ✔✔ Contiguous rows and columns of information
What is another term for a row in excel? - correct answer ✔✔ Record
What is another term for column in excel? - correct answer ✔✔ Field
Which button allows you to enter search information into a data form? - correct answer ✔✔
Criteria
, how does using the delete button within a data form impact a table? - correct answer ✔✔ It
helps retain format integrity after deletion of a selected record
Data validation rules can be controlled from which tab of the data validation dialog box - correct
answer ✔✔ Settings tab
What validation criteria would you use if you want to create a data validation rule that allows
any number between 1 and 100 that represents currency (dollars and cents)? - correct answer
✔✔ Decimal
What should you do prior to creating a time validation rule? - correct answer ✔✔ Format the
cell to the time format
Which data validation criteria should be used when developing your own criteria based on a
formula? - correct answer ✔✔ Custom
The in-cell dropdown feature, which shows users all available cell options, is available with what
type of validation criteria? - correct answer ✔✔ List
What type of custom control would you create if you needed the values in one of the controls to
change based on the values in another custom control? - correct answer ✔✔ dynamic list box
Which custom control is commonly referred to as a radio button? - correct answer ✔✔ Option
button
What is the purpose of a group box? - correct answer ✔✔ It groups buttons and boxes visually
and logically
Which control would work best if there were 100 items to be listed in the input range of a
custom control? - correct answer ✔✔ drop-down list box
answers rated A+
Which Excel options category lets you modify the QAT? - correct answer ✔✔ Quick Access
Toolbar
Which part of the Excel application provides a quick way to sum or average a range of cells
without creating a formula? - correct answer ✔✔ Status Bar
Which excel options category contains the field to change the show mini toolbar on selection? -
correct answer ✔✔ General
Which keyboard shortcut acts like a toggle to minimize and maximize the ribbon? - correct
answer ✔✔ CTRL +F1
The status bar helpfully displays what information? - correct answer ✔✔ Statistics
The word database means different things depending on the software. What does excel
consider a database? - correct answer ✔✔ Contiguous rows and columns of information
What is another term for a row in excel? - correct answer ✔✔ Record
What is another term for column in excel? - correct answer ✔✔ Field
Which button allows you to enter search information into a data form? - correct answer ✔✔
Criteria
, how does using the delete button within a data form impact a table? - correct answer ✔✔ It
helps retain format integrity after deletion of a selected record
Data validation rules can be controlled from which tab of the data validation dialog box - correct
answer ✔✔ Settings tab
What validation criteria would you use if you want to create a data validation rule that allows
any number between 1 and 100 that represents currency (dollars and cents)? - correct answer
✔✔ Decimal
What should you do prior to creating a time validation rule? - correct answer ✔✔ Format the
cell to the time format
Which data validation criteria should be used when developing your own criteria based on a
formula? - correct answer ✔✔ Custom
The in-cell dropdown feature, which shows users all available cell options, is available with what
type of validation criteria? - correct answer ✔✔ List
What type of custom control would you create if you needed the values in one of the controls to
change based on the values in another custom control? - correct answer ✔✔ dynamic list box
Which custom control is commonly referred to as a radio button? - correct answer ✔✔ Option
button
What is the purpose of a group box? - correct answer ✔✔ It groups buttons and boxes visually
and logically
Which control would work best if there were 100 items to be listed in the input range of a
custom control? - correct answer ✔✔ drop-down list box
