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