Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
- You cannot link excel worksheet data to a word document
- How can you print three copies of a workbook?
- How do you display current date only in MS Excel?
- In Excel, a Data Series is defined as what?
- To activate the previous cell in a pre-selected range, press
- Which of the following methods can not be used to edit the contents of a cell?
- A circular reference is
- You can use the drag and drop method to
- Which is used to perform what if analysis?
- Which of the following is a correct order of precedence in formula calculation?
- You can merge the main document with data source in Excel. In mail merge operation, Word is usually
- Excel displays the current cell address in the ........
- To save a workbook, you:
- The Chart wizard term data categories refers to;
- Multiple calculations can be made in a single formula using
- To select an entire column in MS-EXCEL, press?
- You can convert existing excel worksheet data an charts to an HTML document by using
- Which of the following is not a term of MS-Excel?
- A worksheet range is a
- The chart wizard term data series refers to
- The name box
- What do you call the chart that shows the proportions of how one or more data elements relate to another…
- Documentation should include
- 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?
- How can you remove borders applied in cells?ACC
- Which area in an Excel window allows entering values and formulas?
- To return the remainder after a number is divided by a divisor in EXCEL we use the function?
- What symbol is used before a number to make it a label?
- Concatenation of text can be done using