Question 1

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

Accepted Answer

The answer of ____ order arranges labels in reverse alphabetical...

Question 2

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.
A) index
B) glossary
C) list
D) range

Accepted Answer

A range in Excel refers to a collection of cells that span across rows and columns, which can be used to organize and structure similar data.

Question 3

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

Accepted Answer

The term "reverse alphabetical order" is described as arranging labels or words in reverse order from Z to A, which is equivalent to descending order. Therefore, option D, descending, is the best choice for this question.

Question 4

A data ____ table describes the fields you plan to maintain in a table.
A) structure
B) definition
C) map
D) linked

Accepted Answer

A data definition table, also known as a data dictionary, describes the fields or attributes that will be included in a database table. It specifies the data type, length, and other characteristics of each field, and provides guidelines for how the data should be entered and manipulated. A structure or map may be used to visualize the relationships between tables, but they do not necessarily provide the same level of detail as a data definition table. A linked table refers to a table that is connected to another table through a common field.

Question 5

The ____ criteria filter requires the records displayed to have the specified text string anywhere.
A) Has
B) Is
C) Contains
D) Matches

Accepted Answer

The "Contains" criteria filter searches for the specified text string anywhere in the record. This is the most appropriate filter for finding records with a certain text string regardless of its location within the record.

Question 6

Which of the following is a valid table name?
A) %_table
B) $Table2
C) _Newtable
D) 2Table

Accepted Answer

Table names cannot start with a symbol or a number, so options A and D are invalid. Option B starts with a dollar sign, which is also not allowed. Therefore, the only valid option is C, which starts with an underscore and followed by alphabets.

Question 7

When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.
A) table
B) catalogue
C) index
D) roster

Accepted Answer

When a range is designated as a table in Excel, it provides the same functionality and operations as a structured range of data, such as filtering, sorting, and summarizing. Designating a range as a catalogue, index, or roster does not have this same functionality.

Question 8

The ____ criteria filter requires the records displayed to start with the specified text string.
A) Origin
B) Begins With
C) Initial
D) Start

Accepted Answer

The "Begins With" criteria filter requires the records displayed to start with the specified text string.

Question 9

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 answer of You can access the Sort buttons in...

Question 10

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 dialog box allows you to select multiple fields and specify the order and sorting method for each field. This gives you more control and flexibility in how your data is sorted.

Question 11

To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.
A) DESIGN
B) HOME
C) INSERT
D) VIEW

Accepted Answer

To create a table in Microsoft Word, you need to go to the INSERT tab on the Ribbon and then click on the Table button in the Tables group.

Question 12

Excel assigns the name ____ to the first Excel table created in a workbook.
A) 1
B) 1Table
C) NewTable
D) Table1

Accepted Answer

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

Question 13

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.
A) rows and headers
B) grids and columns
C) rows and columns
D) footers and grids

Accepted Answer

Tables in Excel are comprised of related data organized into rows and columns. They are independent from other data in the worksheet and can be managed separately. Headers and footers are not directly related to tables but are features that can be added to a worksheet. Grids are a visual aspect of Excel and do not affect the organization or management of data. Therefore, the correct answer is C) rows and columns.

Question 14

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 removes the filter and displays all records. The Remove command is not a standard command in Excel and the other options, Delete and Archive, do not relate to filtering.

Question 15

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 selected criteria be true for a record to be displayed.

Question 16

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 17

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 is located in the Sort & Filter group on the DATA tab in Excel.

Question 18

A table name cannot include ____.
A) numbers
B) spaces
C) underscores
D) letters

Accepted Answer

In database systems, it is best practice to avoid using spaces in table names as it can cause issues with coding and querying the data. Instead, use underscores or camel case. Numbers and letters are both acceptable in table names.

Question 19

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 20

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.
A) Hiding
B) Freezing
C) Showing
D) Sealing

Accepted Answer

Freezing rows and columns allows the user to keep specific headings visible as they scroll through large amounts of data in a worksheet. This can make it easier to view and analyze the information. Hiding, showing, and sealing do not have this function.

Quiz 5: Excell: Working With Excel Tables, Pivottables, and Pivotcharts

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

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

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

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

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

Which of the following is a valid table name?

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

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

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

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

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

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

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

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

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

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

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 table name cannot include ____.

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

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