MS Excel Practice Session 4Basic Instructions for MCQ OnlineThe examination will comprise of Objective type Multiple Choice Questions (MCQs)All questions are compulsory and each carries One mark.There will be NO NEGATIVE MARKING for the wrong answers.1. Makes selected cell text italic. Ctrl + F3 Ctrl + F1 Ctrl + F4 Ctrl + F22. What happens when dollar signs ($) are entered in a cell address? ($A$2:$A$10) The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell3. MS Excel has row limit of __________ 16,384 16,484 16,348 16,584 4. How many characters can be typed in a single cell in Excel? 32576 32767 32760 327665. How do you display current date only in MS Excel? Now () Time () Today () Date ()6. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home7. Insert row or column Ctrl + (-) Ctrl + (+) CTRL + 9 Ctrl + O(Zero)8. Insert current system date. Ctrl + : Ctrl + ; Ctrl + ‘ Ctrl + “9. Highlights shortcut keys of Ribbon items. Ctrl + F10 F12 F2 F1010. Opens “Save As” dialog box. F10 F8 F12 F1111. Which of following is Not one of Excel’s what-if function? Auto Outline Goal seek Scenario manager Data table12. To remove the content of selected cells you must issue ______ command Clear All Clear Contents Delete Clear Delete13. Hides selected rows. CTRL + 9 Ctrl + O(Zero) Ctrl + (+) Ctrl + (-)14. Makes selected cell text strikethrough. Ctrl + F2 Ctrl + F3 Ctrl + F4 Ctrl + F515. Makes selected cell text underline. Ctrl + F1 Ctrl + F2 Ctrl + F4 Ctrl + F316. Opens “Go To” dialog box. F12 F11 F5 F917. What does COUNTA () function do? Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number18. Opens “Format Cells” dialog box. Ctrl + F2 Ctrl + F1 Ctrl + F4 Ctrl + F319. Which of the following is an absolute cell reference? A1 $A$1 #a#1 !A!120. Insert current system time. Ctrl + “ Ctrl + ; Ctrl + ‘ Ctrl + :21. Which language is used to create macros in Excel? C Visual C++ Java Visual Basic22. MS Excel file can NOT be directly exported as ______ TXT PDF PPT CSV 23. _____ Key is used to Delete row or column Ctrl + (+) Ctrl + (-) Ctrl + O(Zero) CTRL + 924. Which option is used to display all the content of cell in multiple lines Merge and center Merge cell Wrap text Wrap tex25. How can we use the format painter multiple times? You can use the format painter button on ly one time when youclick it Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button Pressing the Alt key and clicking the format painter button26. ________is the best alternative to MS Excel offered by Google Inc. Google Keep Google Sheets Google Files Google Slides27. F9 Key is used to ____________ Flash fill Auto fill Save As calculate now28. Opens “Create Table” dialog box. CTRL + T Ctrl + Z Ctrl + O Ctrl + U29. Add new worksheet in worksheet Shift + F5 Shift + F10 Shift + F11 Shift + W30. Ctrl + D shortcut key in Excel will None of these Fill down in the selection Open the font dialog box Apply double underline for the active cell31. How can you update the values of formula cells if Auto Calculate mode of Excel is disable? F9 F12 F11 F1032. Creates chart of selected cells. F10 F11 Ctrl + F10 F933. What is the short cut key to highlight the entire column? Ctrl + C Ctrl + Enter Ctrl + Space Bar Ctrl + Page Up34. What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet1!A10 A10 Sheet3.A1035. Which command will you choose to convert a column of data into row? Paste Special > Value Paste Special > horizontal Paste Special > Transpose Cut and Paste36. The Delete key of keyboard is assigned to which command in Excel? Edit > Delete Text Edit > Clear > All Edit > Clear > Contents Edit > Delete37. Makes selected cell text bold. Ctrl + F1 Ctrl + F3 Ctrl + F4 Ctrl + F238. Which of the following is not true regarding Conditional Formatting? You can add more than one condition You can set condition to look for Bold and apply Italics on them You can apply border and pattern formats that meets the specified conditions We can not remove conditional formatting from cell39. Which of the following is invalid statement? Picture can be applied as a background of a sheet Sheet tabs can not be colored Sheet tab can be renamed You can set the column width automatically fit the amount of text40. In MS Excel, Workbook can be closed using keyboard shortcut ______ Ctrl + N Alt + W Shift + W Ctrl + W41. In the formula, which symbol specifies the fixed columns or rows? $ % * :42. MS Excel has maximum column width limit is of __________characters 256 255 356 355 43. Hides selected columns Ctrl + (-) Ctrl + (+) Ctrl + O(Zero) CTRL + 944. How do you wrap the text in a cell? Format cells number Format cells protection Format cells alignment Format cells font45. Which of the following is the correct method of editing the cell content? Press the F2 key Click the formula bar Press the Alt key Double click the cell46. Edit an Excel cell. F3 F4 F5 F247. Microsoft Excel has column limit of __________ 1,047,576 1,048,577 1,048,576 16,384 48. How can you show or hide the gridlines in Excel Worksheet? Data——-> Gridlines None of them View——-> Gridlines Home——-> Gridlines49. In MS Excel, the keyboard shortcut key to Open the Save As dialog box is ________ F12 Ctrl + F10 F11 F250. When all the numbers between 0 and 200 in a range should be displayed in Red Color, Apply _______ Use =if() function to format the required numbers red Sub total have been used Datavalidation have been used Conditional Formatting command on Format menu51. In excel numeric entry are align Left Justify Right Center52. Create a link to a webpage, picture, email address, or any program Bookmark Both A and B Hyperlink Cross reference Loading …Question 1 of 52