Deck 14: Finalizing a Worksheet

Question 1

Excel includes predefined headers, and you cannot create your own headers.

Answer 1

False

Question 2

You can hide rows or columns of data in a worksheet if the data they contain is confidential.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

To display rows or columns that are hidden, select the rows or columns that border the hidden section, then right-click and choose Show .

Question 5

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

Question 6

Specify page numbers on the right side of even numbered pages.

Question 7

To print multiple copies of the current worksheet use the FILE tab's Print option.

Question 8

To get a good view of the entire worksheet before you change the margins, you might want to increase the zoom level to more than 100%.

Question 9

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

Question 10

Like Word's spelling checker, Excel provides a grammar checker.

Question 11

Use the Zoom control to see the entire page.

Question 12

You can output worksheets as PDF files.

Question 13

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

Question 14

If the correct spelling appears in the Suggestions list, click to select it, then click the Replace button to correct the misspelled word.

Question 15

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

Question 16

Excel provides tools that allow you to sort data in ascending order only.

Question 17

You can use options on the ribbon to customize which elements of a worksheet will print.

Question 18

To add a flagged word to the spelling dictionary, click the Add to Dictionary button.

Question 19

Worksheet labels are the column letters and row numbers.

Question 20

When sorting data click a cell in the column after you click the desired sort button.

Question 21

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

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

Question 22

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

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

Question 23

If the correct spelling appears in the _____ list, click to select it.

A) Recommendations
B) Hints
C) Suggestions
D) Synonyms

Question 24

To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.

A) Proofing
B) Thesaurus
C) Changes
D) Research

Question 25

Which of the following buttons is used to specify additional sort levels?

A)
B)
C)
D)

Question 26

Which of the following buttons is used to sort the data in one column in descending order?

A)
B)
C)
D)

Question 27

To open the Sort dialog box, click the _____ tab, then click the Sort button.

A) HOME
B) VIEW
C) DATA
D) REVIEW

Question 28

A data management feature that allows you to focus on a subset of the data in a worksheet is called _____.

A) Selecting
B) Filtering
C) Extracting
D) Formatting

Question 29

You can adjust column widths while in _____ view.

A) Page Layout
B) Review
C) Page Preview
D) Page Setup

Question 30

It is a good idea to _____ your worksheet before performing a sort.

A) format
B) save
C) review
D) select

Question 31

To get a good view of an entire worksheet before you change margins, you might want to reduce the zoom level to less than _____.

A) 80%
B) 100%
C) 75%
D) 50%

Question 32

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

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

Question 33

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

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

Question 34

Use the _____ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.

A) Number Filters
B) String Filters
C) Text Filters
D) Character Filters

Question 35

Which of the following is the Margins button?

A)
B)
C)
D)

Question 36

If you are sure the word is spelled correctly and appears multiple times in your worksheet, click the _____ button if you want to ignore all occurrences of this word throughout the entire worksheet.

A) Ignore All
B) Disregard All
C) Ignore Once
D) Disregard Once

Question 37

If data becomes scrambled as a result of a sort, click the _____ button.

A) Undo
B) Save
C) Repeat
D) Sort

Question 38

Which of the following buttons is used to filter numbers?

A)
B)
C)
D)

Question 39

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

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

Question 40

Which of the following words may not be recognized by Excel?

A) Price
B) Jeremy
C) Quantity
D) Cash

Question 41

In the accompanying figure, which callout points to the option that allows you to change the default printing option, which prints the active worksheet?

A) A
B) B
C) C
D) D

Question 42

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

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

Question 43

In the accompanying figure, which callout points to the area you should click in the worksheet to exit Header/Footer mode?

A) E
B) G
C) C
D) F

Question 44

In the accompanying figure, which callout points to the button you should click to select header and footer options?

A) F
B) C
C) D
D) B

Question 45

Which of the following buttons should you click to specify label titles that should be repeated on every page?

A)
B)
C)
D)

Question 46

Referring to the accompanying figure, which callout points to the button that starts printing?

A) H
B) F
C) D
D) B

Question 47

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

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 48

Which of the following is the normal Excel file format?

A) .excl
B) .xlsx
C) .xcl
D) .exl

Question 49

What should be avoided when developing worksheets?

A) formatting numbers for easy reading
B) circular references
C) using consistent formats for similar data
D) using meaningful labels

Question 50

If you want headings displayed and printed, make sure there are checkmark(s) in _____.

A) the Headings View box
B) the Print box
C) both the Headings View and Print boxes
D) none of the above

Question 51

Which of the following buttons is used to insert manual page breaks?

A)
B)
C)
D)

Question 52

You can output Excel worksheets as PDF files using the _____ option on the FILE tab.

A) Export
B) Import
C) Send to PDF
D) Transmit

Question 53

In the accompanying figure, which callout points to the area you should click first when adding a header or footer?

A) D
B) G
C) C
D) A

Question 54

Referring to the accompanying figure, which callout points to the control that allows you to preview each page?

A) G
B) D
C) C
D) E

Question 55

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

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

Question 56

You can use the FILE tab's Share option to save a worksheet in Excel format to Microsoft's Internet-based _____ and allow others to view it.

A) iCloud
B) Live Connect
C) SkyDrive
D) Dropbox

Question 57

In the accompanying figure, which callout points to the group of buttons used to add header elements?

A) F
B) C
C) D
D) B

Question 58

If you want formulas to be printed, click the _____ button on the FORMULAS tab.

A) View Formulas
B) Show Formulas
C) Display Formulas
D) Print Formulas

Question 59

In Page layout view, gridlines are shown in _____.

A) light gray
B) light blue
C) black
D) red

Question 60

You should select _____ margins if you want to control the space allocated for headers and footers.

A) Margins
B) Predefined Margins
C) Custom Margins
D) Build Margins

Question 61

____________________ orientation prints a worksheet on the page sideways.

Question 62

Use the ____________________ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.

Question 63

You might want to insert a manual ____________________ if a page ends with a row that should be grouped with data on the next page.

Question 64

The Options button offers several useful settings for headers and footers. List some suggestions on how to use them.

Question 65

Excel's ____________________ view helps you refine the appearance of a worksheet before you print it.

Question 66

Case-Based Critical Thinking Questions Case 14-1 Max wants to save a worksheet as a Web page. What should he do? Part of Max's worksheet contains formatting that cannot be duplicated in a Web page. He is notified of the problem areas and is given the option of _____.

A) canceling
B) continuing with the save
C) both canceling and continuing with the save
D) either canceling or continuing with the save

Question 67

____________________ is a data management feature that allows you to focus on a subset of the data in a worksheet.

Question 68

Case-Based Critical Thinking Questions Case 14-1 Max wants to save a worksheet as a Web page. What should he do? To make sure that his worksheet will work as a Web page, Max should preview his worksheet in _____ prior to posting the file online.

A) a Web browser
B) Print Preview
C) Microsoft Word
D) Microsoft Excel

Question 69

____________________ are the lines that separate one cell from another.

Question 70

Case-Based Critical Thinking Questions Case 14-1 Max wants to save a worksheet as a Web page. What should he do? In the Save As dialog box, Max should save his Excel file as a(n) _____ file type.

A) HTTP
B) HTML
C) XML
D) JS

Question 71

If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.

Question 72

You should always ____________________ your worksheets before relying on the results.

Question 73

The ____________________ button allows you to clear the print area setting so that the entire worksheet prints.

Question 74

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

Question 75

You can test your worksheet by entering a set of ____________________ values for which you already know the results.