Deck 7: Finalizing a Worksheet

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

You can output worksheets as PDF files.

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

Worksheet labels are the column letters and row numbers.

Question 13

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

Question 14

Use the Zoom control to see the entire page.

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

Which of the following buttons is used to filter numbers?

A)
B)
C)
D)

Question 23

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 24

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

A)
B)
C)
D)

Question 25

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

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

Question 26

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 27

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 28

_____ 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 29

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

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

Question 30

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 31

You can adjust column widths while in _____ view.

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

Question 32

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 33

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

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

Question 34

Which of the following is the Margins button?

A)
B)
C)
D)

Question 35

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

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

Question 36

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

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

Question 37

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 38

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 39

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

A)
B)
C)
D)

Question 40

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 41

In Page layout view, gridlines are shown in _____.

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

Question 42

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 43

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 44

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 45

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 46

_____ 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 47

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 48

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

A)
B)
C)
D)

Question 49

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

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

Question 50

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 51

Which of the following is the normal Excel file format?

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

Question 52

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 53

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 54

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

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

Question 55

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

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

Question 56

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 57

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 58

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 59

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 60

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

A)
B)
C)
D)

Question 61

Case-Based Critical Thinking Questions Case 7-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 62

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

Question 63

Case-Based Critical Thinking Questions Case 7-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 64

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

Question 65

____________________ orientation prints a worksheet on the page sideways.

Question 66

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

Question 67

____________________ are the lines that separate one cell from another.

Question 68

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

Question 69

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

Question 70

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 71

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

Question 72

Case-Based Critical Thinking Questions Case 7-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 73

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

Question 74

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 75

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