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