Deck 19: Organizing and Enhancing Worksheets

Question 1

By default, new blank workbooks include ____ worksheets.

A) zero
B) one
C) two
D) three

Answer 1

D

Question 2

The Freeze Panes button is on the View tab.

Answer 2

True

Question 3

When you use the Cut and Copy commands, the data and formats are also moved or copied.

Answer 3

True

Question 4

Excel automatically adjusts the cell width when the font size changes.

Question 5

When you freeze columns and rows, the worksheet is divided into two panes.

Question 6

Which of the following is NOT true about working with multiple worksheets?

A) When you need to add a new category to a workbook, you add a new worksheet.
B) Sheet tabs are located at the top of the workbook window.
C) You can copy and paste data from one worksheet to another.
D) All of the above are true.

Question 7

The default Fit to command setting is 100% .

Question 8

By default, Excel prints comments that are added to the worksheet.

Question 9

When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.

Question 10

You can use the Format Painter feature to copy formats.

Question 11

Conditional formatting applies designated formats to cells when the cell value meets specified criteria.

Question 12

The default Zoom setting is 75%.

Question 13

When you sort data, you screen data that matches specified criteria; the data that does not meet the criteria is hidden.

Question 14

After converting a range of cells to an Excel database , you can manage and calculate the data independently.

Question 15

Common uses of spreadsheets include reporting finances and managing expenses.

Question 16

When you ____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

A) split
B) freeze
C) hide
D) unhide

Question 17

In the above figure, the worksheet has been ____.

A) merged
B) frozen
C) split
D) unhidden

Question 18

A(n) ____ contains column headings or field names in a data source.

A) header row
B) column header
C) table header
D) footer

Question 19

If the text does not fit on one line of a cell, you can wrap to new lines.

Question 20

To remove a split in a worksheet, double-click the dividing line.

Question 21

By default, Excel aligns numbers at the ____ of the cell.

A) right
B) left
C) center
D) top

Question 22

Which of the following is NOT true about default print options in Excel?

A) Gridlines, row numbers, and column letters are printed.
B) Excel prints the entire worksheet
C) When you create a print area, the print setting is saved with the workbook.
D) You can choose to print the row and/or column headings on every page.

Question 23

Which of the following is NOT true about changing the page setup?

A) Page Break Preview shows you how the worksheet will be printed.
B) You can drag the page break to a new location.
C) The default setting is landscape orientation.
D) The Fit to command fits the worksheet to a specific number of pages.

Question 24

To change the angle of the text direction, click the ____________________ button.

Question 25

A(n) ____________________ is information and/or graphics that are printed in the top margin of a worksheet.

Question 26

The font size is a measurement in ____ that determines the height of the font.

A) characters
B) points
C) pixels
D) millimeters

Question 27

When you ____________________ rows and columns, the data remains intact; it is just not visible on the screen.

Question 28

You can easily change the print settings using commands in the ____.

A) Page Layout dialog box
B) Backstage view
C) Home tab
D) Either A or B.

Question 29

Which of the following is NOT true about table styles?

A) If you convert the table to a regular range, the table style formatting is removed.
B) A table style is a set of predefined formats you can apply to worksheet data.
C) You can choose from 60 table styles in the Quick Styles gallery.
D) All of the above are true.

Question 30

Which of the following is NOT true about changing alignment?

A) By default, Excel aligns text at the left of the cell.
B) You can adjust the alignment of the content of a cell vertically.
C) You can decrease the margin between the edge of the cell and cell contents.
D) All of the above are true.

Question 31

____________________ can be used to automatically insert dates, times, filenames, and more in a header or footer.

Question 32

A(n) ____ is the design of the typeface.

A) point
B) style
C) font
D) format

Question 33

Cate has finished entering data and formatting her worksheet and is ready to print and share it with others. Cate wants to share her workbook electronically, but doesn't want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.

A) PDF
B) HTML
C) .xlsx
D) template

Question 34

To remove the contents and the formats from the cell, you need to ____________________ the cell.

Question 35

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.

A) hides
B) filters
C) freezes
D) splits

Question 36

The header and footer commands are located on the ____ tab.

A) Home
B) File
C) Page Layout
D) Insert

Question 37

Cate has finished entering data and formatting her worksheet and is ready to print and share it with others. Cate wants to print her workbook. By default, which of the following will print?

A) Comments
B) Header row
C) Column letters
D) Gridlines

Question 38

Santiago has entered data in his worksheet and is working on fine-tuning the display. Santiago applies conditional formatting. Which of the following is NOT one of the options?

A) Data Bars
B) Color Scales
C) Quick Styles
D) Icon Sets

Question 39

The default date style is ____.

A) 1/20/14
B) 1-20-2014
C) 20-Jan-14
D) January 20, 2014

Question 40

Which of the following is TRUE about the figure above?

A) The workbook is in Page Break Preview.
B) The workbook is split.
C) The workbook contains hidden columns.
D) There are frozen panes.

Question 45

How many worksheets are contained in a blank workbook by default? Why would you add a new worksheet to a workbook? What do you click to display a different worksheet? Can you copy and paste data from one worksheet to another? List at least one method for inserting a new worksheet. What happens when you delete a tab for a worksheet that contains data?