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) 
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 
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. 
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 
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

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.

Business Documents With Word

Presentations With Powerpoint

Publications With Publisher

Databases With Access

Desktop Information Management With Outlook

Filters

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.

Business Documents With Word

Presentations With Powerpoint

Publications With Publisher

Databases With Access

Desktop Information Management With Outlook

Filters