Microsoft Excel

1
Microsoft Excel

• Quick Clicker Review

2
An arrangement of data (words and/or numbers) in
rows and columns is called a

• Letter
• Memo
• Report
• Table

3
Columns with words are usually aligned

• Left
• Right
• Center
• Justify

4
Columns with numbers are usually aligned

• Left
• Right
• Center
• Justify

5
The row height can be changed in

• Table, AutoFormat
• Table, Insert, Height
• Table Properties, Cell, key in height
• Table Properties, Row, key in height
• Row height cannot be changed

6
Which of the following is true of a secondary
heading or title?

• Usually keyed in capital and lower case (title
  case) and centered below the main title
• Usually keyed in upper case and center below the
  main title
• Usually keyed in upper case and center above the
  main title
• Usually placed in the footer after the main title
  is placed in the header

7
If information has been left out of a table, you

• Must move all of the information down to make
  room for left out information
• Can insert a row from the menu (Table, Insert,
  Row)
• Must start your table over because it cannot be
  adjusted
• None of the above

8
The row height of a table

• Should be greater for title rows than data rows
• Should be smaller for title rows than data rows
• Should be the same on every row
• Should never be adjusted

9
To center a table vertically on a page

• File, Page setup, Margins, Center
• Center using the bottom of the toolbar
• Table, Table Properties, Table, Center
• File, Page Setup, Layout, Vertical Alignment,
  Center

10
The words at the top of each column describing
the information in the column are called

• Column headings
• Row headings
• Secondary titles
• Titles

11
The source note is included on a table to inform
the reader of

• The content of the table (what the table is
  about)
• The formats used in the table
• Where the information was found (book, Internet
  site, article, etc.)
• Where the table is saved

12
To shade an area on a table, go to

• File, Page Setup, Shading
• Format, Borders and Shading
• Table, Table Properties, Shade
• Edit, Insert Shading

13
If you assign the value 42 to cell E5, the value
11 to cell F5, and cell G5 contains the
functionIF (E5.4F5,Deductions,No
deductions), then cell G5 displays the message.

• Deductions
• No Deductions
• Ref!
• F5

14
Use the _________ function, when the value you
want to assign to a cell is dependent on a
logical test.

• ASSIGN
• IF, THEN, ELSE
• WHAT IF
• IF

15
A cell reference of B17 is a(n) ________ cell
reference.

• absolute
• relative
• mixed
• invalid

16
You can use the Split command to split a window
into _______.

• Two horizontal panes
• Two vertical panes
• Four panes
• All of the above

17
If cell E8 contains the label, Qtr 4, and you
select cell E8 and then drag the fill handle to
the left, then cells D8, C8,and B8 will contain
the labels _______.

• Qtr 5, Qtr 6, Qtr 7
• Qtr 1, Qtr 2, Qtr 3
• Qtr 3, Qtr 3, Qtr 3
• Ref!

18
When copying a range of cell using the drag and
drop method, you first point to the border of the
selected range so that the mouse pointer changes
to a(n) _____.

• crosshair
• arrow
• Block plus sign
• Split double arrow

19
To freeze worksheet titles use the _____ command
on the ________ menu.

• Split, Format
• Split, Window
• Freeze Panes, Window
• Freeze Planes, Tools

20
Excel displays the error message __________ to
indicate when there is a cell reference error.

• ref!
• error

21
You can use the Shadow button on the _______
toolbar to add a drop shadow to a cell.

• Standard
• Drawing
• Formatting
• Chart

22
To change the elevation of a selected pie chart,
click ______ on the Chart menu.

• Format Data Series
• 3-D View
• Format 3-D Pie Group
• Chart Type

23
True or False

• The choose is yours!

24
The paste button copies the oldest, or the first,
item copied on the Office Clipboard to the
destination area.

• True
• False

25
To copy text, Monday, in cell B1 to all the cells
in the range C1G1, drag the fill handle from
cell B1 to cell G1 while holding down the CTRL
Key.

• True
• False

26
You can paste the latest item copied to the
Office Clipboard by pressing the ENTER key.

• True
• False

27
The Increase Indent button indents the contents
of a cell to the right by 5 spaces each time you
click it.

• True
• False

28
You can rotate text counterclockwise by entering
a number between 1o and 90o on the Alignment
sheet in the Format Cells dialog box.

• True
• False

29
You can goal seek on up to three cells at a time
using the Goal Seek command.

• True
• False

30
You may copy a cells format by using the Format
Painter button located on the Formatting toolbar.

• True
• False

31
You can split a window into a maximum of four
panes.

• True
• False

32
F61 is an absolute reference, and F61 is a
relative reference.

• True
• False

33
If you assign the IF function IF(B2gtB3,25,1) to
cell B12, and cells B2 and B3 are equal to 5000,
then Excel displays the value 25 in cell B12.

• True
• False

34
Study for your Test!