Exam 11: Excel 2013 Getting Started With Excel 2013

In the formula =D1+C1/F3, which calculation will be performed first?

You can change, or ____, the contents of an active cell at any time.

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____.

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________

After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish. _________________________

To insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the HOME tab, and then click Average. _________________________

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 want your PowerPoint presentation to include the latest information from the Word document, because you anticipate that your teammates may still be updating the source document. Which of the following integration strategies should you use? a. embedding b. linking c. copying and pasting d. replacement

In the accompanying figure, item ____ shows the button that centers text across columns.

You can apply font styles and alignment options using the ____ dialog box.

A chart must be located in a specific cell or at a specific address range.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

To format a cell or range, first you select it, and then you apply the formatting using the ____, the Mini toolbar, or a keyboard shortcut.

In the accompanying figure, the Paste Options button labeled ____ is selected by default when a chart is pasted into a destination document.

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. After some time goes by, you realize that your team will no longer be updating the Word document, but now your concern is continuing to have access to the information in the original Word application. Which of the following integration strategies should you use? a. replacement b. linking c. copying and pasting d. embedding

In the accompanying figure, the entry in cell B15 is a ____.

In the accompanying figure, item 1 points to the ____ button.

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

An Excel complex formula uses more than one arithmetic operator.

To move one screen to the left press ____.