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
Row
B
Column
C
Range
D
Cell
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
Column
B
Workbook
C
Row
D
Entry
3) Which of the following notebook- like features organizes the sheets for use in Excel?
A
Folder
B
Notepad
C
Worksheet
D
Workbook
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
Amplify Range
B
Magnify Area
C
Enlarge Selected Area
D
Zoom to Selection
5) Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
A
Row
B
Column
C
Entry
D
Workbook
6) What is the process of using the mouse to move or copy cells called?
A
Click and paste
B
Drag and drop
C
Dragging
D
Drag and move
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
Save
C
Open
D
Exit
8) What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
A
Zoom to Selection
B
Arrange All
C
Freeze Panes
D
New Window
9) Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
A
PowerPoint
B
Word
C
Excel
D
Publisher
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
functions
B
formulas
C
labels
D
values
11) Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
A
Worksheet
B
Notepad
C
Workbook
D
Folder
12) Sharon's spreadsheet contains information about the number of music downloads in F25. 25 identifies the:
A
Range
B
Row
C
Cell
D
Column
13) Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
A
Save
B
Open
C
Exit
D
Save As
14) Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A
AutoSpell
B
AutoCorrect
C
AutoComplete
D
AutoFill
15) What occurs when the cursor is moved over a cell and a user clicks?
A
The column is selected
B
The row is selected
C
The worksheet 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 Entire Workbook
B
Print Selection
C
Fit to One Page
D
Print Active Sheet
17) In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
A
Cute
B
Move
C
Paste
D
Copy
18) In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A
Smart Fit
B
AutoFit
C
True Fit
D
Best 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
Cell box
B
Address box
C
Name box
D
Formula 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
Filler
B
Fill handle
C
Copy handle
D
Copy box
*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?