Deck 18: Organizing and Enhancing Worksheets

Question 1

You can base a sort on as many as six columns.

Answer 1

False

Question 2

When you split a worksheet horizontally, the panes appear side by side on the screen.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

An alternative way to freeze rows and columns is to ____ a worksheet, which divides the worksheet into two panes.

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

Question 5

By using fields in headers or footers instead of manually entering information, the information is always updated automatically.

Question 6

When you freeze rows and columns, the data remains intact; it's just not visible on the screen.

Question 7

Spreadsheets can function as basic databases.

Question 8

When you want to add a new category to an Excel workbook, you click the ____ at the bottom of the screen.

A) Split box
B) Insert Worksheet button
C) Zoom settings
D) Sheet tab

Question 9

Zoom settings allow you to change the magnification.

Question 10

When you delete the contents of a cell using the Delete key or the Backspace key, the formats for the cell remain in the cell.

Question 11

A ____ contains column headings or field names in a data source, such as a table or spreadsheet.

A) filter
B) sheet tab
C) header row
D) workbook

Question 12

____ at the bottom of the screen provide quick and easy access to worksheets.

A) Buttons
B) Binders
C) Workbooks
D) Sheet tabs

Question 13

A cell style is a set of predefined formats you can apply to some of the worksheet data, such as a header row, a cell showing a total, or cells showing the date and time.

Question 14

In Excel, the header row provides labels which identify the content in the worksheet columns.

Question 15

When you apply a table style, the selected cells are converted to an Excel table.

Question 16

You can use multiple fonts in one document.

Question 17

You cannot rename sheet tabs.

Question 18

The default Currency format has two decimal places and a dollar sign.

Question 19

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

Question 20

The ____ allows you to remove the contents and the formatting in a cell.

A) Delete key
B) Backspace key
C) Sort & Filter button
D) Clear button

Question 21

Commands for changing print settings are located on the ____ tab.

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

Question 22

Case 18-1 Martha is a high school math teacher. She has created a worksheet to track her students' grades. She added two new students to the worksheet today and she wants to make sure the formatting is consistent. Which button should Martha use to add a black line to the bottom of a row of cells that contain the midterm exam grades?

A) Font
B) Border
C) Fill Color
D) Font Color

Question 23

____ can be used to insert dates, times, filenames, the file path, and page numbers automatically.

A) Footers
B) Filters
C) Fields
D) Headers

Question 24

Which button can you use to change the number format from .10 to .1 in a cell?

A) Percent Style
B) Comma Style
C) Increase Decimal
D) Decrease Decimal

Question 25

The ____ button spans text across several columns.

A) Center
B) Orientation
C) Wrap Text
D) Merge & Center

Question 26

____ provide useful information on a printed worksheet and are printed in the top margin of every worksheet page.

A) Footers
B) Headers
C) Fields
D) Filters

Question 27

Case 18-2 Sam is viewing a very large worksheet that contains product data for the warehouse where he works. He is getting frustrated trying to locate data. He tried splitting the worksheet, but that didn't help him find what he was looking for. Sam has selected a range of cells he wants to freeze. Which option will allow him to freeze panes based on selected cells?

A) Freeze Panes
B) Freeze Top Row
C) Freeze First Column
D) Selection

Question 28

Which button allows you to align text at an angle within a cell?

A) Merge & Center
B) Middle Align
C) Orientation
D) Wrap Text

Question 29

Case 18-1 Martha is a high school math teacher. She has created a worksheet to track her students' grades. She added two new students to the worksheet today and she wants to make sure the formatting is consistent. Which button should she use to copy the formatting of a cell without copying the contents of the cell?

A) Format Painter
B) Copy
C) Paste
D) Format

Question 30

FIGURE 18-2 Which button is the black arrow pointing to in Figure 18-2 above?

A) Wrap Text
B) Merge & Center
C) Orientation
D) Sort & Filter

Question 31

When the header row scrolls out of view, it is difficult to identify the data. Which of the following is not an option to help overcome this problem?

A) Zoom settings
B) Hide rows and columns
C) Freeze panes
D) Sort data

Question 32

Case 18-2 Sam is viewing a very large worksheet that contains product data for the warehouse where he works. He is getting frustrated trying to locate data. He tried splitting the worksheet, but that didn't help him find what he was looking for. How can Sam remove the dividing line in the split worksheet?

A) Right-click it
B) Press the Delete button
C) Double-click it
D) Click the Remove Split button

Question 33

A key feature of Microsoft Excel is the ease with which you can ____.

A) print worksheets
B) scroll through a worksheet
C) enter data
D) organize the data in a worksheet

Question 34

FIGURE 18-1 What is pictured in Figure 18-1 above?

A) A worksheet with frozen rows and columns
B) A worksheet with hidden rows and columns
C) A worksheet with merged rows and columns
D) A worksheet split into two panes

Question 35

The ____ command scales the worksheet up or down as necessary so it fits on the number of pages you designate.

A) Print Area
B) Print Titles
C) Orientation
D) Fit to

Question 36

Which button opens the Quick Styles gallery filled with table styles?

A) Print Area
B) Convert to Range
C) Format as Table
D) Cell styles

Question 37

If text doesn't fit on one line, you can use the ____ button to allow all the text to wrap to new lines within the cell.

A) Clear
B) Merge & Center
C) Orientation
D) Wrap Text

Question 38

Which option in the Print dialog box enables you to print only selected cells in the active worksheet?

A) Active sheet
B) Entire workbook
C) Selection
D) Table

Question 39

The ____ button allows you to combine several cells into a single cell.

A) Clear
B) Merge & Center
C) Borders
D) Wrap Text

Question 40

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

Question 42

Explain the difference between sorting and filtering data and give an example of when each should be used.

Question 43

____________________ orientation formats the document sideways with the long edge of the page at the top.

Question 44

A(n) ____________________ style is a set of predefined formats that you can apply to all the worksheet data with a single click.

Question 45

A(n) ____________________ is the design of the typeface in a document.

Question 46

When you ____________________ data, you screen data that matches specified criteria.