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. Is used to arrange data ascending and descending order ? long Format as table Filter Sort2. When all the numbers between 0 and 200 in a range should be displayed in Red Color, Apply _______ Sub total have been used Datavalidation have been used Conditional Formatting command on Format menu Use =if() function to format the required numbers red3. Keep a portion of sheet visible while rest of sheet scrolls Scroll bar Hide column Freeze pane Hide rows4. The Delete key of keyboard is assigned to which command in Excel? Edit > Clear > All Edit > Clear > Contents Edit > Delete Text Edit > Delete5. Open “Microsoft Office Excel Help”. F2 F1 F10 F116. In excel numeric entry are align Justify Center Right Left7. Which language is used to create macros in Excel? C Visual C++ Java Visual Basic8. In excel text entry are align to Center Left side Right Justify9. Which of the following options can be used to delete comment apply on a cell ? Both A and B Press delete button (keyboard) Home > clear> clear comment Review > Delete (comment group) 10. Text function is used to capitalize each word Find Upper Lower Proper11. How many sheets can be added in Excel file ? 255 253 256 21012. _____ can be used as a keyboard shortcut key to check spelling in MS Excel. F7 F6 F11 F213. Opens “Format Cells” dialog box. Ctrl + F1 Ctrl + F2 Ctrl + F4 Ctrl + F314. In MS Excel, Workbook can be closed using keyboard shortcut ______ Shift + W Alt + W Ctrl + W Ctrl + N15. MS Excel has maximum column width limit is of __________characters 355 356 256 255 16. Which key is used for help in MS excel? F3 F1 F4 F217. To remove the content of selected cells you must issue ______ command Clear All Clear Contents Clear Delete Delete18. Open a new window containing a view of the current windows Home > Insert > Insert sheet New > file File > New View > New Window19. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Ctrl + N Shift + N Alt + N Ctrl + W20. ________is the best alternative to MS Excel offered by Google Inc. Google Sheets Google Slides Google Keep Google Files21. which option or function can be used to combined two or more cell value ? Concatnate & flash fill Flash fill Concat22. Create a link to a webpage, picture, email address, or any program Both A and B Hyperlink Bookmark Cross reference23. In the formula, which symbol specifies the fixed columns or rows? : % $ *24. MS Excel has row limit of __________ 16,484 16,348 16,584 16,384 25. Microsoft Excel has column limit of __________ 1,048,577 1,048,576 1,047,576 16,384 26. 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 bar27. How can you show or hide the gridlines in Excel Worksheet? View——-> Gridlines None of them Data——-> Gridlines Home——-> Gridlines28. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Cell Merge & center Unmerge Cell Merge across29. Which of the following is invalid statement? Sheet tab can be renamed Picture can be applied as a background of a sheet Sheet tabs can not be colored You can set the column width automatically fit the amount of text30. Which option is used to display all the content of cell in multiple lines Merge and center Wrap tex Merge cell Wrap text31. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home32. MS Excel file can NOT be directly exported as ______ CSV PDF TXT PPT 33. 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 cell34. Which shortcut is used to insert new worksheet Shift + F11 F11 Ctrl + F11 F12 Loading …Question 1 of 34