Question 1

Subtotal rows that are totaled and summarized are referred to as actual data.

Accepted Answer

Subtotal rows that are totaled and summarized are not actual data, but rather calculated results that provide additional information about the data in a table or spreadsheet.

Question 2

In Excel,the applied theme has a set of complimentary ________,which are defined sets of formatting characteristics,such as fonts,font sizes,number formats,cell borders,and cell shading.

Accepted Answer

The answer of In Excel,the applied theme has a set...

Question 3

You can save a single worksheet as a webpage,where Excel changes the content of the worksheet into ________,a language web browsers can interpret.

Accepted Answer

The answer of You can save a single worksheet as...

Question 4

When outlining a worksheet,if the data is not organized so that Excel can outline it automatically,you can create an outline manually.

Accepted Answer

This is true. If Excel cannot automatically outline the data, you can still create an outline manually by selecting the cells you want to include in the outline and then using the "Outline" or "Group" feature in the "Data" tab.

Question 5

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called ________.

Accepted Answer

The answer of The portions of a worksheet bounded by...

Question 6

Clicking a ________ will take you to another location in the worksheet,another file location,a webpage on the intranet,or to your organization's Internet.

Accepted Answer

The answer of Clicking a ________ will take you to...

Question 7

To move to a specific cell or range of cells in a large worksheet use the ________ command.

Accepted Answer

The answer of To move to a specific cell or...

Question 8

To set column and row titles on the screen while you scroll,use the ________ command.

Accepted Answer

The answer of To set column and row titles on...

Question 9

You can use a(n)________ list to sort in an order that you define.

Accepted Answer

The answer of You can use a(n)________ list to sort...

Question 10

To publish a document and ensure that the appearance of the document is the same no matter what computer it is displayed on,save the document in ________ format.

Accepted Answer

The answer of To publish a document and ensure that...

Question 11

A custom list that you define must be based on a ________ such as text,a number,a date,or time.

Accepted Answer

The answer of A custom list that you define must...

Question 12

The default font for headings in Excel is ________.

Accepted Answer

The answer of The default font for headings in Excel...

Question 13

Use the ________ mark wildcard to search criteria that represents a single position or character that is unknown in a group of specified values.

Accepted Answer

The answer of Use the ________ mark wildcard to search...

Question 14

A sort on a group of numbers that is sorted from highest to lowest is known as a(n)________ sort.

Accepted Answer

The answer of A sort on a group of numbers...

Question 15

A file format that was created by Adobe Systems to create a representation of what an Excel spreadsheet would look like when printed is ________.

Accepted Answer

The answer of A file format that was created by...

Question 16

To force data into a selected number of pages,use the ________ command.

Accepted Answer

The answer of To force data into a selected number...

Question 17

The outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click.

Accepted Answer

The outline bar or groupings feature along the left side of a worksheet enables you to show and hide levels of detail by clicking on the ‘+/-‘ icons beside the grouping rows or columns.

Question 18

A series of rows that contains related data is known as a query.

Accepted Answer

A series of rows that contains related data is known as a table. A query is a request for information from a database.

Question 19

Detail data refers to the subtotaled rows that are totaled and summarized.

Accepted Answer

Detail data refers to the specific rows of data that are subtotaled and then summarized.

Question 20

A text file can be converted from tab delimited text to a Word table by selecting the ________ command that easily converts a tabbed file into a table.

Accepted Answer

The answer of A text file can be converted from...

Quiz 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering