TeacherWeb®

Your Name:

1) You can rotate text counterclockwise by entering a number between 1 and 180 on the Alignment sheet in the Format Cells dialog box.
True False
2) If you drag the fill handle to the left or up, Excel will decrement the series.
True False
3) When pasting cells in a destination area, you are required to select the entire destination area before you click the Paste button.
True False
4) To insert multiple rows, insert a row by using the Insert command then repeatedly press F4.
True False
5) The move and copy command accomplish the same task.
True False
6) A date stamp shows the date a workbook or report was created, or the period it represents.
True False
7) F61 is an absolute reference, and $F$61 is a relative reference.
True False
8) The IF function is useful when you want to assign a value to a cell based on a logical test.
True False
9) The nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
True False
10) Even if you enter a formula in lowercase letters, Excel converts them to uppercase.
True False
11) The fill handle can be used to do which of the following?

Copy a cell
Copy a range of cells
Create a series of numbers or dates
All the above
12) Which of the following will decrease the indent by three spaces each time you click it?

Increase Indent button
Decrease Indent button
Format Cell
Format Line
13) The Copy button copies the contents and format of the source area to the ____________.

Office Clipboard
document of choice
destination area
all of the above
14) Which of the following is a valid format symbol?

Comma
Percent sign
Dollar sign
All of the above
15) To freeze worksheet titles use the ___________ button on the ___________ tab.

Titles, Format
Hold Panes, Window
Freeze Panes, Window
Freeze Panes, View
16) A cell reference of $B17 is a(n) ____________ cell reference.

absolute
relative
mixed
invalid
17) If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function =IF(E5>4*F5,“Deductions”,“No deductions”), then cell G5 displays the message, ____________.

Deductions
No deductions
#REF!
F5
18) Excel displays error messages that begin with ____________ to indicate when there is an error.

#
*
!
error
19) After you use the Insert command on the shortcut menu to insert a row, you can press ____________ to keep inserting rows.

F10
F4
INSERT
ENTER
20) The Goal Seeking command is located on the ____________ tab on the Ribbon.

Data
View
Format
Chart
21) After the Paste button is clicked, Excel displays the _______________ button.
Answer:
22) Using the mouse to move or copy cells is called _______________.
Answer:
23) The _______________ on the shortcut menu allows you to insert rows between rows that already contain data.
Answer:
24) The _______________ on the Insert gallery of the Insert button on the Ribbon allows you to insert a single cell or range of cells.
Answer:
25) Excel allows you to _______________, so that Excel displays the titles on the screen, no matter how far down you scroll.
Answer:
26) The _______________ returns a number that corresponds to the system date and time beginning with December 31, 1899.
Answer:
27) Excel uses a technique called _______________ to keep a cell reference constant when copying a formula or function.
Answer:
28) If the value you want to assign to a cell is dependent on a logical test, use the _______________.
Answer:
29) You can _______________ a slice of a 3-D pie chart to make it stand out from the rest.
Answer:
30) You can magnify or shrink the appearance of a worksheet or chart by using the _______________ button on the View tab on the Ribbon.
Answer:

Content on this site is the responsibility of the Subscriber. Additional information is available in the TeacherWeb Terms & Conditions

Excel_Quizzes_and_Reinforcement

Excel Reinforcement Ch.3