Exam 11: Excel 2013 Getting Started With Excel 2013

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

When you double-click an embedded object, you can use the tools of the destination program to edit the object. _________________________

Functions can be entered for formulas using all of the following methods except ____.

Which tab and group will allow the insertion of rows and columns in a worksheet?

In the accompanying figure, item ____ shows the button that wraps long text into multiple lines.

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width . _________________________

As shown in the accompanying figure, item 1 points to the ____.

In this formula,  =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references. _________________________

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections.

Critical Thinking Questions Case 1-2 You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. The accompanying figure is the worksheet that you have created so far. You realize that you have made an error in the spreadsheet. Graham's score for test 2 should be 76, not 67. To fix this error, navigate to cell C4, type 76, and then press what key? a. [F4] b. [Ctrl] c. [Enter] d. [Alt]

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

When and how do you use the Copy and Paste commands to integrate data?

You can create multiple charts based on the same worksheet data.

In the accompanying figure, as you paste a chart from Excel to Word use the Paste Options button labeled ____  if you want the theme of the destination document applied to the chart, and the chart is linked to the object in the source document.

____ formatting is automatically updated if you change data in the worksheet.

____ operators perform mathematical calculations such as adding and subtracting.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Critical Thinking Questions Case 1-1 Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. You are ready to send the completed PowerPoint presentation to your manager and all along you knew it was important to keep the size of the presentation small. Which of the following are you most likely to use to accomplish this? a. linking b. embedding c. filtering d. copying and pasting

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. Write a formula using an absolute cell reference that would return the value shown in cell C6 in the accompanying figure.

Excel's ____________________ feature suggests functions depending on the first letters typed by the user.