Which Excel feature is useful for a situation where you know the result you want but don$$t know what value will achieve that result?

$(1$ Point$)$

Trendlines

Sparklines

Goal Seek

PivotTables

$2.$By default, Excel saves the macro in

$(1$ Point$)$

the current workbook.

the Excel program file.

a stand$-$alone Visual Basic file.

a special macros workbook.

$3.$Workbook properties can be viewed and edited in the

$(1$ Point$)$

Protect Workbook dialog box.

Track Changes dialog box.

Info backstage area.

Data Tools group on the Data tab.

$4.$From which tab will you run a macro?

$(1$ Point$)$

Insert

File

View

Home

$5.$How do you remove protection from a worksheet?

$(1$ Point$)$

Unlock the locked cells, then click Unprotect Sheet in the Format drop$-$down list on the Home tab.

Click the Unprotect Sheet button on the Review tab.

Save the workbook with a different name.

Unlock the locked cells, then click Unprotect Sheet on the Review tab.

$6.$A shared workbook is usually kept

$(1$ Point$)$

on a CD or DVD that others have access to$.$

on a flash drive.

in a network folder.

on a local hard drive.

$7.$What is the keyboard shortcut to minimize the ribbon?

$(1$ Point$)$

Ctrl $+$ F$1$

Ctrl $+-$

Ctrl $+$ M

Ctrl $+$ F$4$

$8.$What does PDF stand for?

$(1$ Point$)$

page distribution file

portable document format

printable data format

printable digital file

$9.$When using the Goal Seek command, the goal $($the value you want to achieve$)$ is entered into which box in the Goal Seek dialog box?

$(1$ Point$)$

By changing cell

To value

Set cell

Row input cell

$10.$By default, comments $\_\_\_\_\_$ print.

$(1$ Point$)$

do not

do

sometimes

always

$11.$In a collaborative environment, which of these actions should be taken first to prevent unwanted changes to a worksheet?

$(1$ Point$)$

Lock the cells that should not be changed.

Unlock the cells that can be changed.

Protect the worksheet.

Unprotect the worksheet.

$12.$To calculate a value, the Goal Seek feature requires that cells have a$($n$)\_\_\_\_\_$ relationship.

$(1$ Point$)$

dependent

static

two$-$way

absolute

$13.$What does Excel do with the quotes that surround text data in text files?

$(1$ Point$)$

It strips them from the data during the import process.

It leaves them in place, because they are critical to the integrity of the data.

It changes them to commas before importing the data.

It changes them to colons before importing the data.

$14.$To create a data table, begin by clicking the $\_\_\_\_\_$ button.

$(1$ Point$)$

Consolidate

Table

What$-$If Analysis

Scenario Manager

$15.$Cells that provide data to a formula cell are called $\_\_\_\_\_$ cells.

$(1$ Point$)$

related

precedent

independent

dependent

$16.$When you create a new comment, what is inside the comment box?

$(1$ Point$)$

the date

nothing

the file name

the user$$s name

$17.$Text file formats usually use $\_\_\_\_\_$ to separate data fields.

$(1$ Point$)$

colons or semicolons

slashes or backslashes

commas or tabs

apostrophes or quotation marks

$18.$A $\_\_\_\_\_$ file contains only letters, numbers, punctuation symbols, and a few control characters.

$(1$ Point$)$

workbook

text

Word

database

$19.$Which error code indicates that the formula contains an unrecognized entry?

$(1$ Point$)$

#REF!

#VALUE!

#N$/$A

#NAME?

$20.$Macros are created using Excel$$s

$(1$ Point$)$

data validation feature.

macro recorder.

Microsoft Query feature.

Insert Function dialog box.

$21.$The buttons to import data into Excel are found in the

$(1$ Point$)$

Get External Data group on the Data tab.

Connections group on the Data tab.

Tables group on the Insert tab.

Text group on the Insert tab.

$22.$The person who changed a cell can be identified by the

$(1$ Point$)$

shading pattern in the cell.

border color around the cell.

line style of the cell border.

font effect applied to the content of the cell.

$23.$Which Excel feature allows you convert data that is in rows to data in columns?

$(1$ Point$)$

Transpose

Table

Text to Columns

Consolidate

$24.$Use Excel$$s $\_\_\_\_\_$ feature to scan a workbook for hidden or confidential information.

$(1$ Point$)$

Metadata Scanner

Confidentiality Checker

Cookie Finder

Document Inspector

$25.$The Scenario Manager is different from the Goal Seek analysis tool in that it

$(1$ Point$)$

does not provide answers to specific questions.

does not change cell values.

is generally not used in business settings.

allows you to examine several different answers to your question.

$26.$Macros are used to increase productivity by

$(1$ Point$)$

automatically spell$-$checking data as it is entered.

automatically checking formulas for errors as they are entered.

automatically formatting worksheets.

automating tasks that are performed repeatedly.

$27.$What method described in Chapter $6$ allows users to collaborate?

$(1$ Point$)$

workbook sharing

Spa