Excel Chapter 1 Review Question Preview (ID: 33382)


Excel Chap. 1. TEACHERS: click here for quick copy question ID numbers.

Selects the adjacent cell in the direction of the arrow on the key
a) arrow
b) space
c) tab
d) enter

Selects the border cell of the worksheet in combination with the arrow keys and moves the worksheet window accordingly
a) ctrl+arrow
b) ctrl+space
c) alt+arrow
d) alt+tab

Selects the cell on worksheet window to the the right and moves the worksheet window accordingly
a) alt+ page down
b) alt+home
c) alt+end
d) ctrl+end

Selects the cell on worksheet window to the left and moves the worksheet window accordingly
a) alt+page up
b) alt+home
c) ctrl+page up
d) ctrl+alt+home

Autocalculate area displays the sum of the numbers in the selected range
a) Sum
b) Count
c) Average
d) Numerical count

Autocalculate area displays the lowest value in the selected range
a) Minimum
b) Maximum
c) Sum
d) Count

Autocalculate area displays the highest value in the selected range
a) Maximum
b) Minimum
c) Sum
d) Count

Autocalculate area displays the number of cells containing numbers in the selected range
a) Numerical count
b) Count
c) Sume
d) Average

Autocalculate area dislplays the average of the numbers in the selected range.
a) Average
b) Sum
c) Count
d) Min

Autocalculate area displays the number on nonblank cells in the selected range
a) Count
b) Average
c) Numerical count
d) Sum

To cancel an entire entry before entering it into the cell, press the _____ key.
a) ESC
b) ALT
c) CTRL
d) TAB

The ________ is a blinking vertical line that indicates where the next typed character will appear.
a) insertion point
b) scroll box
c) sheet tab
d) split bar

You _____ a worksheet to emphasize certain entries and make the worksheet earsier to read and understand.
a) format
b) save
c) print
d) clear

Which of the following is the Ribbon path to the Cell Syles button?
a) (Home tab|Styles Group)
b) (Styles tab|Home Group)
c) (Home tab|Format Group)
d) (Format tab|Styles Group)

Which of the following keys is an alternative to double-clicking the cell to edit it?
a) F2
b) F1
c) F3
d) F4

Excel remembers the last_______ actions you have completed.
a) 100
b) 75
c) 50
d) 25

You should press the SPACEBAR to clear a cell.
a) False
b) True
c)
d)

Which of the following keys moves the inserion point to the end of data in a cell?
a) END
b) HOME
c) DELETE
d) BACKSPACE

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) Allows for substitiution of selected characters
c) Converts decimals to commas within merged cells
d) Converts decimals to commas within a cell.

With Excel in Edit mode, you can edit cell content directly in the cell.
a) True
b) False
c)
d)

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 33382 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register