Exam 11: Excel 2013 Getting Started With Excel 2013

What do you have the ability to do when you use Excel?

Which of the following is NOT a Paste list arrow option?

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, the spelling of which she would like to change in this one instance. Which option do you tell her to select? a. Change b. Respell c. Adjust d. New Spelling

To refresh an Excel chart's chart data in Word, click the ____ tab, and then click the Refresh Data button in the Data group.

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. Which function can be used to eliminate the two decimal places in all cells with values that include decimal places in the accompanying figure?

After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain relative cell references. _________________________

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. If you want to reposition the chart by changing a page's margins, where do you find the Show Margins button to display the margins in preview? a. Margins tab c. Print tab b. File tab d. Display tab

In the accompanying figure, item 5 points to ____ text.

Discuss how the order of precedence works in the formula =25+2/3 and =(25+2)/3. Describe the order of calculations in your answer.

A combination chart can add a(n) ____ axis to chart related data.

As shown in the accompanying figure, item ____ points to the cell pointer, which outlines the active cell.

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.

Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.

Any data changed in the worksheet is automatically updated in the chart.

Which chart type do you use to compare distinct objects over time using horizontal bars?

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

When you are editing an embedded file, you can determine the name of the destination file by examining the ____.

A scatter chart ____.

When you click the Demote button once while Body text is selected, the text moves to the right ____ tab stop(s) and changes from subtitle text to a Level 2 heading.