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. which option or function can be used to combined two or more cell value ? fill Concat Concatnate & flash fill Flash 2. Is used to arrange data ascending and descending order ? long Filter Sort Format as table3. How many sheets can be added in Excel file ? 253 256 255 2104. Text function is used to capitalize each word Find Proper Upper Lower5. What happens when dollar signs ($) are entered in a cell address? ($A$2:$A$10) The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address6. Open “Microsoft Office Excel Help”. F2 F11 F1 F107. In excel numeric entry are align Right Justify Center Left8. Which key is used for help in MS excel? F4 F3 F2 F19. Which of the following is the correct method of editing the cell content? Press the Alt key Click the formula bar Press the F2 key Double click the cell10. Which language is used to create macros in Excel? Java Visual C++ Visual Basic C11. In excel text entry are align to Center Right Justify Left side12. Microsoft Excel has column limit of __________ 1,047,576 16,384 1,048,576 1,048,577 13. MS Excel file can NOT be directly exported as ______ TXT PPT CSV PDF 14. Opens “Format Cells” dialog box. Ctrl + F1 Ctrl + F2 Ctrl + F3 Ctrl + F415. Which of the following options can be used to delete comment apply on a cell ? Home > clear> clear comment Review > Delete (comment group) Press delete button (keyboard) Both A and B16. MS Excel has row limit of __________ 16,484 16,384 16,584 16,348 17. Create a link to a webpage, picture, email address, or any program Hyperlink Both A and B Bookmark Cross reference18. To remove the content of selected cells you must issue ______ command Delete Clear All Clear Delete Clear Contents19. MS Excel has maximum column width limit is of __________characters 255 256 355 356 20. _____ can be used as a keyboard shortcut key to check spelling in MS Excel. F7 F11 F2 F621. Which shortcut is used to insert new worksheet F11 F12 Shift + F11 Ctrl + F1122. In the formula, which symbol specifies the fixed columns or rows? $ * : %23. Which option is used to display all the content of cell in multiple lines Merge cell Merge and center Wrap text Wrap tex24. The Delete key of keyboard is assigned to which command in Excel? Edit > Delete Edit > Delete Text Edit > Clear > All Edit > Clear > Contents25. When all the numbers between 0 and 200 in a range should be displayed in Red Color, Apply _______ Datavalidation have been used Use =if() function to format the required numbers red Sub total have been used Conditional Formatting command on Format menu26. Which option is used to join the selected cells into single cell and center the content of cell ? Merge & center Unmerge Cell Merge Cell Merge across27. In MS Excel, Workbook can be closed using keyboard shortcut ______ Ctrl + N Ctrl + W Shift + W Alt + W28. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Ctrl + W Shift + N Alt + N Ctrl + N29. 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 Home Press Shift + Home Press Ctrl + Home30. How can you show or hide the gridlines in Excel Worksheet? View——-> Gridlines Home——-> Gridlines Data——-> Gridlines None of them31. Open a new window containing a view of the current windows File > New New > file View > New Window Home > Insert > Insert sheet32. Keep a portion of sheet visible while rest of sheet scrolls Scroll bar Hide column Freeze pane Hide rows33. 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 colored34. ________is the best alternative to MS Excel offered by Google Inc. Google Sheets Google Slides Google Files Google Keep Loading …Question 1 of 34