MS- Excel Question Bank With Answers 2023.

Question 1-1. Comments put in cells are called ….. Select Your Answer =========== 1-2. Comments can be added to cells using ….. Select Your Answer =========== 1-3. Which menu option can be used to split windows into two? Select Your Answer =========== 1-4. Getting data from a cell located in a different sheet is called…. Select Your Answer =========== 1-5. Which of the following is not a valid data type in Excel? Select Your Answer =========== 1-6. Which elements of a worksheet can be protected from accidental modification? Select Your Answer =========== 1-7. A numeric value can be treated as label value if …… precedes it. Select Your Answer =========== 1-8. Concatenation of text can be done using Select Your Answer =========== Page 1 MS- Excel Question Bank With Answers 2023 1-9. Which area in an Excel window allows entering values and formulas? Select Your Answer =========== 1-10. . Multiple calculations can be made in a single formula using….. Select Your Answer =========== 2-1. An Excel Workbook is a collection of ……. Select Your Answer =========== 2-2. What do you mean by a Workspace? Select Your Answer =========== 2-3. MS-EXCEL is based on ……….? Select Your Answer =========== 2-4. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..? Select Your Answer =========== 2-5. To select an entire column in MS-EXCEL, press? Select Your Answer =========== 2-6. To return the remainder after a number is divided by a divisor in EXCEL we use the function? Page 2 MS- Excel Question Bank With Answers 2023 Select Your Answer =========== 2-7. Which function is not available in the Consolidate dialog box? Select Your Answer =========== 2-8. Which is not the function of “Edit, Clear” command? Select Your Answer =========== 2-9. Microsoft Excel is a powerful……….. Select Your Answer =========== 2-10. . How do you rearrange the data in ascending or descending order? Select Your Answer =========== 3-1. Which Chart can be created in Excel? Select Your Answer =========== 3-2. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′? Select Your Answer =========== 3-3. How do you display current date and time in MS Excel? Select Your Answer =========== 3-4. How do you display current date only in MS Excel? Select Your Answer =========== 3-5. How do you wrap the text in a cell? Page 3 MS- Excel Question Bank With Answers 2023 Select Your Answer =========== 3-6. What does COUNTA () function do? Select Your Answer =========== 3-7. What is the short cut key to highlight the entire column? Select Your Answer =========== 3-8. In the formula, which symbol specifies the fixed columns or rows?