Question 1

To remove a filter criterion for a single field,select the Select All option from the column heading AutoFilter menu for that field.

Accepted Answer

The answer of To remove a filter criterion for a...

Question 2

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 3

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 tab...

Question 4

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 because it can make the data difficult to read and manage. It is better to create separate worksheets for each table.

Question 5

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, among other things such as editing, deleting or creating new rules.

Question 6

In a multiple-field filter operation,the AND and OR options are interchangeable.

Accepted Answer

The AND and OR options are not interchangeable in a multiple-field filter operation. The AND option will narrow down the results by requiring all specified criteria to be met, while the OR option will broaden the results by requiring only one of the specified criteria to be met.

Question 7

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, latest to earliest, or alphabetically from Z to A.

Question 8

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 9

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

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 10

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 11

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

Accepted Answer

The HLOOKUP and VLOOKUP functions can be found in the 'Lookup & Reference' button in the FORMULAS tab under the Function Library group.

Question 12

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

Accepted Answer

This is true according to the specifications provided by Microsoft Access, which is a widely used relational database management system. However, it's important to note that having such a large number of fields or records in a single table may not always be the most efficient or effective way to organize data, and it may be necessary to consider alternative approaches such as splitting tables into related subsets or creating multiple tables with appropriate relationships.

Question 13

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

Accepted Answer

Clicking the arrow to the right side of a cell in the total row does display a list of available statistical functions.

Question 14

A table also is called a record.

Accepted Answer

A table and a record are not the same thing. A table is a collection of records, while a record is a single row in a table that contains information about a specific item or entity.

Question 15

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

Accepted Answer

The AutoFilter menu displays all the unique values that occur in the selected column.

Question 16

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 17

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 the HLOOKUP and VLOOKUP functions perform a lookup in a table and return a corresponding value to the cell where the function is placed. HLOOKUP looks for a value in the top row of a table and returns a corresponding value from a row below, while VLOOKUP looks for a value in the leftmost column of a table and returns a corresponding value from a column to the right.

Question 18

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 (columns) in a single sort operation.

Question 19

With criteria ranges,if you want an AND operator on two different fields,your criteria range must contain two (or more)data rows.

Accepted Answer

The answer of With criteria ranges,if you want an AND...

Question 20

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

True, if the selected column contains numeric data, the Sort & Filter menu will display options to sort from smallest to largest or largest to smallest.

Quiz 6: Creating, Sorting, and Querying a Table