Question 1

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. If Stephanie wants to display a miniature chart next to each row of her worksheet that will reflect the net profit or loss, she can create ____.

Accepted Answer

A)  legends 
B)  data sheets 
C)  data markers 
D)  sparklines

Question 2

When working with cell references, any change you make to the ____ cell also changes the value in the destination cell.

Accepted Answer

A)  source 
B)  primary 
C)  main 
D)  active

Question 3

Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben also wants to copy a formula from the bottom of the spreadsheet and put it at the top of the spreadsheet in a summary section. He wants the formula to stay exactly the same and result in the same figure. What type of cell reference should Ben use?

Accepted Answer

A)  Mixed 
B)  Relative 
C)  Absolute 
D)  None of the above

Question 4

The present value of a loan based on equal payments is written as ____.

Accepted Answer

A)  PV(rate,nper,pmt,fv,type) 
B)  PVAL(rate,nper,pmt,fv,type) 
C)  PV(rate,nper,pmt,term) 
D)  PVAL(rate,nper,pmt,term)

Question 5

The ____ dialog box is used to change the color of the text of a button.

Accepted Answer

A)  Format Control 
B)  Button Format 
C)  Button Text 
D)  Text Color

Question 6

You can create your own conditional format rule based on a formula called a(n) ____________________ formula.

Accepted Answer

The answer of You can create your own conditional format...

Question 7

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Once the Find and Replace dialog box appears, with the Replace tab displayed, what button should Tessa click to expand the dialog box so that she can enter in the formatting styles she wants to find and replace?

Accepted Answer

A)  Expand 
B)  More 
C)  Continue 
D)  Options

Question 8

In the IF function, the third argument determines the value that appears in the cell if the logical test is ____.

Accepted Answer

A)  false 
B)  true 
C)  an error 
D)  none of the above

Question 9

Excel places circles around any invalid data using the ____________________ feature.

Accepted Answer

The answer of Excel places circles around any invalid data...

Question 10

After data is filtered, only the cells for the item you filtered will be displayed; the other cells will be hidden.

Accepted Answer

A) True 
 B)False

Question 11

To import Access data, click the ____ tab, and then click the From Access button.

Accepted Answer

A)  Home 
B)  Data 
C)  Review 
D)  Insert

Question 12

When you create a macro, Excel records your menu selections and keystrokes.

Accepted Answer

A) True 
 B)False

Question 13

In the IF function, the second argument determines the value that appears in the cell if the logical test is ____.

Accepted Answer

A)  false 
B)  true 
C)  an error 
D)  none of the above

Question 14

The horizontal axis of a chart is called the ____.

Accepted Answer

A)  a-axis 
B)  b-axis 
C)  x-axis 
D)  y-axis

Question 15

When you press and hold down a(n) ____________________ key, the active cell shifts in that direction repeatedly and quickly.

Accepted Answer

The answer of When you press and hold down a(n)...

Question 16

All of the comments tools are located on the ____________________ tab of the Ribbon in the Comments group.

Accepted Answer

The answer of All of the comments tools are located...

Question 17

If you select a cell containing data and then click the Trace Dependents button, a ____ is drawn from the selected cell pointing to the cell with the function.

Accepted Answer

A)  track line 
B)  data line 
C)  source arrow 
D)  tracer arrow

Question 18

Case EX 15-1 Tracy is currently living in a rental apartment but she wants to buy a condo. She is using a worksheet to figure out how much she would need to save each year to be able to save enough money to make the down payment for the condo in six years. Tracy was told by her banker that she would need to put down $30,000 for the down-payment on the condo. She can use the ____ feature to figure out how much she would need to save each month to be able to make the down-payment in six years.

Accepted Answer

A)  Trace Dependents 
B)  Trace Precedents 
C)  Plan Ahead 
D)  Goal Seek

Question 19

____ provide professional presentation features for displaying worksheet data.

Accepted Answer

A)  Queries 
B)  Tables 
C)  Modules 
D)  Macros

Question 20

____ are predesigned workbook files that you can use as the basis or model for new workbooks.

Accepted Answer

A)  Forms 
B)  Templates 
C)  Formats 
D)  Images

Exam 2: Microsoft Excel Basics