Exam 11: Excel 2013 Getting Started With Excel 2013

The area inside the horizontal and vertical axes is the legend . _________________________

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 finding the Yearly Sales figures in cell F4 for the Downtown store. a. =TOT(B4:E4) b. =SUM(B4:E4) c. =AVERAGE(B4:E4) d. =ADD(B4:E4)

An Excel user should use a relative cell reference when it is important to ____.

In the accompanying figure, item 4 points to a ____.

When you embed a worksheet object in a PowerPoint slide, you generally want to show only the ____ that contain data.

An absolute cell reference changes the cell references when the formula is copied to a new location.

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You want to preview just the chart before you print the chart sheet. What command do you use? a. Preview on the PRINT tab b. Print on the FILE tab c. Sneak Peek on the PRINT tab d. Display on the FILE tab

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

In the accompanying figure, item 2 points to a ____.

It can be difficult to see a(n) ___________________ when a cell is selected.