MS Excel MCQ

 MCQ Question:  (Q.25) How do you insert a row? Options: A. Right-click the row heading where you want to insert the new row and select… Read More »How do you insert a row?

 MCQ Question:  (Q.24) Which of the following you can paste selectively using Paste Special command? Options: A. Validation B. Formats C. Formulas D. All of… Read More »Which of the following you can paste selectively using Paste Special command?

 MCQ Question:  (Q.23) What is the short cut key to replace a data with another in sheet? Options: A. Ctrl + R B. Ctrl +… Read More »What is the short cut key to replace a data with another in sheet?

 MCQ Question:  (Q.22) How do you select an entire column? Options: A. Select Edit > Select > Column from the menu B. Click the column… Read More »How do you select an entire column?

 MCQ Question:  (Q.21) Which of the following is not a basic step in creating a worksheet? Options: A. Save workbook B. Modifiy the worksheet C.… Read More »Which of the following is not a basic step in creating a worksheet?

 MCQ Question:  (Q.20) MS Excel provides the default value for step in Fill Series dialog box Options: A. 0 B. 1 C. 5 D. 10… Read More »MS Excel provides the default value for step in Fill Series dialog box

 MCQ Question:  (Q.19) Comments put in cells are called Options: A. Smart tip B. Cell tip C. Web tip D. Soft tip Correct Answer: Option… Read More »Comments put in cells are called

 MCQ Question:  (Q.17) The name box Options: A. Shows the location of the previously active cell B. Appears to the left of the formula bar… Read More »The name box

 MCQ Question:  (Q.18) To remove the content of selected cells you must issue __ command Options: A. Edit >> DeleteB. Edit >> Clear >> ContentsC.… Read More »To remove the content of selected cells you must issue __ command

 MCQ Question:  (Q.16) Which is used to perform what if analysis? Options: A. Solver B. Goal seek C. Scenario Manager D. All of above Correct… Read More »Which is used to perform what if analysis?