CIS 150 5

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.

range

A data ____ table describes the fields you plan to maintain in a table.

definition

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

Freezing

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

rows and columns

When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.

table

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.

insert

Excel assigns the name ____ to the first Excel table created in a workbook.

table1

Which of the following is a valid table name?

Newtable

A table name cannot include ____.

spaces

____ order arranges labels in reverse alphabetical order, from Z to A.

Descending

____ order arranges labels in reverse alphabetical order, from A to Z

Ascending

The fields you use to order your data are called sort ____.

fields

You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option.

Editing

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

dialog box

To add a sort field in the Sort dialog box, click the ____ button.

Add Level

After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

Clear

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

Data

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

AND

The ____ criteria filter requires the records displayed to start with the specified text string.

Begins With

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

Contains

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

Between

The ____ criteria filter requires the records displayed to have the current date.

Today

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

Year to Date

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

April, May, June

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

arrow

You can split the worksheet window into ____ separate panes.

two or four

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

And

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet one of the criteria.

Or

In the figure above, if you only want to set one criterion for this filter, you will ____.

leave the lower boxes empty

In the figure above, the 300 indicates the amount. Records with the following values meet the criteria: ____.

$301

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

Insert Function

To calculate subtotal for a table, the first step is to use the ____ button on the TABLE TOOLS DESIGN tab.

Convert to Range

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

outlines

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

TABLE TOOLS DESIGN

On the far right, in the figure above, there is the PivotTable field list. The items listed there, such as "Day" and "Segment" are ____ in the table.

columns

On the bottom-right corner of the figure above, there are four squares labeled FILTER, COLUMNS, ROWS, and VALUES. These four areas represent the ____ of the PivotTable.

layout

To get to the screen shown in the figure above, you would click the INSERT tab on the Ribbon, and then, in the ____ group, click the PivotTable button.

Tables

By default, the PivotTable report uses the ____ function for numbers in the Values area.

SUM

The ____ report layout displays one column for each field and leaves space for column headers.

Tabular

You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data.

refresh

To delete records that are incorrect, out of date, or no longer needed, select a cell in each record you want to delete, click the Delete button arrow in the Cells group on the ____ tab, and then click Delete Table Rows.

HOME

Every ____ consists of an object that contains a button for each unique value in that field.

slicer

You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?

Convert the range to a table

Which of the following is true about Excel tables (as opposed to structured ranges of data)?

You cannot freeze the top row of a worksheet

If Cali wants to find all of his campers named Cathy, Carla, and Carey, what should she do?

Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value.

If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson), what should he do?

Create a text filter using the Ends With operator to display all records that have son as the last characters in the text value.

To find anyone whose Camp is either Day Camp, or Overnight Camp, or Nature Camp, what should he do?

Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.

Which of the following is a true statement Carter can make to Ted about PivotTables?

To remove a field from a PivotTable, you click the field's check box in the PivotTable Field list.

Ted wants to be able to analyze date data in his PivotTable by month. What must he do with the date field in his PivotTable?

He must group the data by the date field.

If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?

COUNT

Ted wants to be able to use his PivotTable to combine items into groups. Which of the following is true?

Items that appear as column labels can be grouped.

Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

He would develop a PivotTable using the value filter.

CIS 150 5 - Subjecto.com

CIS 150 5

Your page rank:

Total word count: 1224
Pages: 4

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.

range

A data ____ table describes the fields you plan to maintain in a table.

definition

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

Freezing

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

rows and columns

When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.

table

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.

insert

Excel assigns the name ____ to the first Excel table created in a workbook.

table1

Which of the following is a valid table name?

Newtable

A table name cannot include ____.

spaces

____ order arranges labels in reverse alphabetical order, from Z to A.

Descending

____ order arranges labels in reverse alphabetical order, from A to Z

Ascending

The fields you use to order your data are called sort ____.

fields

You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option.

Editing

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

dialog box

To add a sort field in the Sort dialog box, click the ____ button.

Add Level

After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

Clear

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

Data

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

AND

The ____ criteria filter requires the records displayed to start with the specified text string.

Begins With

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

Contains

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

Between

The ____ criteria filter requires the records displayed to have the current date.

Today

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

Year to Date

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

April, May, June

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

arrow

You can split the worksheet window into ____ separate panes.

two or four

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

And

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet one of the criteria.

Or

In the figure above, if you only want to set one criterion for this filter, you will ____.

leave the lower boxes empty

In the figure above, the 300 indicates the amount. Records with the following values meet the criteria: ____.

$301

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

Insert Function

To calculate subtotal for a table, the first step is to use the ____ button on the TABLE TOOLS DESIGN tab.

Convert to Range

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

outlines

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

TABLE TOOLS DESIGN

On the far right, in the figure above, there is the PivotTable field list. The items listed there, such as "Day" and "Segment" are ____ in the table.

columns

On the bottom-right corner of the figure above, there are four squares labeled FILTER, COLUMNS, ROWS, and VALUES. These four areas represent the ____ of the PivotTable.

layout

To get to the screen shown in the figure above, you would click the INSERT tab on the Ribbon, and then, in the ____ group, click the PivotTable button.

Tables

By default, the PivotTable report uses the ____ function for numbers in the Values area.

SUM

The ____ report layout displays one column for each field and leaves space for column headers.

Tabular

You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data.

refresh

To delete records that are incorrect, out of date, or no longer needed, select a cell in each record you want to delete, click the Delete button arrow in the Cells group on the ____ tab, and then click Delete Table Rows.

HOME

Every ____ consists of an object that contains a button for each unique value in that field.

slicer

You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?

Convert the range to a table

Which of the following is true about Excel tables (as opposed to structured ranges of data)?

You cannot freeze the top row of a worksheet

If Cali wants to find all of his campers named Cathy, Carla, and Carey, what should she do?

Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value.

If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson), what should he do?

Create a text filter using the Ends With operator to display all records that have son as the last characters in the text value.

To find anyone whose Camp is either Day Camp, or Overnight Camp, or Nature Camp, what should he do?

Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.

Which of the following is a true statement Carter can make to Ted about PivotTables?

To remove a field from a PivotTable, you click the field’s check box in the PivotTable Field list.

Ted wants to be able to analyze date data in his PivotTable by month. What must he do with the date field in his PivotTable?

He must group the data by the date field.

If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?

COUNT

Ted wants to be able to use his PivotTable to combine items into groups. Which of the following is true?

Items that appear as column labels can be grouped.

Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

He would develop a PivotTable using the value filter.

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending