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
Cut
B
Copy
C
Clear
D
Format Painter
2) Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
A
Exit
B
Save As
C
Save
D
Open
3) Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A
AutoFill
B
AutoSpell
C
AutoCorrect
D
AutoComplete
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
AutoFill
B
Filter
C
Find and Replace
D
Sort
5) Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
A
Value
B
Label
C
Function
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 Entire Workbook
B
Print Selection
C
Print Active Sheet
D
Fit to One Page
8) Which would be used to help organize and identify Microsoft Excel files by providing details about the files?
A
File details
B
Document properties
C
Document options
D
File facts
9) Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
A
Range
B
Segment
C
Set
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
True Fit
B
Smart Fit
C
Best Fit
D
AutoFit
11) Sharon’s spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
A
row
B
range
C
cell
D
column
12) Alicia needs to delete the data in cell B5. Which command would she select?
A
Clear Contents
B
Cut
C
Format Painter
D
Copy
13) In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
A
Copy
B
Move
C
Cut
D
Paste
14) Which command on the Home ribbon allows data to be moved from one worksheet location to another?
A
Cut
B
Move
C
Copy
D
Duplicate
15) What is the process of using the mouse to move or copy cells called?
A
Drag and drop
B
Click and paste
C
Dragging
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
Quick Access Toolbar
D
Mini 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
Copy handle
B
Fill handle
C
Filler
D
Copy box
18) Which command on the Fill options dialog box is the default option if a month or day is entered?
A
Fill Series
B
Fill without Formatting
C
Copy Cells
D
Fill Formatting Only
19) When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
A
Left arrow key
B
Delete key
C
Enter key
D
Backspace 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?