Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
- To copy cell contents using drag and drop press the
- The name box
- Paste Special allows some operation while you paste to new cell. Which of the following operation is…
- In a worksheet you can select
- Which command will you choose to convert a column of data into row?
- Which elements of worksheet can be protected from accidental modification
- Which of the following is not a basic step in creating a worksheet?
- What symbol is used before a number to make it a label?
- To delete an embedded objects, first
- To save a workbook, you:
- Which of the following is invalid statement?
- You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
- Which of the following methods cannot be used to enter data in a cell
- Which button do you click to add up a series of numbers?
- How can you print three copies of a workbook?
- Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
- How many characters can be typed in a single cell in Excel?
- Which of the following you can paste selectively using Paste Special command?
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- Comments can be added to cells using ......
- To view a cell comment
- To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
- Which of the following Excel screen components can NOT be turned on or off?
- The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
- What do you mean by a Workspace?
- Which menu option can be sued to split windows into two
- You can select a single range of cells by
- Status indicators are located on the
- By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
- Rounding errors can occur