Microsoft Excel Test Study Guide with
correct answers 100% 2026
Namebox - Correct Answers On left side of formula bar, determines cell address of selected
cell(s)
Key Tips - Correct Answers 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
Open - Correct Answers Command used to access a spreadsheet
Exit - Correct Answers Use to close an open file and completely exit the Microsoft Excel program
Worksheet - Correct Answers Use to enter, calculate, manipulate, and analyze data such as
numbers and text in Excel
Page Layout - Correct Answers Enables a user to create or modify a worksheet while seeing how
it will look in printed format
Ribbon that contains the command to apply a theme to a worksheet in Microsoft Excel
Quick Access Toolbar - Correct Answers Microsoft Office object used for quick, convenient, one-
click access to frequently used Excel commands
File - Correct Answers Tab used to display the area that contains the print command
Row - Correct Answers Ex. Joan has a table that includes demographic information about her
employees. What does all the information about one employee represent?
Ex. Sharon's spreadsheet contains information about the number of music downloads in F25.
"25" identifies the _____
, Normal - Correct Answers The default view used in Microsoft Excel
Show - Correct Answers Group on the View Ribbon that enables a user to show or hide the
ruler, gridlines, Formula Bar, or headings
Split - Correct Answers Ex. John wants to be able to view multiple areas of his spreadsheet at
the same time. What would be his best option?
Cell is Selected - Correct Answers Occurs when the cursor is moved over a cell and a user clicks
Launcher - Correct Answers Ribbon option that opens a related dialog box
Zoom to Selection - Correct Answers Command used to increase or decrease the view of a
selected cell or range of cells to fill the Excel Window area for better visibility
Ctrl + End - Correct Answers The shortcut that will take to the last record on spreadsheet
Arrange All - Correct Answers Command that will arrange Microsoft Excel windows so that they
appear side by side on the screen
Excel - Correct Answers Software programs that are a powerful spreadsheet program that allows
users to organize data, complete calculations, and graph data
Workbook - Correct Answers Notebook-like features organizes the sheets for use in Excel
Entry - Correct Answers Ex. 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 answers 100% 2026
Namebox - Correct Answers On left side of formula bar, determines cell address of selected
cell(s)
Key Tips - Correct Answers 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
Open - Correct Answers Command used to access a spreadsheet
Exit - Correct Answers Use to close an open file and completely exit the Microsoft Excel program
Worksheet - Correct Answers Use to enter, calculate, manipulate, and analyze data such as
numbers and text in Excel
Page Layout - Correct Answers Enables a user to create or modify a worksheet while seeing how
it will look in printed format
Ribbon that contains the command to apply a theme to a worksheet in Microsoft Excel
Quick Access Toolbar - Correct Answers Microsoft Office object used for quick, convenient, one-
click access to frequently used Excel commands
File - Correct Answers Tab used to display the area that contains the print command
Row - Correct Answers Ex. Joan has a table that includes demographic information about her
employees. What does all the information about one employee represent?
Ex. Sharon's spreadsheet contains information about the number of music downloads in F25.
"25" identifies the _____
, Normal - Correct Answers The default view used in Microsoft Excel
Show - Correct Answers Group on the View Ribbon that enables a user to show or hide the
ruler, gridlines, Formula Bar, or headings
Split - Correct Answers Ex. John wants to be able to view multiple areas of his spreadsheet at
the same time. What would be his best option?
Cell is Selected - Correct Answers Occurs when the cursor is moved over a cell and a user clicks
Launcher - Correct Answers Ribbon option that opens a related dialog box
Zoom to Selection - Correct Answers Command used to increase or decrease the view of a
selected cell or range of cells to fill the Excel Window area for better visibility
Ctrl + End - Correct Answers The shortcut that will take to the last record on spreadsheet
Arrange All - Correct Answers Command that will arrange Microsoft Excel windows so that they
appear side by side on the screen
Excel - Correct Answers Software programs that are a powerful spreadsheet program that allows
users to organize data, complete calculations, and graph data
Workbook - Correct Answers Notebook-like features organizes the sheets for use in Excel
Entry - Correct Answers Ex. 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?
