Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Core 1.02
Test Description: 1.02
Instructions: Answer all questions to get your test result.
1) Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
A
Clear
B
Format Painter
C
Cut
D
Copy
2) Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
A
Open
B
Save As
C
Exit
D
Save
3) Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A
AutoSpell
B
AutoComplete
C
AutoFill
D
AutoCorrect
4) 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
Find and Replace
B
Filter
C
Sort
D
AutoFill
5) Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
A
Label
B
Function
C
Value
D
Formula
6) 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
Value
B
Function
C
Label
D
Formula
7) 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
Fit to One Page
D
Print Entire Workbook
8) Which would be used to help organize and identify Microsoft Excel files by providing details about the files?
A
File details
B
File facts
C
Document options
D
Document properties
9) Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
A
Set
B
Segment
C
Range
D
Cluster
10) In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A
Smart Fit
B
Best Fit
C
True Fit
D
AutoFit
11) Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
A
cell
B
row
C
column
D
range
12) Alicia needs to delete the data in cell B5. Which command would she select?
A
Clear Contents
B
Copy
C
Format Painter
D
Cut
13) 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
Paste
D
Copy
14) Which command on the Home ribbon allows data to be moved from one worksheet location to another?
A
Duplicate
B
Move
C
Cut
D
Copy
15) What is the process of using the mouse to move or copy cells called?
A
Dragging
B
Click and paste
C
Drag and drop
D
Drag and move
16) What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
A
Shortcut Menu
B
Shortcut Toolbar
C
Mini Toolbar
D
Quick Access Toolbar
17) 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
Fill handle
B
Copy handle
C
Copy box
D
Filler
18) 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
19) When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
A
Backspace key
B
Left arrow key
C
Enter key
D
Delete key
*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?