MS Excel Practice Session 5Basic 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. Microsoft Excel has column limit of __________ 1,048,576 1,048,577 1,047,576 16,384 2. Text function is used to capitalize each word Find Proper Upper Lower3. Open a new window containing a view of the current windows File > New New > file View > New Window Home > Insert > Insert sheet4. ________is the best alternative to MS Excel offered by Google Inc. Google Files Google Keep Google Slides Google Sheets5. MS Excel has row limit of __________ 16,584 16,384 16,348 16,484 6. When all the numbers between 0 and 200 in a range should be displayed in Red Color, Apply _______ Conditional Formatting command on Format menu Sub total have been used Use =if() function to format the required numbers red Datavalidation have been used7. Which of the following is the correct method of editing the cell content? Click the formula bar Press the F2 key Press the Alt key Double click the cell8. In excel numeric entry are align Justify Left Center Right9. which option or function can be used to combined two or more cell value ? Concatnate & flash fill fill Flash Concat10. Which shortcut is used to insert new worksheet F11 Ctrl + F11 Shift + F11 F1211. Keep a portion of sheet visible while rest of sheet scrolls Hide column Freeze pane Hide rows Scroll bar12. Which option is used to join the selected cells into single cell and center the content of cell ? Merge across Merge Cell Merge & center Unmerge Cell13. Which of the following options can be used to delete comment apply on a cell ? Press delete button (keyboard) Home > clear> clear comment Both A and B Review > Delete (comment group) 14. To remove the content of selected cells you must issue ______ command Delete Clear All Clear Delete Clear Contents15. _____ can be used as a keyboard shortcut key to check spelling in MS Excel. F7 F6 F11 F216. 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 cell17. Which option is used to display all the content of cell in multiple lines Merge cell Wrap tex Wrap text Merge and center18. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Home Press Ctrl + Home Press Shift + Home Press Alt + Home19. Opens “Format Cells” dialog box. Ctrl + F4 Ctrl + F3 Ctrl + F2 Ctrl + F120. How can you show or hide the gridlines in Excel Worksheet? Data——-> Gridlines View——-> Gridlines None of them Home——-> Gridlines21. Which key is used for help in MS excel? F2 F3 F1 F422. The Delete key of keyboard is assigned to which command in Excel? Edit > Clear > All Edit > Clear > Contents Edit > Delete Text Edit > Delete23. Which language is used to create macros in Excel? Visual Basic C Visual C++ Java24. Open “Microsoft Office Excel Help”. F1 F2 F11 F1025. MS Excel has maximum column width limit is of __________characters 356 355 256 255 26. In excel text entry are align to Justify Right Center Left side27. Is used to arrange data ascending and descending order ? Format as table Sort long Filter28. In the formula, which symbol specifies the fixed columns or rows? : % $ *29. MS Excel file can NOT be directly exported as ______ PPT TXT PDF CSV 30. In MS Excel, Workbook can be closed using keyboard shortcut ______ Ctrl + W Shift + W Ctrl + N Alt + W31. Create a link to a webpage, picture, email address, or any program Both A and B Bookmark Hyperlink Cross reference32. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Ctrl + W Shift + N Ctrl + N Alt + N33. How many sheets can be added in Excel file ? 256 253 210 25534. Which of the following is invalid statement? Sheet tabs can not be colored Sheet tab can be renamed Picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Loading …Question 1 of 34