Exam 11: Excel 2013 Getting Started With Excel 2013

You frequently need to manage the links you create between files and programs.

The default format for cells that meet a condition with conditional formatting is ____.

To edit an embedded object, you ____ it.

You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________

The x-axis and y-axis are, respectively, the ____.

The ____________________ button on the formula bar is one way to easily insert a function into a worksheet cell.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

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

Explain how you link data other than a chart.

When you are embedding an object in a file, the ____________________ dialog box gives you the option of either creating a new object or inserting an object from a 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. After you have helped Sara fix the spelling mistakes in the workbook, she wants to send it to a business colleague. To send it as an email message attachment, you tell her to open it, click the FILE tab, and then click ____ on the navigation bar. a. Share b. Attach c. Send d. Distribute

Which chart type is the best candidate for spotting trends and extrapolating information based on research data?

Describe four commonly used Excel chart types.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

You can speed up the update of values in Excel linked to an Access table by updating the values manually in the ____ dialog box.

Which of the following will NOT be affected or rearranged by choosing a new layout on the CHART TOOLS DESIGN tab?

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

Which of the following removes only the contents of a selected row or column?

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 have 11 Level 1 headings in the Word outline. How many slides will this generate in PowerPoint? a. 9 b. 10 c. 11 d. It is impossible to say until the import is complete.