Ms excel questions with answers
136 multiple-choice questions. Open any question for its answer and explanation.
- While Finding and Replacing some data in Excel, which of the following statement is valid?
- Which of the following is not true about Find and Replace in Excel
- You can move a sheet from one workbook into new book by
- What is the shortcut key to replace a data with another in sheet?
- Comments can be added to cells using ________
- Which menu option can be used to split windows into two?
- Getting data from a cell located in a different sheet is called ________
- Which of the following is not a valid data type in Excel?
- Which elements of a worksheet can be protected from accidental modification?
- Which area in an Excel window allows entering values and formulas?
- Multiple calculations can be made in a single formula using ________
- An Excel Workbook is a collection of ________
- What do you mean by a Workspace?
- MS-EXCEL is based on ________
- In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.
- To select an entire column in MS-EXCEL, press?
- To return the remainder after a number is divided by a divisor in EXCEL we use the function?
- Which function is not available in the Consolidate dialog box?
- Which is not the function of "Edit, Clear" command?
- Microsoft Excel is a powerful ________
- How do you rearrange the data in ascending or descending order?
- Which Chart can be created in Excel?
- What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?
- How do you display current date and time in MS Excel?
- How do you display current date only in MS Excel?