MS Office Excel
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Apply Conditional Formatting command on Format menu
Related posts
Which tool you will use to join some cells and place the content at the middle of joined cell?A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
A(n) _________ is a prewritten formula that is built into EXCEL.
A. function
B. problem
C. equation
D. equal sign
The design of text.
A. Font
B. Cell
C. Range
D. Merge
You can print only an embedded chart by
A. Moving the chart to a chart sheet before you print.
B. Formatting the chart before you print
C. Selecting the chart before you print
D. a and c
Colton is calculating his GPA. If he uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
A. Values
B. Formulas
C. Labels
D. Functions
Which of the following is the oldest spreadsheet package?
A. VisiCalc
B. Lotus 1-2-3
C. Excel
D. StarCalc
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cell in that range that contain 100. Wha
A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF
Leave a Reply