Changing the appearance of a cell based on a condition is called

$(1$ Point$)$

what$-$if formatting.

what$-$if cell analysis.

conditional analysis.

conditional formatting.

$2.$Which button allows you to change the summary function in your PivotTable?

$(1$ Point$)$

Number Format

Field Settings

Subtotals

Insert Slicer

$3.$A table should not contain

$(1$ Point$)$

column labels.

blank rows.

more than five columns.

text data.

$4.$A function includes two parts: the name of the function and the

$(1$ Point$)$

format.

size.

argument.

location.

$5.$Excel$$s Lookup and Reference functions provide a way to

$(1$ Point$)$

format cells.

export data to another program.

import data from another program.

looking up values in a range.

$6.$Slicers allow you to

$(1$ Point$)$

filter data from several workbooks at once.

sort a named range with one click.

filter without using a filter arrow.

insert a graph into a single cell of the worksheet.

$7.$In Excel, a range that can be managed separately from other rows and columns in the worksheet is called a

$(1$ Point$)$

named range.

chart.

table.

PivotChart.

$8.$Excel$$s data validation feature allows you to

$(1$ Point$)$

specify which users can enter data into your worksheet.

spell check your data.

check your formulas for errors.

control the type of data that can be entered into a cell.

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

$(1$ Point$)$

next to each label in the header row

in the first and last columns

only on columns containing numbers

only on columns containing text

$10.$Icon sets allow you to

$(1$ Point$)$

classify data into three to five categories.

change the images that appear on Excel buttons.

create your own symbols.

modify the shapes of threshold symbols.

$11.$To create your own number format, select $\_\_\_\_\_$ from the Category list box in the Number tab of the Format Cells dialog box.

$(1$ Point$)$

Text

Custom

Scientific

Special

$12.$A $\_\_\_\_\_$ is a built$-$in formula.

$(1$ Point$)$

function

template

style

format

$13.$Which Excel function calculates the principal portion of a loan payment?

$(1$ Point$)$

PMT

IPMT

PV

PPMT

$14.$A table in Excel is similar in structure to a

$(1$ Point$)$

database.

workbook.

named range.

chart.

$15.$The workbook that contains the data that is linked to the destination workbook is called the $\_\_\_\_\_$ workbook.

$(1$ Point$)$

source

master

dependent

related

$16.$What is the first step in creating a PivotTable?

$(1$ Point$)$

Select source range.

Click PivotTable button.

Click Insert tab.

Add fields as needed using PivotTable Fields task pane.

$17.$To subtotal data in a range of related data, you must first

$(1$ Point$)$

outline the range.

filter the range on the field to be subtotaled.

sort the range by the fields in which you want the records grouped.

create a table.

$18.$To create a Sparkline, begin by

$(1$ Point$)$

selecting the range of data that will produce the Sparklines.

clicking the desired Sparkline type on the Insert tab.

selecting an empty cell range in which to insert the Sparklines.

creating a PivotTable with the data to be used in the Sparklines.

$19.$You can begin building a PivotTable by clicking the PivotTable button, which is located on the $\_\_\_\_\_$ tab.

$(1$ Point$)$

Home

Data

Insert

Formulas

$20.$When applying conditional formatting using predefined rules, the first step is to

$(1$ Point$)$

click the Quick Analysis button.

click the Home tab.

select a range of cells.

click the Conditional Formatting button.

$21.$In a formula, a$($n$)\_\_\_\_\_$ is used to separate a worksheet reference from a cell reference.

$(1$ Point$)$

backslash $(\backslash )$

semicolon $($;$)$

exclamation point $(!)$

period $(.)$

$22.$Which options can you select in the Custom AutoFilter dialog box if you want to specify two criteria?

$(1$ Point$)$

Criterion$1$ and Criterion$2$

Either or Or

And or Or

By and Then By

$23.$The Table Tools Design tab contains options for $\_\_\_\_\_$ the table.

$(1$ Point$)$

formatting

adding a chart to

creating

protecting

$24.$To remove conditional formatting, select the range, click the Conditional Formatting button, point to Clear Rules, and then choose

$(1$ Point$)$

Clear Rules from Selected Range.

Clear Rules from Workbook.

Clear Conditional Formatting.

Clear Rules from Selected Cells.

$25.$The COUNTIF function requires two arguments: range and

$(1$ Point$)$

rate.

criteria.

cell reference.

syntax.

$26.$Excel$$s $\_\_\_\_\_$ feature summarizes data from multiple worksheets or another workbook into a master worksheet.

$(1$ Point$)$

Connections

Consolidate

Group

Table

$27.$In a table, the labels in the first row are referred to as the

$(1$ Point$)$

titles.

field names.

records.

range names.

$28.$The IF function$$s logical test returns $\_\_\_\_\_$ result.

$(1$ Point$)$

only a text

either a text or number