Excel Final Exam Review | 100% Correct
Answers | Verified | Latest 2024 Version
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or
headings? - ✔✔B. Show
Which of the following notebook- like features organizes the sheets for use in Excel? - ✔✔A. Workbook
Which view enables a user to create or modify a worksheet while seeing how it will look in printed
format? - ✔✔A. Page Layout
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers
and text in Excel? - ✔✔B. Worksheet
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his
best option? - ✔✔B. Split
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her
to the last record on her spreadsheet? - ✔✔B. Ctrl + End
What occurs when the cursor is moved over a cell and a user clicks? - ✔✔B. The cell is selected
Which tab do you use to display the area that contains the print command? - ✔✔D. File
Which area, on the left side of the formula bar, can you look at to determine the cell address of a
selected cell? - ✔✔C. Name box
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used
Excel commands? - ✔✔A. Quick Access Toolbar(QAT)
,Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? - ✔✔B.
Open
Joan has a table that includes demographic information about her employees. What does all the
information about one employee represent? - ✔✔C. Row
Which of the following software programs is a powerful spreadsheet program that allows users to
organize data, complete calculations, and graph data? - ✔✔C. Excel
Which view is the default view used in Microsoft Excel? - ✔✔C. Normal
Which ribbon option opens a related dialog box? - ✔✔C. Launcher
What command do you use to increase or decrease the view of a selected cell or range of cells to fill the
Excel Window area for better visibility? - ✔✔D. Zoom to Selection
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides
keyboard code icons that may be used in conjunction with the ALT key? - ✔✔D. Key Tips
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies
the: - ✔✔D. Row
What command will arrange Microsoft Excel windows so that they appear side by side on the screen? -
✔✔C. Arrange All
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name
represent in the table? - ✔✔A. Entry
Which command do you use to close an open file and completely exit the Microsoft Excel program? -
✔✔C. Exit
, In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the
original cell intact?
A. Paste B. Move C. Cut D. Copy - ✔✔D. Copy
Sharon's spreadsheet contains information about the number of music downloads in F1:F25.F1:F25
represents a:
A. Cell B. Column C. Range D. Row - ✔✔C. Range
When entering data into a cell, which keyboard key is used to remove characters to the left of the
insertion point?
A. Delete key B. Backspace Key C. Left arrow key D. Enter key - ✔✔B. Backspace key
Joan is creating a table that will include demographic information about her employees. What is each
header in her table considered?
A. Label B. Value C. Formula D. Function - ✔✔A. Label
What is the name of the list of frequently used Excel commands available when a user right-clicks an
item in the worksheet?
A. Mini Toolbar B. Quick Access Toolbar C. Shortcut Menu
D. Shortcut Toolbar - ✔✔C. Shortcut Menu
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which
option should he choose?
A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit Sheet on One Page - ✔✔B. Print
Active Sheet
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters
as a previous entry?
A. AutoComplete B. AutoFill C. AutoCorrect D. AutoSpell - ✔✔A. AutoComplete
Answers | Verified | Latest 2024 Version
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or
headings? - ✔✔B. Show
Which of the following notebook- like features organizes the sheets for use in Excel? - ✔✔A. Workbook
Which view enables a user to create or modify a worksheet while seeing how it will look in printed
format? - ✔✔A. Page Layout
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers
and text in Excel? - ✔✔B. Worksheet
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his
best option? - ✔✔B. Split
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her
to the last record on her spreadsheet? - ✔✔B. Ctrl + End
What occurs when the cursor is moved over a cell and a user clicks? - ✔✔B. The cell is selected
Which tab do you use to display the area that contains the print command? - ✔✔D. File
Which area, on the left side of the formula bar, can you look at to determine the cell address of a
selected cell? - ✔✔C. Name box
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used
Excel commands? - ✔✔A. Quick Access Toolbar(QAT)
,Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? - ✔✔B.
Open
Joan has a table that includes demographic information about her employees. What does all the
information about one employee represent? - ✔✔C. Row
Which of the following software programs is a powerful spreadsheet program that allows users to
organize data, complete calculations, and graph data? - ✔✔C. Excel
Which view is the default view used in Microsoft Excel? - ✔✔C. Normal
Which ribbon option opens a related dialog box? - ✔✔C. Launcher
What command do you use to increase or decrease the view of a selected cell or range of cells to fill the
Excel Window area for better visibility? - ✔✔D. Zoom to Selection
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides
keyboard code icons that may be used in conjunction with the ALT key? - ✔✔D. Key Tips
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies
the: - ✔✔D. Row
What command will arrange Microsoft Excel windows so that they appear side by side on the screen? -
✔✔C. Arrange All
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name
represent in the table? - ✔✔A. Entry
Which command do you use to close an open file and completely exit the Microsoft Excel program? -
✔✔C. Exit
, In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the
original cell intact?
A. Paste B. Move C. Cut D. Copy - ✔✔D. Copy
Sharon's spreadsheet contains information about the number of music downloads in F1:F25.F1:F25
represents a:
A. Cell B. Column C. Range D. Row - ✔✔C. Range
When entering data into a cell, which keyboard key is used to remove characters to the left of the
insertion point?
A. Delete key B. Backspace Key C. Left arrow key D. Enter key - ✔✔B. Backspace key
Joan is creating a table that will include demographic information about her employees. What is each
header in her table considered?
A. Label B. Value C. Formula D. Function - ✔✔A. Label
What is the name of the list of frequently used Excel commands available when a user right-clicks an
item in the worksheet?
A. Mini Toolbar B. Quick Access Toolbar C. Shortcut Menu
D. Shortcut Toolbar - ✔✔C. Shortcut Menu
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which
option should he choose?
A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit Sheet on One Page - ✔✔B. Print
Active Sheet
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters
as a previous entry?
A. AutoComplete B. AutoFill C. AutoCorrect D. AutoSpell - ✔✔A. AutoComplete
