Question 1

To print a portion of a worksheet, you must select the area to be printed and click
A) Quick Print from the Office button
B) Print Area from the Page Setup group of the Page Layout tab
C) Print Titles from the Page Setup group of the Page Layout tab
D) Print Preview from the Office button

Accepted Answer

Selecting the area to be printed and clicking on "Print Area" from the Page Setup group of the Page Layout tab will allow you to define the exact area to be printed. This is the best choice as it ensures that only the desired area is printed, saving paper and ink.

Question 2

Which command is used to repeat the column headings on the second page of a spreadsheet?
A) Print Titles
B) Freeze Titles
C) Freeze Panes
D) Repeat Titles

Accepted Answer

Print Titles is used to repeat the column headings on subsequent pages of a spreadsheet, ensuring that each page printed contains the column headings for easier reference and understanding of the data.

Question 3

To enter the year 2010 as a text entry, key ____ before the numbers 2010.
A) @
B) '
C) *
D) =

Accepted Answer

The apostrophe (') is used to indicate text entry in Excel. Therefore, to enter 2010 as text, one would key in '2010.

Question 4

To print a wide spreadsheet, change the orientation to ____________________.

Accepted Answer

The answer of To print a wide spreadsheet, change the...

Question 5

If cells are not adjacent, hold down the ____________________ key to select.

Accepted Answer

The answer of If cells are not adjacent, hold down...

Question 6

To combine data from multiple worksheets on a summary worksheet, enter a/an ____________________ in a cell on the summary worksheet that will combine the data from the multiple worksheets.

Accepted Answer

The answer of To combine data from multiple worksheets on...

Question 7

A/an ____________________ header or footer can be selected from a gallery of header and footers that contains a variety of text and page number designs.

Accepted Answer

The answer of A/an ____________________ header or footer can be...

Question 8

In a PivotTable, when a field is dragged to the Values section below the PivotTable Field List, the default value setting is ____.
A) Average
B) Count
C) Max
D) Sum

Accepted Answer

The default value setting when dragging a field to the Values section in a PivotTable is Sum. This is because the Values section is used to display the numeric values of the data, and Sum is often the most appropriate calculation to use for numeric data.

Question 9

To design and format a chart, use the commands on the ____________________ Design and Format tabs.

Accepted Answer

The answer of To design and format a chart, use...

Question 10

Suppose that you want to change the color of the chart area of a column chart, and the chart area is not selected. Click ____, select the chart area, and edit the color.
A) Chart Elements
B) Format Chart Area
C) Format Selection
D) Reset to Match Style

Accepted Answer

Chart Elements is the correct option because it allows you to select different parts of the chart, including the chart area, to apply formatting changes such as editing the color.

Quiz 3: Spreadsheets With Excel

To print a portion of a worksheet, you must select the area to be printed and click

Which command is used to repeat the column headings on the second page of a spreadsheet?

To enter the year 2010 as a text entry, key ____ before the numbers 2010.

To print a wide spreadsheet, change the orientation to ____________________.

If cells are not adjacent, hold down the ____________________ key to select.

To combine data from multiple worksheets on a summary worksheet, enter a/an ____________________ in a cell on the summary worksheet that will combine the data from the multiple worksheets.

A/an ____________________ header or footer can be selected from a gallery of header and footers that contains a variety of text and page number designs.

In a PivotTable, when a field is dragged to the Values section below the PivotTable Field List, the default value setting is ____.

To design and format a chart, use the commands on the ____________________ Design and Format tabs.

Suppose that you want to change the color of the chart area of a column chart, and the chart area is not selected. Click ____, select the chart area, and edit the color.