Quiz › Print, Share & Protect › Print and protect

Print and protect: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

Your sheet prints on 2 pages, with one column alone on page 2. Which print setting fixes it?
- A. Fit All Columns on One Page
- B. Wrap Text
- C. Freeze Panes
- D. Merge Cells
Show the answer
A — Fit All Columns on One Page. Ctrl + P → Scaling → Fit All Columns on One Page.
A 5-page print shows the header row only on page 1. Which setting repeats it on every page?
- A. Wrap Text
- B. Page Break
- C. Freeze Panes
- D. Print Titles
Show the answer
D — Print Titles. Page Layout → Print Titles → Rows to repeat at top.
You select A1:D20 and choose Set Print Area. What prints?
- A. Nothing
- B. Only A1:D20
- C. The whole sheet
- D. Only column A
Show the answer
B — Only A1:D20. Set Print Area tells Excel to print only that range.
Your table is 15 columns wide. Which page direction fits more columns?
- A. Portrait
- B. Landscape
Show the answer
B — Landscape. Landscape turns the page sideways, so more columns fit.
You protect a sheet and leave every cell locked. Someone types in a cell. What happens?
- A. The text is saved
- B. Excel blocks it
- C. The cell is deleted
- D. The file closes
Show the answer
B — Excel blocks it. Excel shows a message and does not allow the change.