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 + F2 Ctrl + F3 Ctrl + F1 Ctrl + F42. How many characters can be typed in a single cell in Excel? 32767 32760 32766 325763. Edit an Excel cell. F5 F2 F3 F44. Hides selected columns Ctrl + O(Zero) Ctrl + (+) CTRL + 9 Ctrl + (-)5. Which of the following is not true regarding Conditional Formatting? We can not remove conditional formatting from cell 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 conditions6. How can you show or hide the gridlines in Excel Worksheet? Home——-> Gridlines Data——-> Gridlines View——-> Gridlines None of them7. Which of following is Not one of Excel’s what-if function? Auto Outline Scenario manager Goal seek Data table8. How can you update the values of formula cells if Auto Calculate mode of Excel is disable? F11 F12 F10 F99. ________is the best alternative to MS Excel offered by Google Inc. Google Keep Google Sheets Google Files Google Slides10. What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + Space Bar Ctrl + C Ctrl + Enter11. Microsoft Excel has column limit of __________ 1,048,576 1,048,577 16,384 1,047,576 12. Which language is used to create macros in Excel? Visual C++ Java Visual Basic C13. Insert current system date. Ctrl + ‘ Ctrl + “ Ctrl + ; Ctrl + :14. Which of the following is invalid statement? Sheet tab can be renamed You can set the column width automatically fit the amount of text Picture can be applied as a background of a sheet Sheet tabs can not be colored15. In excel numeric entry are align Left Justify Right Center16. Add new worksheet in worksheet Shift + W Shift + F5 Shift + F11 Shift + F1017. Opens “Go To” dialog box. F5 F11 F12 F918. What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet3!A10 Sheet1!A10 Sheet3.A1019. How do you wrap the text in a cell? Format cells number Format cells protection Format cells alignment Format cells font20. The Delete key of keyboard is assigned to which command in Excel? Edit > Delete Text Edit > Clear > All Edit > Delete Edit > Clear > Contents21. F9 Key is used to ____________ Save As calculate now Auto fill Flash fill22. Opens “Format Cells” dialog box. Ctrl + F4 Ctrl + F3 Ctrl + F1 Ctrl + F223. Which command will you choose to convert a column of data into row? Paste Special > Transpose Paste Special > horizontal Cut and Paste Paste Special > Value24. MS Excel has row limit of __________ 16,384 16,584 16,484 16,348 25. In the formula, which symbol specifies the fixed columns or rows? * : % $26. MS Excel has maximum column width limit is of __________characters 356 256 255 355 27. Hides selected rows. CTRL + 9 Ctrl + (+) Ctrl + O(Zero) Ctrl + (-)28. Opens “Create Table” dialog box. CTRL + T Ctrl + O Ctrl + U Ctrl + Z29. Opens “Save As” dialog box. F11 F8 F10 F1230. Ctrl + D shortcut key in Excel will Fill down in the selection Open the font dialog box Apply double underline for the active cell None of these31. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home32. Highlights shortcut keys of Ribbon items. F12 F2 Ctrl + F10 F1033. In MS Excel, the keyboard shortcut key to Open the Save As dialog box is ________ F11 Ctrl + F10 F2 F1234. Which option is used to display all the content of cell in multiple lines Merge and center Wrap text Wrap tex Merge cell35. Which of the following is the correct method of editing the cell content? Double click the cell Press the Alt key Click the formula bar Press the F2 key36. In MS Excel, Workbook can be closed using keyboard shortcut ______ Ctrl + W Shift + W Ctrl + N Alt + W37. _____ Key is used to Delete row or column CTRL + 9 Ctrl + (-) Ctrl + (+) Ctrl + O(Zero)38. Makes selected cell text strikethrough. Ctrl + F4 Ctrl + F2 Ctrl + F3 Ctrl + F539. Makes selected cell text underline. Ctrl + F2 Ctrl + F3 Ctrl + F4 Ctrl + F140. What happens when dollar signs ($) are entered in a cell address? ($A$2:$A$10) An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell41. Insert current system time. Ctrl + ; Ctrl + ‘ Ctrl + : Ctrl + “42. How do you display current date only in MS Excel? Now () Date () Time () Today ()43. Makes selected cell text bold. Ctrl + F2 Ctrl + F4 Ctrl + F1 Ctrl + F344. To remove the content of selected cells you must issue ______ command Delete Clear Delete Clear All Clear Contents45. How can we use the format painter multiple times? Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when youclick it46. What does COUNTA () function do? Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets47. When all the numbers between 0 and 200 in a range should be displayed in Red Color, Apply _______ Conditional Formatting command on Format menu Datavalidation have been used Use =if() function to format the required numbers red Sub total have been used48. Create a link to a webpage, picture, email address, or any program Bookmark Both A and B Hyperlink Cross reference49. Insert row or column Ctrl + (-) CTRL + 9 Ctrl + (+) Ctrl + O(Zero)50. Which of the following is an absolute cell reference? $A$1 #a#1 A1 !A!151. MS Excel file can NOT be directly exported as ______ TXT PPT PDF CSV 52. Creates chart of selected cells. Ctrl + F10 F9 F11 F10 Loading …Question 1 of 52