MS Excel Practice Session 6Basic 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. Open “Microsoft Office Excel Help”. F2 F11 F1 F102. Which language is used to create macros in Excel? Java C Visual Basic Visual C++3. In excel text entry are align to Right Justify Left side Center4. Which of the following is the correct method of editing the cell content? Double click the cell Press the Alt key Press the F2 key Click the formula bar5. Which key is used for help in MS excel? F3 F2 F1 F46. In MS Excel, Workbook can be closed using keyboard shortcut ______ Alt + W Shift + W Ctrl + W Ctrl + N7. 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 used8. 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 text9. Which of the following options can be used to delete comment apply on a cell ? Both A and B Press delete button (keyboard) Review > Delete (comment group) Home > clear> clear comment 10. In the formula, which symbol specifies the fixed columns or rows? % * $ :11. Keep a portion of sheet visible while rest of sheet scrolls Scroll bar Hide column Hide rows Freeze pane12. ________is the best alternative to MS Excel offered by Google Inc. Google Slides Google Sheets Google Keep Google Files13. How can you show or hide the gridlines in Excel Worksheet? Home——-> Gridlines None of them Data——-> Gridlines View——-> Gridlines14. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home15. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Ctrl + W Alt + N Shift + N Ctrl + N16. MS Excel has row limit of __________ 16,584 16,484 16,384 16,348 17. The Delete key of keyboard is assigned to which command in Excel? Edit > Delete Text Edit > Clear > Contents Edit > Delete Edit > Clear > All18. Microsoft Excel has column limit of __________ 1,048,577 16,384 1,047,576 1,048,576 19. Which option is used to display all the content of cell in multiple lines Wrap text Merge and center Wrap tex Merge cell20. Which shortcut is used to insert new worksheet Shift + F11 F12 F11 Ctrl + F1121. Create a link to a webpage, picture, email address, or any program Hyperlink Both A and B Bookmark Cross reference22. _____ can be used as a keyboard shortcut key to check spelling in MS Excel. F2 F6 F11 F723. MS Excel file can NOT be directly exported as ______ TXT PPT CSV PDF 24. which option or function can be used to combined two or more cell value ? Concat Concatnate & flash fill Flash fill25. To remove the content of selected cells you must issue ______ command Clear All Clear Delete Clear Contents Delete26. In excel numeric entry are align Center Left Right Justify27. MS Excel has maximum column width limit is of __________characters 356 255 256 355 28. Is used to arrange data ascending and descending order ? long Filter Sort Format as table29. Opens “Format Cells” dialog box. Ctrl + F3 Ctrl + F4 Ctrl + F2 Ctrl + F130. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & center Merge Cell Merge across Unmerge Cell31. Text function is used to capitalize each word Proper Upper Find Lower32. What happens when dollar signs ($) are entered in a cell address? ($A$2:$A$10) Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address33. Open a new window containing a view of the current windows Home > Insert > Insert sheet File > New New > file View > New Window34. How many sheets can be added in Excel file ? 255 210 256 253 Loading …Question 1 of 34