You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
- The active cell:
- A numeric value can be treated as a label value if it precedes with
- How do you wrap the text in a cell?
- To record a sequence of keystrokes and mouse actions to play back later we use:
- Which of the following is not a basic step in creating a worksheet?
- You can use the horizontal and vertical scroll bars to
- What are the tabs that appear at the bottom of each workbook called?
- Edit >> Delete command
- You can copy data or formulas
- The name box
- While Finding and Replacing some data in Excel, which of the following statement is valid?
- In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
- What does COUNTA () function do?
- Which menu option can be sued to split windows into two
- To create a formula, you first:
- Which of the following is not the correct method of editing the cell content?
- Which of the following is not a worksheet design criterion?
- To save a workbook, you:
- You can move a sheet from one workbook into new book by
- Which is used to perform what if analysis?
- You can enter which types of data into worksheet cells?
- Which would you choose to create a bar diagram?
- How can you show or hide the gridlines in Excel Worksheet?
- What is the short cut key to replace a data with another in sheet?
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- Which of the following series type is not valid for Fill Series dialog box?
- An Excel Workbook is a collection of .......
- MS Excel provides the default value for step in Fill Series dialog box
- Multiple calculations can be made in a single formula using .......
- Which of the following Excel screen components can NOT be turned on or off?