Question 1

To clear an area of the worksheet selected for printing you should use the _____ button.

Accepted Answer

A)  Deselect Area 
B)  Worksheet Area 
C)  Clear Area 
D)  Print Area 
A)  Deselect Area 
B)  Worksheet Area 
C)  Clear Area 
D)  Print Area

Question 2

Orientation refers to the absolute positions of the worksheet and the paper.

Accepted Answer

A) True 
 B)False

Question 3

Excel has many Page Setup options. Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.

Accepted Answer

- Portrait orientation prints a workshee

Question 4

To select a specific area of a worksheet to print, you should first use the _____ button.

Accepted Answer

A)  Select Area 
B)  Worksheet Area 
C)  Print Area 
D)  Area 
A)  Select Area 
B)  Worksheet Area 
C)  Print Area 
D)  Area

Question 5

To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.

Accepted Answer

A) True 
 B)False

Question 6

____________________ are the lines that separate one cell from another.

Accepted Answer

The answer of ____________________ are the lines that separate one...

Question 7

You can specify scaling to reduce or enlarge a worksheet for printing.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following operators can be used when filtering numbers?

Accepted Answer

A)  Like 
B)  Less Than 
C)  Identical 
D)  Less By More Than 
A)  Like 
B)  Less Than 
C)  Identical 
D)  Less By More Than

Question 9

_____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.

Accepted Answer

A)  Landscape 
B)  Portrait 
C)  Vertical Sheet 
D)  Horizontal Sheet 
A)  Landscape 
B)  Portrait 
C)  Vertical Sheet 
D)  Horizontal Sheet

Question 10

You can output worksheets as PDF files.

Accepted Answer

A) True 
 B)False

Question 11

Which one of the following recommendations applies to making the longest data sets go down the screen?

Accepted Answer

A)  Structure your data. 
B)  Make sure your data is entered accurately. 
C)  Remember the rules of mathematical precedence. 
D)  Use absolute and relative references appropriately. 
A)  Structure your data. 
B)  Make sure your data is entered accurately. 
C)  Remember the rules of mathematical precedence. 
D)  Use absolute and relative references appropriately.

Question 12

Use the Save As option to rename and save an extra copy of your worksheet.

Accepted Answer

A) True 
 B)False

Question 13

If your worksheet contains multiple pages, the margin settings apply _____.

Accepted Answer

A)  only to the current page 
B)  to the first two pages 
C)  to all the pages 
D)  to the specified pages 
A)  only to the current page 
B)  to the first two pages 
C)  to all the pages 
D)  to the specified pages

Question 14

_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.

Accepted Answer

A)  Frames 
B)  Cells 
C)  Divs 
D)  Tables 
A)  Frames 
B)  Cells 
C)  Divs 
D)  Tables

Question 15

Pages that contain cells that will not be printed are shown in _____.

Accepted Answer

A)  white 
B)  light blue 
C)  yellow 
D)  gray 
A)  white 
B)  light blue 
C)  yellow 
D)  gray

To clear an area of the worksheet selected for printing you should use the _____ button.

Orientation refers to the absolute positions of the worksheet and the paper.

Excel has many Page Setup options. Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.

To select a specific area of a worksheet to print, you should first use the _____ button.

To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.

____________________ are the lines that separate one cell from another.

You can specify scaling to reduce or enlarge a worksheet for printing.

Which of the following operators can be used when filtering numbers?

_____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.

You can output worksheets as PDF files.

Which one of the following recommendations applies to making the longest data sets go down the screen?

Use the Save As option to rename and save an extra copy of your worksheet.

If your worksheet contains multiple pages, the margin settings apply _____.

_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.

Pages that contain cells that will not be printed are shown in _____.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Creating a Presentation

Finalizing a Presentation

Creating a Database

Finalizing a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters

Exam 14: Finalizing a Worksheet

To clear an area of the worksheet selected for printing you should use the _____ button.

Orientation refers to the absolute positions of the worksheet and the paper.

Excel has many Page Setup options. Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.

To select a specific area of a worksheet to print, you should first use the _____ button.

To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.

____________________ are the lines that separate one cell from another.

You can specify scaling to reduce or enlarge a worksheet for printing.

Which of the following operators can be used when filtering numbers?

_____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.

You can output worksheets as PDF files.

Which one of the following recommendations applies to making the longest data sets go down the screen?

Use the Save As option to rename and save an extra copy of your worksheet.

If your worksheet contains multiple pages, the margin settings apply _____.

_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.

Pages that contain cells that will not be printed are shown in _____.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Creating a Presentation

Finalizing a Presentation

Creating a Database

Finalizing a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters