Section 1: View Tab (Questions 1-60)
1. Workbook Views (Normal, Page Layout, Page Break Preview, Custom Views)
1. Which view in Excel shows how the worksheet will look when printed?
a) Normal View
b) Page Layout View
c) Page Break Preview
d) Custom View
Answer: b) Page Layout View
2. What does "Page Break Preview" allow you to do?
a) Adjust where pages break when printing
b) Change font styles
c) Insert formulas
d) Hide rows and columns
Answer: a) Adjust where pages break when printing
3. How do you access "Custom Views" in Excel?
a) Home Tab → Views
b) View Tab → Workbook Views → Custom Views
c) Insert Tab → Custom Views
d) Data Tab → Views
Answer: b) View Tab → Workbook Views → Custom Views
4. Which view is the default view in Excel?
a) Page Layout
b) Normal
c) Page Break Preview
d) Full Screen
Answer: b) Normal
5. What is the purpose of "Full Screen" view?
a) Maximizes the worksheet without ribbons and toolbars
b) Shows gridlines
c) Displays page margins
d) Enables formula auditing
Answer: a) Maximizes the worksheet without ribbons and toolbars
2. Show/Hide (Gridlines, Formula Bar, Headings, Ruler, etc.)
6. Where can you toggle the visibility of the Formula Bar?
a) Home Tab → Show/Hide
b) View Tab → Show → Formula Bar
c) Insert Tab → Formula Bar
d) Data Tab → Formula Options
Answer: b) View Tab → Show → Formula Bar
7. How do you hide gridlines in Excel?
a) View Tab → Show → Uncheck Gridlines
b) Home Tab → Format → Hide Gridlines
c) Page Layout Tab → Gridlines → View
d) Data Tab → Gridline Options
Answer: a) View Tab → Show → Uncheck Gridlines
8. What happens if you uncheck "Headings" in the View Tab?
a) Row numbers and column letters disappear
b) Worksheet data is hidden
c) Only formulas are displayed
d) The sheet zooms out
Answer: a) Row numbers and column letters disappear
9. Which option allows you to see the ruler in Excel?
a) View Tab → Show → Ruler
b) Page Layout Tab → Ruler
c) Insert Tab → Ruler
d) Home Tab → Ruler
Answer: a) View Tab → Show → Ruler
10. How can you display page breaks permanently?
a) View Tab → Page Break Preview
b) Page Layout Tab → Breaks → Show Page Breaks
c) Data Tab → Page Breaks
d) Home Tab → Breaks
Answer: a) View Tab → Page Break Preview
3. Zoom (Zoom to Selection, 100%, Custom Zoom, Zoom Slider)
11. What is the shortcut to quickly zoom to 100%?
a) Ctrl + 1
b) Ctrl + Alt + 0
c) Ctrl + Shift + Z
d) Alt + Z
Answer: b) Ctrl + Alt + 0
12. How do you zoom in on a selected range of cells?
a) View Tab → Zoom → Zoom to Selection
b) Home Tab → Zoom Selection
c) Data Tab → Zoom In
d) Insert Tab → Zoom
Answer: a) View Tab → Zoom → Zoom to Selection
13. Where is the Zoom Slider located in Excel?
a) Top Ribbon
b) Status Bar (Bottom Right)
c) Formula Bar
d) Quick Access Toolbar
Answer: b) Status Bar (Bottom Right)
14. What is the default zoom percentage in Excel?
a) 75%
b) 100%
c) 120%
d) 90%
Answer: b) 100%
15. How do you set a custom zoom level (e.g., 85%)?
a) View Tab → Zoom → Custom → Enter 85
b) Home Tab → Zoom Options
c) Right-click sheet → Zoom
d) Page Layout Tab → Scale to Fit
Answer: a) View Tab → Zoom → Custom → Enter 85
