Theory question 106
Word ProcessingPaper 2, Section B: Test of Practical Work
(a) A document is created in MS Word but the user realizes that parts of the document are cut off when it is print previewed in portrait orientation. Highlight the steps to change the orientation to landscape and print the document on A4 paper.
(b) A teacher working on student's results broadsheet in Microsoft Excel needed to keep the headings in “view” while scrolling through the results. The teacher also needed to compare each student's record with a version of the file earlier submitted to the Head of Department (HOD) to effect all suggestions. (i) Name the concept of keeping the headings visible while scrolling through a worksheet in Microsoft Excel. (ii) Outline the steps to keep the headings fixed while scrolling in Microsoft Excel Worksheet. (iii) Identify two actions to display each student's record at the same time on both versions of the result file. (iv) Highlight the steps to achieve the named actions in 6b(iii).
(c) List two gadgets needed to display the contents of a laptop computer to an audience in an auditorium.
Show the model answer
(a) Click Layout (Page Layout) → Orientation → Landscape; click Size → A4; click File → Print (Ctrl + P), check the preview, choose the printer and click Print.
(b)(i) Freeze Panes.
(ii) Click the cell just below the heading row (e.g. A2); click View → Freeze Panes → Freeze Panes (or Freeze Top Row).
(iii) View Side by Side and Synchronous Scrolling (or New Window and Arrange All).
(iv) Open both versions of the file; click View → View Side by Side (choose the HOD's version); make sure Synchronous Scrolling is on so both scroll together.
(c) Any two: multimedia projector; projector screen/large TV; HDMI or VGA cable; speakers/public address system.
Freeze Panes keeps headings in view; View Side by Side compares two files.