16. Practice Exercises with Answer Hints
16.13 Module 14: Protection and Printing
- Let users type only in target cells; protect everything else. Hint: unlock input cells (Ctrl + 1 › Protection) › Review › Protect Sheet.
- Stop users from deleting or unhiding sheets. Hint: Review › Protect › Protect Workbook › Structure.
- Print a 15-column sheet on A4 landscape, one page wide, with the header row on every page.
Hint: Scale to Fit Width 1 page; Page Layout › Print Titles ›
$1:$1. - Add "Page X of Y" in the footer.
Hint: Insert › Header & Footer ›
Page &[Page] of &[Pages]. - Export the Dashboard and Summary sheets to one PDF. Hint: select both tabs › File › Export › PDF › Options › Active sheet(s).
- Difference between a note and a threaded comment? Hint: notes = static sticky note; comments = replies, @mentions, resolve.
Ravindra Bagale's Tip
Many students print without looking at the print preview. In Ctrl + P, always check the preview on the right and the page count – it saves both paper and time. And don't mistake Protect Sheet for security.
Ravindra Bagale's Tip – मराठी
बरेच students print preview न बघता print करतात. Ctrl + P मध्ये उजव्या बाजूचा preview आणि page count नेहमी चेक करा – कागद आणि वेळ दोन्हींची बचत. आणि Protect Sheet ला security समजू नका.
Ravindra Bagale's Tip – हिंदी
बहुत से students print preview देखे बिना print कर देते हैं. Ctrl + P में दाईं तरफ़ का preview और page count हमेशा देखो – काग़ज़ और समय दोनों की बचत. और Protect Sheet को security मत समझो.
Worked example — module 14 protection and printing
Why
Vikram Rao in Pune and Liam Murphy abroad both need a clear, repeatable way to use module 14 protection and printing on a NovaCraft Tools sheet without breaking totals.
What
Module 14 Protection And Printing is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for module 14 protection and printing.
- Enter a small made-up value for Vikram Rao using $ where money appears.
- Add a second value for Liam Murphy using € so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once module 14 protection and printing is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of module 14 protection and printing on a blank sheet for Skyline Clinics.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Vikram Rao and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Carlos Rivera.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply module 14 protection and printing to a 5-row made-up Skyline Clinics table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with module 14 protection and printing.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as SkylineClin_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
