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
- When the formula bar is active, you can see
- When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
- Which of the following is not a valid data type in excel
- Which of the following is not the correct method of editing the cell content?
- The Delete key of keyboard is assigned to which command in Excel?
- A typical worksheet has …. Number of columns
- Comments put in cells are called
- Which of the following methods can not be used to edit the contents of a cell?
- To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
- Which of the following is the latest version of Excel
- By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
- Which of the following is invalid statement?
- A __________ is a grid with labeled columns and rows.
- It is acceptable to let long text flow into adjacent cells on a worksheet when
- Getting data from a cell located in a different sheet is called ......
- Which would you choose to create a bar diagram?
- Tab scrolling button
- Concatenation of text can be done using
- Which of the following Excel screen components can NOT be turned on or off?
- Which is not the function of Edit, Clear command?
- To remove the content of selected cells you must issue ______ command
- Which of the following is not a term of MS-Excel?
- When you insert an excel file into a word document. The data are
- Which is used to perform what if analysis?
- Which of the following is not an example of a value?
- Long text can be broken down into many lines within a cell. You can do this through
- The auto calculate feature
- Which of the following is not true about Find and Replace in Excel
- Which command will you choose to convert a column of data into row?
- In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?