Chapter 1: Mastering Excel Basics: Sheets, Formulas, and Navigation December 27, 2024 by Content Welcome to your Chapter 1: Mastering Excel Basics: Sheets, Formulas, and Navigation Name Email Phone 1. How many rows are there in an Excel worksheet? 1,048,576 65,536 104,857 16,384 None 2. Which shortcut allows selection of multiple sheets in Excel? Ctrl + Click Shift + Click Alt + Click Ctrl + Shift + Click None 3. What is the maximum zoom level available in an Excel worksheet? 200% 300% 400% 500% None 4. What is an Excel file called? Workbook Worksheet Sheet Page 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. 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 7. 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 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. How can a new sheet be added in Excel using a shortcut key? Ctrl + N Shift + F11 Alt + Tab Ctrl + Shift + N None 10. Which direction is text aligned by default in Excel? Left Center Right Justify None Time's upTime is Up! 2 thoughts on “Chapter 1: Mastering Excel Basics: Sheets, Formulas, and Navigation” very good teaching style. Thanks. Reply 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 Leave a Comment Cancel replyCommentName Email Website Save my name, email, and website in this browser for the next time I comment.
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