Holly Harper
Quiz by , created more than 1 year ago

Excel 1 final review

11
0
0
Holly Harper
Created by Holly Harper almost 4 years ago
Close

Excel 1

Excel 1

Question 1 of 20

1

Which of the following is a set of formatting elements that includes font style, size, color, alignment, borders, and fill, as well as number formats?

Select one of the following:

  • cell style

  • range style

  • worksheet style

  • workbook style

Explanation

Question 2 of 20

1

Which of the following is not an element in an Excel function?

Select one of the following:

  • argument

  • function name

  • syntax

  • =

Explanation

Question 3 of 20

1

What are Excel's default top and bottom margin settings?

Select one of the following:

  • 0.25

  • 0.5

  • 0.75

  • 1

Explanation

Question 4 of 20

1

Which of the following does not occur when a label in a cell is longer or wider than the cell?

Select one of the following:

  • The label spills into an empty adjacent cell.

  • An error message displays.

  • If adjacent cells are not empty, the label is truncated.

  • The Formula bar displays the entire entry regardless of length.

Explanation

Question 5 of 20

1

Which of the following is not true when adjusting column width and row height?

Select one of the following:

  • The default width for a column in a worksheet using the Office theme is 8.43 characters in the default font.

  • The default height of each row is 25 points.

  • Change the column width or row height by dragging the border between column or row headings, by using the context menu, or by selecting a command from the Format button.

  • You can adjust one or more columns or rows at the same time.

Explanation

Question 6 of 20

1

Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?

Select one of the following:

  • Paste

  • Formulas

  • Formulas & Number Formatting

  • Keep Source Formatting

Explanation

Question 7 of 20

1

Which of the following characters precedes Excel functions?

Select one of the following:

  • +

  • =

  • (

  • -

Explanation

Question 8 of 20

1

Which of the following features displays a suggested label in a column when the first character or two that you type matches a label already in the column?

Select one of the following:

  • AutoFill

  • AutoComplete

  • AutoFit

  • AutoCorrect

Explanation

Question 9 of 20

1

Which of the following displays in a cell when you click AutoSum?

Select one of the following:

  • =SUM()

  • =AUTOSUM()

  • =ADD()

  • =AUTOADD()

Explanation

Question 10 of 20

1

Which of the following paste options copies all data and formatting?

Select one of the following:

  • Merge Conditional Formatting

  • Match Destination Formatting

  • Formulas & Number Formatting

  • Keep Source Formatting

Explanation

Question 11 of 20

1

Which of the following is the default paste option?

Select one of the following:

  • Paste

  • Merge Conditional Formatting

  • Formulas & Number Formatting

  • Match Destination Formatting

Explanation

Question 12 of 20

1

Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?

Select one of the following:

  • Ignore Once

  • Ignore All

  • Change

  • Change All

Explanation

Question 13 of 20

1

Which of the following views displays printed pages with dashed or dotted lines to mark where new pages start?

Select one of the following:

  • Normal view

  • Page Layout view

  • Page Break Preview

  • Full Screen view

Explanation

Question 14 of 20

1

Which of the following does not describe a print area?

Select one of the following:

  • You can select nonadjacent ranges to print on one page.

  • A print area is the data that prints from a Print command.

  • The default print area is the entire worksheet.

  • A print area is saved with the worksheet.

Explanation

Question 15 of 20

1

In the Excel window, which of the following continuously displays the buttons for switching worksheet views?

Select one of the following:

  • Ribbon

  • Scroll bar

  • Status bar

  • Shortcut menu

Explanation

Question 16 of 20

1

Which of the following commands locks rows or columns in view so that you can position data for easy review?

Select one of the following:

  • Zoom options

  • Freeze Panes command

  • Status bar view buttons

  • Split command

Explanation

Question 17 of 20

1

What is selected when you point to and click a column heading?

Select one of the following:

  • the entire column

  • the entire row

  • the entire worksheet

  • the 20 cells adjacent to the top of the column

Explanation

Question 18 of 20

1

Which of the following features combines two or more cells into one cell and centers the data within the combined cell?

Select one of the following:

  • AutoFormat

  • AutoFit

  • Merge & Center

  • Wrap Text

Explanation

Question 19 of 20

1

Which of the following activates edit mode?

Select one of the following:

  • Press F2.

  • Press F4.

  • Press F12.

  • Press Enter.

Explanation

Question 20 of 20

1

What is selected when you click the Select All button located above the row 1 heading and to the left of the column A heading?

Select one of the following:

  • the entire column

  • the entire row

  • all worksheet cells

  • a range

Explanation

Previous
Next