Exam 2: Microsoft Excel Basics

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 ____.

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

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?

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

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

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

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?

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

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

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

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

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

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

The horizontal axis of a chart is called the ____.

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

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

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.

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.

____ provide professional presentation features for displaying worksheet data.

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