Computer Skills 问题

To rotate cell contents to an exact value, you change its __________.

To copy a cell's formatting to another cell, which of the following can you use?

To select nonadjacent cells or ranges on a worksheet, you can press and hold ___________ while selecting each one.

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?

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

In the formula =B6*$B$2, which of the following describes $B$2?

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed?

To preserve an exact cell address in a copied formula, you can use a relative cell reference. T/F

To move a worksheet, you can drag its sheet tab to the left or right. T/F

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze Top Row. T/F

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

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

Decreasing a cell's indent moves its contents to the right one space. T/F

To rotate cell contents, you use the Alignment tab in the Format Cells dialog box. T/F

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

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

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK. T/F

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

Bart needs to apply a sparkline style to a sparkline chart. To do so , he can click on the following: Sparkline chart > Design > Style (choose a style). T/F

A student wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK. T/F