FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50, 000 with a yellow fill color and dark yellow text. Which formatting style should he select?
A
Borders
B
Cell Style
C
Conditional Formatting
D
Format as Table
Explanation: 

Detailed explanation-1: -Select the cell or range of cells you want to format. Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want.

Detailed explanation-2: -Select one or more cells in a range, table, or PivotTable report. On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Top/Bottom Rules. Select the command you want, such as Top 10 items or Bottom 10 %. Enter the values you want to use, and then select a format.

Detailed explanation-3: -On the Home tab, click Conditional Formatting. Point to Highlight Cells Rules, and then click Text that Contains. Type the text that you want to highlight, and then click OK.

There is 1 question to complete.