Theme: Community Computer Club The local Community Computer…
Theme: Community Computer Club The local Community Computer Club has been given permission to use the school’s new Media Centre as a venue for its monthly meetings. Various administrative functions need to be finalised – guest speakers, finances, introductory courses, etc. A web page must also be completed to promote the club. Question 1 – Word processing A letter has been drafted to send to new members. Open the document 1_ClubLetter. 1.1 Locate the graphic on the first page and change it so that it appears as follows: Note: No typing is required. Right-click on this button and select the “Open link in new tab” option (1) 1.2 Locate the comment under the heading ‘Background’ on page 3. Carry out the instructions contained in this comment. (2) 1.3 Locate the citation at the end of the first paragraph under the heading ‘From lowly beginnings’. Change the citation so that it appears as follows: (O’Toole) (2) 1.4 Accept the track changes under the heading ‘New venue, new look’. (1) 1.5 Locate the paragraph under the heading ‘Aims’. Change the paragraph so that it appears more or less as follows: Right-click on this button and select the “Open link in new tab” option (5) 1.6 Locate the table under the heading ‘Programme: July to August’ and do the following: Edit the table so that it appears like the screenshot below. AutoFit the table to its contents. Right-click on this button and select the “Open link in new tab” option (6) 1.7 Locate the text in red under the heading ‘Community courses’. Format the text so that it appears as follows (do not change any colours): Right-click on this button and select the “Open link in new tab” option (2) 1.8 Locate the word ‘colorful’ under the heading ‘Year end function’. Ensure that this word will be indicated as an error, if an English spell check is performed on the document. (1) 1.9 Locate the table under the heading ‘Bring ’n Sell’. Change the spacing between the cells to 0.3 cm. Insert a formula in the bottom right cell, that calculates 20% of the total of the amounts listed above it. Your completed table should appear as follows: Right-click on this button and select the “Open link in new tab” option (3) 1.10 Locate the table under the heading ‘Office Speed Quiz’ and do the following: Ensure that, if the table is ‘split’ over two pages, the column headings will be repeated on the second page. Replace the question marks with the relevant details (Name, Time (sec) and Score) of members who scored 75.0 or more in an Excel Test. The information you will need is stored in the document 1_TestResults. (4) 1.11 Locate the word ‘survey’ under the heading ‘Quarterly newsletter’. This word must be hyperlinked to the text ‘New members’ on the last page of the document. First create a bookmark at the text ‘New members’. Now hyperlink the word ‘survey’ to the text ‘New members’. The following message must appear when a user hovers the mouse over the hyperlinked word: Right-click on this button and select the “Open link in new tab” option (3) 1.12 Locate the multilevel list under the heading ‘Contributions’. Format the list so that it appears as follows: Right-click on this button and select the “Open link in new tab” option (2)