Question 1

____ cause(s) adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.
A) Row banding
B) Row styles
C) Column banding
D) Column styles

Accepted Answer

Row banding and column banding are techniques used to apply different formatting to adjacent rows or columns, respectively, to distinguish them from each other.

Question 2

A table also is called a record.

Accepted Answer

A table is a collection of records, not a record itself.

Question 3

A table can have a maximum of 16,384 fields and 1,048,576 records.

Accepted Answer

This is correct. A table in Microsoft Access can have up to 16,384 fields and 1,048,576 records.

Question 4

Which of the following are outline symbols?
A) plus sign
B) minus sign
C) parentheses
D) brackets

Accepted Answer

The answer of Which of the following are outline symbols?
A)...

Question 5

If the table column you choose to sort contains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.

Accepted Answer

When sorting a column with numeric data, the Sort & Filter menu shows both the options to sort smallest to largest and largest to smallest.

Question 6

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

Accepted Answer

The 'Lookup & Reference' button in the FORMULAS tab under the Function Library group in Excel provides access to various lookup functions, including HLOOKUP and VLOOKUP.

Question 7

The path to the Percent Style button is (HOME tab | Editing group).

Accepted Answer

The answer of The path to the Percent Style button...

Question 8

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Accepted Answer

Data in descending sequence is sorted from highest to lowest, most recent to earlier or alphabetically from Z to A.

Question 9

Which of the following are database functions?
A) AVERAGE
B) DAVERAGE
C) SUM
D) DSUM

Accepted Answer

The answer of Which of the following are database functions?
A)...

Question 10

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Accepted Answer

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Question 11

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

Accepted Answer

Both HLOOKUP and VLOOKUP are designed to look up values in a table and return a corresponding value from the table. The only difference between the two functions is whether the table is arranged vertically (in columns) or horizontally (in rows).

Question 12

Placing more than one table on the same worksheet is recommended.

Accepted Answer

It is not recommended to place more than one table on the same worksheet as it can make the data difficult to read and analyze. It is better to separate each table onto its own worksheet.

Question 13

When you select a second filter criterion in a table, Excel turns off all previously selected filter criteria.

Accepted Answer

The answer of When you select a second filter criterion...

Question 14

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

Accepted Answer

The answer of When a table is active, the FORMAT...

Question 15

A list of all the values that occur in the selected column appear in the AutoFilter menu.

Accepted Answer

This statement is true. The AutoFilter menu will show all the distinct values that occur in the selected column.

Question 16

Which of the following are guidelines for creating a table in Excel?
A) Do not enter more than one table per worksheet
B) Place column headings (field names) in the first row of the table
C) Maintain at least one blank row between a table and other worksheet entries
D) Do not use blank rows or rows with repeating characters to separate the column headings (field names) from the data
E) None of the above

Accepted Answer

The answer of Which of the following are guidelines for...

Question 17

Which of the following is an option to distribute a document electronically?
A) sending a document via email
B) posting the file on cloud storage
C) posting it on a blog
D) posting it on a social networking site
E) None of the above

Accepted Answer

All of the options listed (sending a document via email, posting the file on cloud storage, posting it on a blog, and posting it on a social networking site) are viable methods to distribute a document electronically. Each option may be more appropriate depending on the intended audience and purpose of the document. For example, sending a document via email may be more appropriate for a private communication or for a document intended for a specific individual or group, while posting on a blog or social networking site may be more appropriate for a document intended for a wider audience. Cloud storage is a good option if the document needs to be shared with a specific group and it is important to have version control over the document.

Question 18

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

Accepted Answer

The answer of You can apply merge and center formatting...

Question 19

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

Accepted Answer

This statement is true. By tapping or clicking the arrow to the right of a cell in the Total Row, you can access various statistical functions, such as SUM, AVERAGE, and COUNT.

Question 20

Excel allows you to sort on a maximum of 400 fields in a single sort operation.

Accepted Answer

Excel allows sorting on a maximum of three fields in a single sort operation.

Quiz 7: Creating, Sorting, and Querying a Table

____ cause(s) adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

A table also is called a record.

A table can have a maximum of 16,384 fields and 1,048,576 records.

Which of the following are outline symbols?

If the table column you choose to sort contains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

The path to the Percent Style button is (HOME tab | Editing group).

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Which of the following are database functions?

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

Placing more than one table on the same worksheet is recommended.

When you select a second filter criterion in a table, Excel turns off all previously selected filter criteria.

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

A list of all the values that occur in the selected column appear in the AutoFilter menu.

Which of the following are guidelines for creating a table in Excel?

Which of the following is an option to distribute a document electronically?

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

Excel allows you to sort on a maximum of 400 fields in a single sort operation.