BM Excel 2019 L2 C3 Concepts Exam

Which of the following is an example of a structured reference formula?

=[@[Billable Hours]]*[@Rate]

At the Data Validation dialog box, choose the type of data to be validated in the _____ option box on the Settings tab.

Allow

On the Table Tools Design tab, which of these boxes contains a check mark by default?

Banded Rows

Before removing duplicate records from a table, how should you first check to see what records will be deleted?

Click Duplicate Values in the Highlight Cells Rules at the Conditional Formatting drop-down list.

_____ is not one of the data validation criteria available in the Allow option box at the Data Validation dialog box.

Fraction

What two options are presented at the Group dialog box?

Rows and Columns

What happens if you type new data in the row immediately below the last row of a table?

The table automatically adds a new row.

Suppose that you have received a table containing first and last names in one column. What is the easiest way to split the names into separate columns?

Use the Text to Columns feature.

To select only specific subtotals and/or grand totals in a collapsed outline, click the Find & Select button, click the Go to Special option, click the _____ radio button to insert a bullet, and then click OK.

Visible cells only

Before creating subtotals for a range of data, be sure to remove any _____ within the range to be grouped and subtotaled.

blank rows

If you type a formula in the first record of a new table column, Excel automatically creates a(n)

calculated column.

The first row of an Excel table contains

field names.

By inserting a check mark in the First Column or Last Column check box in the Table Style Options group, you can

format that column differently.

When groups and subtotals are added to a range, Excel automatically adds a _____ at the bottom of the range.

grand total

Use the keyboard shortcut Shift + Alt + Right Arrow key to _____ data.

group

By default, where does Excel display filter arrows in a table?

next to each label in the header row

When data in a worksheet is entered as a table, each row is a _____ and each column is a _____.

record; field

Insert a check mark in the Header Row check box in the Table Styles Options group to

show or hide the column headings in the table.

Before creating a subtotal for a range of related data, you must first

sort the data by the fields in which the records are to be grouped.

Why would you want to convert a table to a normal range?

to use the Subtotal feature