You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
- Which elements of a worksheet can be protected from accidental modification?
- Comments can be added to cells using ......
- How do you display current date only in MS Excel?
- Which of the following is not true regarding Conditional Formatting?
- Right clicking something in Excel:
- What will be the output if you format the cell containing 5436.8 as #,##0.00'?
- Where can you change automatic or manual calculation mode in Excel?
- Which menu option can be sued to split windows into two
- How do you delete a column?
- Status indicators are located on the
- A numeric value can be treated as label value if ...... precedes it.
- Which of the following is not true about Find and Replace in Excel
- To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
- While Finding and Replacing some data in Excel, which of the following statement is valid?
- You can use the format painter multiple times before you turn it off by
- Where can you set the shading color for a range of cells in Excel?
- Which of the following is not information you can specify using the solver?
- Which of the following is a popular DOS based spreadsheet package?
- Which key do you press to check spelling?
- When integrating word and excel, word is usually the
- You can use the horizontal and vertical scroll bars to
- Which of the following is not a valid data type in excel
- To view a cell comment
- Comments put in cells are called .....
- An excel workbook is a collection of
- You can move a sheet from one workbook into new book by
- Long text can be broken down into many lines within a cell. You can do this through
- When you want to insert a blank imbedded excel object in a word document you can
- Which would you choose to create a bar diagram?
- To copy formatting from one area in a worksheet and apply it to another area you would use: