Microsoft Excel Set – 3 Leave a Comment / By Anil / May 29, 2023 Welcome to your Microsoft Excel Set - 3 1. MS Excel stands for Micromax Excel Management Excel Microsoft Excel Microsoft Excess 2. Microsoft Excel 2019 has column limit of __________ 13684 16384 18634 84163 3. MS Excel 2019 has row limit of __________ 1,048,576 4,81,0576 16384 1,57,648 4. 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 5. 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 6. Multiple calculations can be made in a single formula using Standard formulas Array formula Complex formulas Smart formula 7. How many characters can be typed in a single cell in Excel? 1024 32000 256 65535 8. 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 9. ________is the best alternative to MS Excel offered by Google Inc. Google Slides Google Sheets Google Files Google Keep 10. Excel files have a default extension of Wk1 Xls 123 Xlw 11. 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 12. MS Excel is a ________. Database Management software Presentation software Workbook software Spreadsheet software 13. __________ 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 14. 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 15. MS Excel 2019 has maximum column width limit is of __________characters 256 512 255 128 16. Which of the following is the oldest spreadsheet package? VisiCalc Lotus 1-2-3 Excel StarCalc 17. Free online version of MS excel is known as ________ Office for the web Excel Mobile Word Mobile Excel for the web 18. A file that contains one or more worksheets to organize data is known as ____ Workbook Excelbook Datasheet Spreadsheet 19. 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 20. MS Excel 2019 has maximum column width limit is of __________characters 1985 1991 1995 1998 21. 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 22. 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 23. 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 24. MS Excel file can NOT be directly exported as ______ PDF TXT PPT CSV 25. Formulas in Excel start with ________ / f – = Related Posts (You May Also Read):
