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