Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Chapter 1 Review
Test Description: Excel Chap. 1
Instructions: Answer all questions to get your test result.
1) Autocalculate area dislplays the average of the numbers in the selected range.
A
Average
B
Min
C
Sum
D
Count
2) Autocalculate area displays the number on nonblank cells in the selected range
A
Average
B
Sum
C
Count
D
Numerical count
3) Autocalculate area displays the number of cells containing numbers in the selected range
A
Sume
B
Average
C
Count
D
Numerical count
4) Autocalculate area displays the lowest value in the selected range
A
Maximum
B
Count
C
Minimum
D
Sum
5) Autocalculate area displays the highest value in the selected range
A
Maximum
B
Minimum
C
Sum
D
Count
6) Autocalculate area displays the sum of the numbers in the selected range
A
Count
B
Sum
C
Average
D
Numerical count
7) Selects the cell on worksheet window to the the right and moves the worksheet window accordingly
A
alt+end
B
alt+ page down
C
ctrl+end
D
alt+home
8) Selects the cell on worksheet window to the left and moves the worksheet window accordingly
A
alt+page up
B
ctrl+page up
C
alt+home
D
ctrl+alt+home
9) Selects the adjacent cell in the direction of the arrow on the key
A
enter
B
arrow
C
space
D
tab
10) Selects the border cell of the worksheet in combination with the arrow keys and moves the worksheet window accordingly
A
ctrl+space
B
ctrl+arrow
C
alt+tab
D
alt+arrow
11) To cancel an entire entry before entering it into the cell, press the _____ key.
A
ESC
B
ALT
C
CTRL
D
TAB
12) The ________ is a blinking vertical line that indicates where the next typed character will appear.
A
split bar
B
scroll box
C
sheet tab
D
insertion point
13) You _____ a worksheet to emphasize certain entries and make the worksheet earsier to read and understand.
A
format
B
clear
C
save
D
print
14) Which of the following is the Ribbon path to the Cell Syles button?
A
(Format tab|Styles Group)
B
(Home tab|Format Group)
C
(Home tab|Styles Group)
D
(Styles tab|Home Group)
15) Which of the following keys is an alternative to double-clicking the cell to edit it?
A
F4
B
F1
C
F3
D
F2
16) Excel remembers the last_______ actions you have completed.
A
25
B
50
C
100
D
75
17) You should press the SPACEBAR to clear a cell.
A
False
B
True
18) Which of the following keys moves the inserion point to the end of data in a cell?
A
DELETE
B
BACKSPACE
C
HOME
D
END
19) Which effect does the Comma Style format have on the selected cells?
A
Allows for substitiution of selected characters
B
Converts decimals to commas within merged cells
C
Converts decimals to commas within a cell.
D
Displays cell contents with two decimal places and commas as thousands separators
20) With Excel in Edit mode, you can edit cell content directly in the cell.
A
True
B
False
*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?