Exam (elaborations) Excel Ohio pre licensing

Excel Final Exam Review Questions with
Correct Answers 2025
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula
Bar, or headings? - CORRECT ANSWER -B. Show



Which of the following notebook- like features organizes the sheets for use in Excel? - CORRECT
ANSWER -A. Workbook




Which view enables a user to create or modify a worksheet while seeing how it will look in
printed format? - CORRECT ANSWER -A. Page Layout



Which of the following would you use to enter, calculate, manipulate, and analyze data such as
numbers and text in Excel? - CORRECT ANSWER -B. Worksheet



John wants to be able to view multiple areas of his spreadsheet at the same time. What would
be his best option? - CORRECT ANSWER -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? - CORRECT ANSWER -B. Ctrl + End



What occurs when the cursor is moved over a cell and a user clicks? - CORRECT ANSWER -B. The
cell is selected



Which tab do you use to display the area that contains the print command? - CORRECT ANSWER
-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? - CORRECT ANSWER -C. Name box



Which Microsoft Office object would you use for quick, convenient, one-click access to
frequently used Excel commands? - CORRECT ANSWER -A. Quick Access Toolbar(QAT)



Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? -
CORRECT ANSWER -B. Open




Joan has a table that includes demographic information about her employees. What does all the
information about one employee represent? - CORRECT ANSWER -C. Row



Which of the following software programs is a powerful spreadsheet program that allows users
to organize data, complete calculations, and graph data? - CORRECT ANSWER -C. Excel



Which view is the default view used in Microsoft Excel? - CORRECT ANSWER -C. Normal



Which ribbon option opens a related dialog box? - CORRECT ANSWER -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? - CORRECT ANSWER -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? - CORRECT
ANSWER -D. Key Tips



Sharon's spreadsheet contains information about the number of music downloads in F25. "25"
identifies the: - CORRECT ANSWER -D. Row

, What command will arrange Microsoft Excel windows so that they appear side by side on the
screen? - CORRECT ANSWER -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? - CORRECT ANSWER -A. Entry



Which command do you use to close an open file and completely exit the Microsoft Excel
program? - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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 - CORRECT ANSWER -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