Printing Excel Sheets and Setting Print Area MCQs

1. Which option in Excel is used to specify the exact range of cells to be printed?
(A) Page Layout → Print Titles
(B) File → Print Selection
(C) Page Layout → Set Print Area
(D) View → Page Break Preview

2. What is the shortcut key to open the Print dialog box in Excel?
(A) Ctrl + P
(B) Ctrl + Shift + P
(C) Alt + P
(D) Ctrl + F2

3. If a worksheet is too wide to fit on one page, which option can be used to shrink it while printing?
(A) Page Breaks
(B) Scale to Fit
(C) Print Area
(D) Print Titles

4. Which Excel view shows how the worksheet will look when printed, including page breaks?
(A) Normal View
(B) Page Layout View
(C) Custom View
(D) Page Break Preview

5. To repeat column headings on every printed page, which option is used?
(A) Print Titles
(B) Set Print Area
(C) Scale to Fit
(D) Page Break Preview

6. What happens if you clear the print area in Excel?
(A) The selected cells are deleted
(B) The worksheet cannot be printed
(C) The entire worksheet becomes printable again
(D) Only one page is printed

7. Which option allows you to insert page breaks manually in Excel?
(A) Insert → Page Break
(B) Page Layout → Breaks
(C) View → Page Layout
(D) Review → Protect Sheet