Chapter 1: Mastering Excel Basics: Sheets, Formulas, and Navigation December 27, 2024 by Satish Dhawale Welcome to your Chapter 1: Mastering Excel Basics: Sheets, Formulas, and Navigation Name Email Phone 1. What is an Excel file called? Workbook Worksheet Sheet Page None 2. What is the use of the Name Box in Excel? Displays cell value Displays cell location Allows defining a range name Both B and C None 3. Which shortcut allows selection of multiple sheets in Excel? Ctrl + Click Shift + Click Alt + Click Ctrl + Shift + Click None 4. What is the maximum zoom level available in an Excel worksheet? 200% 300% 400% 500% None 5. Which key combination is used to navigate between sheets in Excel? Ctrl + Tab Ctrl + Page Up/Page Down Alt + Shift Ctrl + Enter None 6. How can a new sheet be added in Excel using a shortcut key? Ctrl + N Shift + F11 Alt + Tab Ctrl + Shift + N None 7. When a sheet is added using Shift + F11, where is it added? Right of the active sheet Left of the active sheet At the end of all sheets At the beginning None 8. What does the Formula Bar show when a formula is applied in a cell? The cell value The formula used The cell location The text formatting None 9. Which direction is text aligned by default in Excel? Left Center Right Justify None 10. How many rows are there in an Excel worksheet? 1,048,576 65,536 104,857 16,384 None Time's upTime is Up! Post Views: 4,123
Thank you so much for this masterclass and Material and practice files . I really like this course and it is very useful for my job. Thank you satish sir Reply
very good teaching style. Thanks.
Thank you so much for this masterclass and Material and practice files . I really like this course and it is very useful for my job. Thank you satish sir