Exam 11: Excel 2013 Getting Started With Excel 2013

You can use predesigned, formatted files called ____ to create new worksheets quickly.

When copying or moving formulas in an Excel worksheet, the default type of cell reference is ____________________.

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

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. If Sara adds words to the dictionary using any of the following EXCEPT ____, you tell her that the words will also available in Excel. a. Word b. PowerPoint c. Access d. OneNote

Explain how you can integrate objects that you create in Word, Excel, and Access into PowerPoint presentations.

To link data other than a chart, you use the Copy button and the Update Link command to create a link between the source file and the destination file. _________________________

In the accompanying figure, item 3 points to a button that ____ the level of selected text.

When you change data in a source file, linked data also changes in the ____________________ file.

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 word in the worksheet that appears to be misspelled in a given instance, but she would like it to be ignored in this one instance. Which option do you tell her to select? a. Pass b. Skip c. Ignore d. Ignore All

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 wants to copy the contents of a cell containing a formula in an important Excel worksheet and paste it into the Word document on which he is working. He is expecting that this value may continue to change in Excel for a few more days into his production schedule. Which option should he use to connect this data? a. linking b. embedding c. copying and pasting d. connecting

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result:  =22/2*5  =22/(2*5).

You embed an object in a PowerPoint slide when you want to access the object in its source program, even if the source file is not available. _________________________

Possible paper orientations for printing a worksheet are landscape and ____.

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the HOME tab, and then click a style in the gallery.

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

Which chart type is the best candidate for emphasizing sales trends over a period of 6 months?

Text annotations are ____ that you can add to further describe the data in your chart.

You can paste an Access table as a link in PowerPoint.