Change the text direction of the vertical axis title number of participants to horizontal Quizlet

1.
- Select the range B4:H4 as the first range to format.

- While holding down the ctrl key, select the nonadjacent ranges B6:H6, B9:H9, B14:H14, and B16:H16, and then release the ctrl key to select nonadjacent ranges.

- Click the Number Format Dialog Box Launcher (Home tab | Number group) to display the Format Cells dialog box.

- Click Currency in the Category list (Format Cells dialog box), if necessary select 2 in the Decimal places box and then select $ in the Symbol list to ensure a dollar sign shows in the cells to be formatted, and select the black font color ($1,234.10) in the Negative numbers list to specify the desired currency style for the selected ranges.

2.
- Click the OK button (Format Cells dialog box) to close the Format Cells dialog box and apply the desired format to the selected ranges.

- Select the range B5:H5 as the next range to format.

- While holding down the ctrl key, select the range B10:H13, and then release the ctrl key to select nonadjacent ranges.

- Click the Number Format Dialog Box Launcher (Home tab | Number group) to display the Format Cells dialog box.

- Click Currency in the Category list (Format Cells dialog box), if necessary select 2 in the Decimal places box, select None in the Symbol list so that a dollar sign does not show in the cells to be formatted, and select the black font color (1,234.10) in the Negative numbers list.

3.
- Click the OK button (Format Cells dialog box) to close the Format Cells dialog box and apply the desired format to the selected ranges.

- Select an empty cell and display the formatted numbers.

Other Ways:
1.
Right-click range, click Format Cells on shortcut menu, click Number tab (Format Cells dialog box), click category in Category list, select format, click OK button (Format Cells dialog box).

2.
Press ctrl+1, click Number tab (Format Cells dialog box), click category in Category list, select format, click OK button (Format Cells dialog box).

Where would you click to edit the Y axis label quizlet?

Click anywhere along the Y axis to activate it. 2. Click the Format tab in the Chart Tools section of the Ribbon. 3.

Where would you click to update the wording of the charts horizontal axis title quizlet?

On the shortcut menu, click Format Axis. The Format Axis task pane opens with Axis Options displayed.In the Units section of the task pane, select the value in the Major text box, type 10000, and press ENTER.

Which Excel dialog box do you use to fill a series based on extrapolation quizlet?

Click the Trend check box. Excel will calculate the values between the starting value and the ending value based on a constant percentage of growth from year to year. Click OK. EX9829 Fill a series based on extrapolation.

How do you create a new conditional formatting rule that formats the top five cells in the range with an orange accent six cell background color?

Create a custom conditional formatting rule Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.