When all the numbers between 0 and 100 in a range should be displayed in Red Color apply

  1. Home

- Online Exam Test Papers | - MCQs[multiple choice questions and answers ] | - Mock Test Papers | - Practice Papers | - Sample Test Papers |

Question:
When all the numbers between 0 and 100 in a range should be displayed in Red Color apply

1.Use =if function to format the required numbers red

2.Apply Conditional Formatting command on Format menu

3.Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

4.All of above

Posted Date:-2021-02-11 17:36:50

More MCQS Questions and answers

  1. By default Excel provides 3 worksheets. You need only two of them how will you delete the third one?
  2. Ctrl + D shortcut key in Excel will
  3. Edit >> Delete command
  4. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed) you must
  5. To remove the content of selected cells you must issue ______ command
  6. Which of the following is not true about Find and Replace in Excel
  7. Which of the following option is not available in Paste Special dialog box?
  8. While Finding and Replacing some data in Excel which of the following statement is valid?
  9. Comments can be added to cells using
  10. Comments put in cells are called …..
  11. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
  12. How can you remove borders applied in cells?
  13. How can you show or hide the gridlines in Excel Worksheet?
  14. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  15. It is acceptable to let long text flow into adjacent cells on a worksheet when
  16. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  17. Long text can be broken down into many lines within a cell. You can do this through
  18. MS Excel provides the default value for step in Fill Series dialog box
  19. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
  20. Tab scroll buttons are place on Excel screen
  21. The command Edit >> Fill Across Worksheet is active only when
  22. The Delete key of keyboard is assigned to which command in Excel?
  23. The Name box on to the left of formula bar
  24. The short cut key Ctrl + R is used in Excel to
  25. What happens when you press Ctrl + X after selecting some cells in Excel?
  26. What is the short cut key to replace a data with another in sheet?
  27. When a range is selected how can you activate the previous cell?
  28. When a row of data is to be converted into columns
  29. When all the numbers between 0 and 100 in a range should be displayed in Red Color apply
  30. Where can you change automatic or manual calculation mode in Excel?
  31. Where can you set the shedding color for a range of cells in Excel?
  32. Which command will you choose to convert a column of data into row?
  33. Which of the cell pointer indicate that you can move the content to other cell?
  34. Which of the cell pointer indicates that you can fill series?
  35. Which of the cell pointer indicates you that you can make selection?
  36. Which of the following action removes a sheet from workbook?
  37. Which of the following Excel screen components can NOT be turned on or off?
  38. Which of the following is invalid statement?
  39. Which of the following is not the correct method of editing the cell content?
  40. Which of the following is not true regarding Conditional Formatting?
  41. Which of the following series type is not valid for Fill Series dialog box?
  42. Which of the following you can paste selectively using Paste Special command?
  43. Which tool you will use to join some cells and place the content at the middle of joined cell?
  44. You can auto fit the width of column by
  45. You can check the conditions against __________ when applying conditional formatting
  46. You can merge the main document with data source in Excel. In mail merge operation Word is usually
  47. You can move a sheet from one workbook into new book by
  48. You can set Page Border in Excel from
  49. You can use the formula pallette to
  50. You want to set such that when you type Baishakh and drag the fill handle Excel should produce Jestha Aashadh and so on. What will you set to effect that?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!