Exam 11: Excel 2013 Getting Started With Excel 2013

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. Eamon has a chart from Excel that he put into Word and without doing anything, Word automatically created a relationship between that pasted chart and the original chart. What kind of connection did Word create? a. a link b. an embed c. a paste index d. a lineage

The color of a tab changes depending on whether it is the ____________________ tab.

You can prepare a report in Word that contains a chart you created in Excel.

Office technology allows you to ____, or place an unlinked copy of, the contents of a Word file into an Excel worksheet.

Discuss the guidelines that you should use for planning a chart.

According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10 . _________________________

The formula =A4+A8*($B$12) is an example of a(n) ____________________ formula.

The default border color around a chart title is ____.

Suppose you have placed the following items to the Clipboard in the following order: a photograph, a text value, a column chart, and a table. If the items were copied in the order listed, the ____ would be at the bottom of the list.

To quickly jump to the last cell in a worksheet press ____.

To complete the days of the week sequence that begins with the days Monday, Tuesday; the Excel user would select the cells containing Monday and Tuesday and use the ____________________ to complete the sequence.

When you embed an object, you create a link to the source file.

=D8+E8*0.5 is a complex formula.

Describe the rules for pasting an Access table into PowerPoint.

You can quickly create a miniature chart called a(n) ____________________ that serves as a visual indicator of data trends directly within 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. Excel has flagged a spelling mistake and Sara has decided that she would like to adjust the spelling of all instances of this misspelling. Which option do you tell her to select? a. Respell All b. Change All c. New Spelling d. Autospell

Reference operators compare values for the purpose of true/false results. _____________________

If a linked value did not update after making a change in a source file, click the FILE tab, click Edit Links to Files in the lower-right corner of the dialog box, and then click ____.

Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet. ____________________

When you insert an Excel chart into a PowerPoint presentation, you usually need to select a new chart ____________________ so the data is easy to read on a slide.