Question 1

After data is filtered,you can ____ it.
A) sort
B) chart
C) copy
D) all of the above

Accepted Answer

After filtering data, you may need to sort it to arrange the values in a specific order. You may also want to create charts to visualize the filtered data. Additionally, there may be instances where you need to copy the filtered data to a new location. Therefore, all of the above options (sorting, charting, and copying) are possible after filtering data.

Question 2

As you type in a cell,____ displays any existing entry in the column that matches the characters you typed.
A) QuickFix
B) AutoComplete
C) Column Checker
D) AutoFill

Accepted Answer

The feature described is called AutoComplete. It suggests possible matches as you type based on existing entries in the column. The other options (QuickFix, Column Checker, and AutoFill) do not have this function.

Question 3

-Referring to the figure above,in row 117,in the last full column shown,there is a small triangle shown in the bottom-right corner of the cell.This triangle indicates ____.
A) a frozen cell
B) a sizing handle
C) an AutoCorrect field
D) a sort field

Accepted Answer

A sizing handle is a small triangle that appears in the bottom-right corner of a cell when the cursor is hovered over the border of the cell. It can be used to resize the cell by dragging it with the mouse.

Question 4

When you have more than one sort field,you should use the Sort ____ to specify the sort criteria.
A) menu
B) status bar
C) wizard
D) dialog box

Accepted Answer

When you have more than one sort field, you should use the Sort dialog box to specify the sort criteria. The Sort dialog box allows you to select multiple fields and specify the order in which the fields should be sorted. Additionally, you can specify whether each field should be sorted in ascending or descending order. The other options (menu, status bar, and wizard) do not provide the same level of control over the sort criteria.

Question 5

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.
A) Exact match
B) Match entire cell contents
C) Complete cell
D) Precise match to entire cell

Accepted Answer

The "Match entire cell contents" check box ensures that the search will be limited to only exact matches of the value in the selected field, rather than partial matches or matches within other text in the cell.

Question 6

The ____ condition requires that only one of the selected criteria be true for a record to be displayed.
A) NAND
B) OR
C) AND
D) IF

Accepted Answer

The OR condition states that only one of the selected criteria needs to be true for a record to be displayed. NAND requires that both criteria be false, and AND requires that both criteria be true. IF is not a logical operator in this context.

Question 7

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.
A) Category
B) View
C) Data
D) Home

Accepted Answer

The Filter button in the Sort & Filter group is present on the Data tab in Excel. Therefore, option C is the correct answer.

Question 8

You can sort by ____.
A) cell color
B) font color
C) cell icon
D) all of the above

Accepted Answer

All of the above options (cell color, font color, and cell icon) are valid sorting criteria in Excel, so selecting all of them allows for the most comprehensive sorting options.

Question 9

____ order arranges labels in reverse alphabetical order,from Z to A.
A) Reverse
B) Major
C) Ascending
D) Descending

Accepted Answer

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

Question 10

After you filter a column,the ____ Filter command becomes available so you can remove the filter and redisplay all the records.
A) Remove
B) Clear
C) Delete
D) Archive

Accepted Answer

The "Clear" filter command is the appropriate choice when wanting to remove the filter and redisplay all records in the filtered column.

Question 11

To delete a sort field in the Sort dialog box,click the ____ button.
A) Remove Level
B) Delete Level
C) Descend Level
D) Delete Field

Accepted Answer

The option to delete a sort field is "Delete Level" in the Sort dialog box.

Question 12

-Referring to the figure above,the icon shown in cell B118 is the ____ button.
A) QuickCorrect
B) AutoSort
C) Quick Filter
D) AutoCorrect Options

Accepted Answer

The icon in cell B118 is the AutoCorrect Options button, which appears when Excel has automatically corrected something and allows you to undo or change the correction.

Question 13

The fields you use to order your data are called sort ____.
A) values
B) fields
C) tags
D) tools

Accepted Answer

The fields used to order data are called sort fields.

Question 14

You can use up to ____ sort fields in a single sort.
A) 12
B) 24
C) 32
D) 64

Accepted Answer

The answer of You can use up to ____ sort...

Question 15

Excel provides ____ predefined custom sort lists.
A) three
B) four
C) six
D) seven

Accepted Answer

Excel provides four predefined custom sort lists: days of the week, months of the year, day/month abbreviations, and grade levels.

Question 16

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.
A) Filtering
B) Formatting
C) Editing
D) Text

Accepted Answer

The Sort buttons are located in the Editing group on the Home tab, which allows users to sort data in various ways.

Question 17

After Excel displays an existing entry in the column that matches the characters you typed,press the ____ key to accept the entry.
A) Shift
B) Tab
C) Esc
D) Alt

Accepted Answer

Pressing the Tab key will accept the existing entry and move the cursor to the next cell in the row.

Question 18

To add a sort field in the Sort dialog box,click the ____ button.
A) Add Level
B) Add Field
C) New Sort Field
D) New Level

Accepted Answer

The correct option is "Add Level" because in the Sort dialog box, when you want to add a new criterion for sorting, you click the "Add Level" button to introduce another field or column by which to sort your data.

Question 19

The ____ condition requires that all of the selected criteria be true for the record to be displayed.
A) OR
B) NAND
C) AND
D) IF

Accepted Answer

The AND condition requires that all of the selected criteria be true for the record to be displayed. The OR condition only requires that at least one of the selected criteria be true, while the NAND and IF conditions are not specific operators in regards to database queries.

Question 20

-In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.
A) selection
B) filtering
C) custom
D) query

Accepted Answer

These terms are likely used to filter a list or database to show only items related to "Installation," "Sculpture," and "Textile."

Quiz 5: Working With Excel Tables, Pivot-tables, and Pivot-charts

After data is filtered,you can ____ it.

As you type in a cell,____ displays any existing entry in the column that matches the characters you typed.

-Referring to the figure above,in row 117,in the last full column shown,there is a small triangle shown in the bottom-right corner of the cell.This triangle indicates ____.

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

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.

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

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

You can sort by ____.

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

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

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

-Referring to the figure above,the icon shown in cell B118 is the ____ button.

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

You can use up to ____ sort fields in a single sort.

Excel provides ____ predefined custom sort lists.

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

After Excel displays an existing entry in the column that matches the characters you typed,press the ____ key to accept the entry.

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

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

-In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.