Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.02
Test Description: Excel 2016
Instructions: Answer all questions to get your test result.
1) Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?
A
Workbook
B
Row
C
Column
D
Entry
2) Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
A
column
B
row
C
range
D
cell
3) What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
A
Quick Access Toolbar
B
Shortcut Toolbar
C
Mini Toolbar
D
Shortcut Menu
4) Alicia needs to delete the data in cell B5. Which command would she select?
A
Cut
B
Copy
C
Format Painter
D
Clear
5) John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?
A
Fit to One Page
B
Print Entire Workbook
C
Print Active Sheet
D
Print Selection
6) David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?
A
Filter
B
Find and Replace
C
AutoFill
D
Sort
7) What is the process of using the mouse to move or copy cells called?
A
Drag and drop
B
Drag and move
C
Click and paste
D
Dragging
8) Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
A
Function
B
Label
C
Value
D
Formula
9) Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
A
Label
B
Formula
C
Value
D
Function
10) Which command on the Home ribbon allows data to be moved from one worksheet location to another?
A
Cut
B
Move
C
Duplicate
D
Copy
11) Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
A
Cluster
B
Set
C
Segment
D
Range
12) Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
A
Cut
B
Format Painter
C
Clear
D
Copy
13) In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A
Best Fit
B
True Fit
C
AutoFit
D
Smart Fit
14) What is the name of the 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?
A
Copy handle
B
Filler
C
Copy box
D
Fill handle
15) Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A
AutoFill
B
AutoComplete
C
AutoCorrect
D
AutoSpell
16) When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
A
Enter key
B
Delete key
C
Backspace key
D
Left arrow key
17) Which would be used to help organize and identify Microsoft Excel files by providing details about the files?
A
File facts
B
Document properties
C
Document options
D
File details
18) In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
A
Cut
B
Move
C
Copy
D
Paste
19) Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
A
Save
B
Exit
C
Save As
D
Open
20) Which command on the Fill options dialog box is the default option if a month or day is entered?
A
Copy Cells
B
Fill Formatting Only
C
Fill Series
D
Fill without Formatting
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?