Exam 11: Excel 2013 Getting Started With Excel 2013

It is acceptable for dates to have a currency format.

You cannot insert a Word file into an Excel worksheet.

In the accompanying figure, item ____ shows the button that centers text horizontally within the cell.

In the accompanying figure, item 1 is the ____ button.

The Undo button allows you to reverse up to ____ previous actions, one at a time.

Critical Thinking Questions Case 1-1 You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company's sales to send to the General Manager. The accompanying figure is the worksheet that you have created so far. Write the complete formulas for the Total row, cell C8 to calculate the second quarter sales for the three stores. a. =SUM(C4:C6) b. =TOT(C4-C6) c. =TOT(C4:C6) d. =SUM(C4_C6)

How do you embed a file that you create in one Office program into a document created in another Office program? What does this permit you to do?

Any time you use a worksheet to ask the question "what if?" you are performing ____________________ analysis.

Each value in a cell selected for a chart is called a ____.

Which of the following indicates the number of slides contained in a presentation?

You can ____ an entire file that you create in one Office program in a document created in another Office program.

The Format Painter button copies both the cell's content and formatting.

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 put a Word file into an Excel worksheet and he can edit the file using Word program tools to change text and formatting. Which method did he use to integrate Word and Excel in this case? a. linking b. embedding c. copying and pasting d. connecting

Printing gridlines makes data easier to read.

Explain the purpose of the Object command.

The default Accounting number format adds dollar signs and ____ decimal places to the data.

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

Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________

When you insert an object into a worksheet from another program such as Word, you sometimes need to reposition the current worksheet contents to accommodate the inserted object.

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 wants to indicate to Excel that a given flagged word should not be marked as a misspelling in the future. Which option do you tell her to select? a. Not misspelled b. Ignore All c. Add to Dictionary d. Autospell