What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
- To create a formula, you first:
- Which of the following format you can decide to apply or not in AutoFormat dialog box?
- Data can be arranged in a worksheet in a easy to understand manner using
- Which of the following is not true about Find and Replace in Excel
- When you insert an excel file into a word document. The data are
- Which is not the function of Edit, Clear command?
- Status indicators are located on the
- A typical worksheet has …. Number of columns
- What is the correct way to refer the cell A10 on sheet3 from sheet1?
- Which button do you click to add up a series of numbers?
- Which Chart can be created in Excel?
- Tab scrolling button
- Multiple calculations can be made in a single formula using .......
- Ctrl + D shortcut key in Excel will
- You can use the format painter multiple times before you turn it off by
- Which of the following is not the correct method of editing the cell content?
- Concatenation of text can be done using
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- The autofill feature
- MS Excel provides the default value for step in Fill Series dialog box
- You want to track the progress of the stock market on a daily basis. Which type of chart should you…
- To remove the content of selected cells you must issue ______ command
- Which of the following is not information you can specify using the solver?
- Which of the following is the latest version of Excel
- Getting data from a cell located in a different sheet is called ......
- Edit >> Delete command
- While Finding and Replacing some data in Excel, which of the following statement is valid?
- What do you mean by a Workspace?
- What are the tabs that appear at the bottom of each workbook called?
- When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply