Exam 11: Excel 2013 Getting Started With Excel 2013

In the accompanying figure, use the Paste Options button labeled ____ to paste a picture as a chart that cannot be modified and you want to keep the formatting from the source document.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

Critical Thinking Questions Case 1-1 Eamon Christopher, the new staff assistant at QST Vancouver, wants to create some new reports utilizing the features of each of the various Microsoft Office programs using OLE technology. For one set of numbers, Eamon wants to capture the numbers as they are right now, but he is confident that under no circumstance will he want updated numbers to appear in his Word document. Which option should he use? a. linking b. embedding c. copying and pasting from the Clipboard d. connecting

You are in Edit mode any time you are entering or changing the contents of a cell.

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara has a proper name in the worksheet, all instances of which she would like the spell checker to skip over. What option do you tell her to select? a. Pass Over b. Skip All c. Ignore d. Ignore All

You use the term linked object to refer to ____ data.

To switch a chart's columns and rows, click the ____________________ button in the Data group on the CHART TOOLS DESIGN tab.

###### in a cell means that the ____.

In the accompanying figure, the dialog box illustrates what element of a function?

You can apply formatting before or after you enter data in a cell or range.

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

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 know that you could retype the information from the Word document. However, what is an easier way to get the information from Word into PowerPoint? a. importing b. baselining c. indexing d. outlining

You should link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

Cells and ranges in a worksheet can be formatted ____.

You can use [ ____ ][Tab] to promote headings in Outline view.

In a pie chart, you can emphasize one data point by plotting , or pulling that slice away from, the pie chart. _________________________

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 want to put a formula in cells D4 through D11 for finding the difference between the two test scores for each student. You enter =C4-B4 in cell D4 and then use what feature to copy the formula down the column through cell D11? a. formula copier b. fill handle c. formula painter d. formula index

A block of text that is formatted with a heading style in Word is not included when it is imported into a PowerPoint presentation.

The $ symbol placed before a row or column address indicates a(n) ____________________ cell reference.

The Excel operator for division is ____.