91. Which command will you choose to convert a column of data into row? A. Cut and Paste B. Paste Special > Transpose C. Both of above D. None of above ✅ The correct answer is option B.
92. Which tool you will use to join some cells and place the content at the middle of joined cell? A. From Format Cells dialog box click on Merge Cells check box B. From Format Cells dialog box select the Centered alignment C. From Format Cells dialog box choose Merge and Center check box D. Click on Merge and Center tool on formatting toolbar ✅ The correct answer is option A.
93. The shortcut key Ctrl + R is used in Excel to A. Right align the content of cell B. Remove the cell contents of selected cells C. Fill the selection with active cells to the right D. None of above ✅ The correct answer is option C.
94. Which Chart can be created in Excel? A. Area B. Line C. Pie D. All of the above ✅ The correct answer is option D.
95. To select an entire column in MS-EXCEL, press? A. CTRL + C B. CTRL + Arrow key C. CTRL + S D. None of the above ✅ The correct answer is option D.
96. The Delete key of keyboard is assigned to which command in Excel? A. Edit > Clear > Contents B. Edit > Clear > All C. Edit > Delete D. All of above ✅ The correct answer is option A.
97. Which of the following you can paste selectively using Paste Special command? A. Validation B. Formats C. Formulas D. All of above ✅ The correct answer is option D.
98. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ? A. 5430 B. 5436.80 C. 5436.8 D. 6.8 ✅ The correct answer is option B.
99. You can move a sheet from one workbook into new book by A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK B. From Edit menu choose Move of Copy then choose (Move to end) and click OK C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK D. None of above ✅ The correct answer is option C.
100. Where can you change automatic or manual calculation mode in Excel? A. Double CAL indicator on status bar B. Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button C. Both of above D. None of above ✅ The correct answer is option B.