Question 1

To print a wide spreadsheet, change the orientation to ____________________.

Accepted Answer

The answer of To print a wide spreadsheet, change the...

Question 2

To average the range beginning with B6 and ending with B8, key

Accepted Answer

A)  =B6+B7+B8 
B)  =B6..B8/3 
C)  =average(B6:B8) 
D)  average(B6..B8)

Question 3

The entry 906 West Palm Street would be interpreted by Excel as a number.

Accepted Answer

A) True 
 B)False

Question 4

The Range command is used in Excel to move to a specific part of a document.

Accepted Answer

A) True 
 B)False

Question 5

Chart sheets are displayed

Accepted Answer

A)  on the same page as the worksheet 
B)  on a separate sheet of the worksheet 
C)  in an entirely new file 
D)  none of the above

Question 6

If a cell displays with ####, the

Accepted Answer

A)  entry has been keyed incorrectly 
B)  cell must be formatted correctly 
C)  cell is not wide enough for the entry 
D)  cell is too wide for the entry.

Question 7

Columns include information arranged horizontally.

Accepted Answer

A) True 
 B)False

Question 8

Which command is used to repeat the column headings on the second page of a spreadsheet?

Accepted Answer

A)  Print Titles 
B)  Freeze Titles 
C)  Freeze Panes 
D)  Repeat Titles

Question 9

The entry of a Social Security number (555-55-5555) would be interpreted by Excel as text.

Accepted Answer

A) True 
 B)False

Question 10

In Page Break Preview, dashed lines display automatic page breaks.

Accepted Answer

A) True 
 B)False

Exam 3: Spreadsheets With Excel

To print a wide spreadsheet, change the orientation to ____________________.

To average the range beginning with B6 and ending with B8, key

The entry 906 West Palm Street would be interpreted by Excel as a number.

The Range command is used in Excel to move to a specific part of a document.

Chart sheets are displayed

If a cell displays with ####, the

Columns include information arranged horizontally.

Which command is used to repeat the column headings on the second page of a spreadsheet?

The entry of a Social Security number (555-55-5555) would be interpreted by Excel as text.

In Page Break Preview, dashed lines display automatic page breaks.