MICROSOFT EXCEL TEST STUDY GUIDE
WITH VERIFIED SOLUTIONS
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?
Shortcut Menu - Correct Answers -The list of frequently using Excel commands
available when a user right-clicks an item in the worksheet
Fill Handle - Correct Answers -Small black square in the lower-right corner of the heavy
border of an active cell that repeats a cell's value in adjacent cells
Range - Correct Answers -Refers to a group of selected cells that may be formatted,
moved, copied or deleted as a group
Ex. Sharon's spreadsheet contains information about the number of music downloads in
F1:F25. F1:F25 represents a: _____
Label - Correct Answers -Ex. Joan is creating a table that will include demographic
information about her employees. What is each header in her table considered?
Ex. Jennifer needs to identify the values in column B for a sales report. Which type of
entry should she use in the column header?
Ex. Jennifer needs to identify the values in column B for a statistics report. Which type
of entry should she use in the column header?
AutoComplete - Correct Answers -Microsoft Excel feature that automatically inserts data
into a cell that begins with the same characters as a previous entry
Cut - Correct Answers -Command on the "Home Ribbon" that allows data to be moved
from one worksheet location to another
Ex. 33. Alicia needs to move the data in cell B5 to cell E5. Which command would she
select?
WITH VERIFIED SOLUTIONS
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?
Shortcut Menu - Correct Answers -The list of frequently using Excel commands
available when a user right-clicks an item in the worksheet
Fill Handle - Correct Answers -Small black square in the lower-right corner of the heavy
border of an active cell that repeats a cell's value in adjacent cells
Range - Correct Answers -Refers to a group of selected cells that may be formatted,
moved, copied or deleted as a group
Ex. Sharon's spreadsheet contains information about the number of music downloads in
F1:F25. F1:F25 represents a: _____
Label - Correct Answers -Ex. Joan is creating a table that will include demographic
information about her employees. What is each header in her table considered?
Ex. Jennifer needs to identify the values in column B for a sales report. Which type of
entry should she use in the column header?
Ex. Jennifer needs to identify the values in column B for a statistics report. Which type
of entry should she use in the column header?
AutoComplete - Correct Answers -Microsoft Excel feature that automatically inserts data
into a cell that begins with the same characters as a previous entry
Cut - Correct Answers -Command on the "Home Ribbon" that allows data to be moved
from one worksheet location to another
Ex. 33. Alicia needs to move the data in cell B5 to cell E5. Which command would she
select?
