Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 1.01-1.02 (Part 1)
Test Description: Standards 1.01-1.02
Instructions: Answer all questions to get your test result.
1) Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
A
Column
B
Cell
C
Row
D
Range
2) 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?
A
Workbook
B
Column
C
Row
D
Entry
3) Which of the following notebook- like features organizes the sheets for use in Excel?
A
Folder
B
Workbook
C
Worksheet
D
Notepad
4) What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?
A
Magnify Area
B
Amplify Range
C
Zoom to Selection
D
Enlarge Selected Area
5) Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
A
Entry
B
Column
C
Workbook
D
Row
6) What is the process of using the mouse to move or copy cells called?
A
Drag and move
B
Dragging
C
Click and paste
D
Drag and drop
7) Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
A
Save As
B
Open
C
Save
D
Exit
8) What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
A
New Window
B
Freeze Panes
C
Arrange All
D
Zoom to Selection
9) Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
A
Excel
B
Word
C
Publisher
D
PowerPoint
10) Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header?
A
formulas
B
values
C
labels
D
functions
11) Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
A
Folder
B
Notepad
C
Workbook
D
Worksheet
12) Sharon's spreadsheet contains information about the number of music downloads in F25. 25 identifies the:
A
Cell
B
Range
C
Row
D
Column
13) Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
A
Save As
B
Open
C
Exit
D
Save
14) Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A
AutoComplete
B
AutoCorrect
C
AutoFill
D
AutoSpell
15) What occurs when the cursor is moved over a cell and a user clicks?
A
The row is selected
B
The worksheet is selected
C
The column is selected
D
The cell is selected
16) 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
Fit to One Page
C
Print Active Sheet
D
Print Entire Workbook
17) In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
A
Paste
B
Copy
C
Cute
D
Move
18) In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A
Best Fit
B
AutoFit
C
True Fit
D
Smart Fit
19) Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
A
Address box
B
Name box
C
Formula box
D
Cell box
20) 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
Copy box
C
Fill handle
D
Filler
*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?