Microsoft Excel Set – 3 Leave a Comment / By Anil / May 29, 2023 Welcome to your Microsoft Excel Set - 3 1. MS Excel is a ________. Database Management software Presentation software Workbook software Spreadsheet software None 2. When you link data maintained in an excel workbook to a word document The word document cannot be edit The word document contains a reference to the original source application The word document contains a copy of the actual data The word document must contain a hyperlink None 3. How do you select an entire column? Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column None 4. A file that contains one or more worksheets to organize data is known as ____ Workbook Excelbook Datasheet Spreadsheet None 5. How many characters can be typed in a single cell in Excel? 1024 32000 256 65535 None 6. __________ is a free lightweight version of MS Excel available as part of Office on the web. Excel for the web Excel Mobile Office Mobile MS Access for Web None 7. Tab scrolling button Allow you to view a different worksheet Allow you to view additional worksheet rows down Allow you to view additional worksheet columns to the right Allow you to view additional sheets tabs None 8. Which of the following is the oldest spreadsheet package? VisiCalc Lotus 1-2-3 Excel StarCalc None 9. Formulas in Excel start with ________ / f – = None 10. MS Excel 2019 has row limit of __________ 1,048,576 4,81,0576 16384 1,57,648 None 11. The auto calculate feature Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Both A and C None 12. Which of the following will not cut information? Pressing Ctrl + C Selecting Edit > Cut from the menu Clicking the Cut button on the standard Pressing Ctrl+X None 13. How can you find specific information in a list? Select Tools > Finder from the menu Select Insert > Find from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button None 14. Documentation should include Information on the purpose of the workbook Destination and users of the output data Source of input data All of the above None 15. MS Excel stands for Micromax Excel Management Excel Microsoft Excel Microsoft Excess None 16. Microsoft Excel 2019 has column limit of __________ 13684 16384 18634 84163 None 17. MS Excel 2019 has maximum column width limit is of __________characters 1985 1991 1995 1998 None 18. How cells are named in ms excel? using rename option using name box simply double click on sheet name simply double click on cell and name it None 19. Excel files have a default extension of Wk1 Xls 123 Xlw None 20. MS Excel 2019 has maximum column width limit is of __________characters 256 512 255 128 None 21. MS Excel file can NOT be directly exported as ______ PDF TXT PPT CSV None 22. ________is the best alternative to MS Excel offered by Google Inc. Google Slides Google Sheets Google Files Google Keep None 23. Multiple calculations can be made in a single formula using Standard formulas Array formula Complex formulas Smart formula None 24. Free online version of MS excel is known as ________ Office for the web Excel Mobile Word Mobile Excel for the web None 25. It is acceptable to let long text flow into adjacent cells on a worksheet when No data will be entered in the adjacent cells There is no suitable abbreviation of the text Data will be entered in the adjacent cells There is not time to format the next None Share this:TweetEmailTelegramPrintWhatsAppLike this:Like Loading... Related Posts (You May Also Read):
