Exam 3: Working With Large Worksheets, charting, and What-If Analysis

Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click)Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?

Which of the following is true about changing worksheet column width?

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

You double-click the Format Painter button when you want to _____.

Which of the following is true about moving cell contents?

Nathan wants TRUE to be elicited if either of the statements are true,and FALSE if both are true.Which of the following formula can he use to ensure that?

Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet.Which of the following series of clicks will help her do so?

How can you remove Split panes in a worksheet you are working on?

To which of the following chart types can you not add axis titles?

Which of the following is true when you copy and paste formulas using the fill handle?

When you select a cell range,the cells must be adjacent to each other.

To show formulas instead of values,click on the Formulas tab in the ribbon,then in the Formula Auditing group,click on the Show Formulas option.

Arlo wants to use goal seek to answer "what if" questions in a file.To do this,he clicks the cell in the spreadsheet that he wants to change,then selects the "X" button from the Data tab and selects Goal seek...from the drop down menu.What is X in the procedure?

Which of the following is true when you delete a cell?

Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change?

When you change cell contents to italics,you are changing the cell's alignment.

Jose inserts the formula '=DATE('2000,2,2)' in cell AI5.Upon pressing ENTER,2/2/2000 will appear in AI5.

After you delete a worksheet column,_____.

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

To change the name of a worksheet,you rename the _____.