This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1โ Section header โ
1.1Make the following changes to the cover page:
1.1.1Insert the text 'Street' into the 'Title' content control. (1\
1.1.2Change the font size of the 'A' to 200 pt. (1\
1.1.3Display ONLY the inside borders of the table in a red colour. (2\
1.1.4Align the picture in the bottom left cell of the table so that it appears in the centre of the cell. (1\
1.2The entry 'http://www.widewalls.ch/defining street art/' should NOT appear in the table of contents on the second page. Make the necessary changes so that the entry
1.3Change the bottom page margin to 2 cm from the bottom , from page 3 onwards (2\
1.4Find the paragraph that begins with 'What exactly is from here?' on the third page.
1.4.1Change the line spacing of the paragraph to 20 pt at least. (2\
1.4.2Change the indentation to appear as follows What exactly is the question we are facing here? How would it be possible to define street art? It could be argued that it is a question for art historians or cultural theorists. However, the first group of
1.5The decades are referred to as 1970's, 1980's, etc. Use a word processing feature to remove the apostrophe between the decades and the 's', e.g. 1970s. HINT: Use 0 and not the full year. (3\
1.6Highlight the text that the bookmark 'Graffiti' refers to in any colour of your choice. (1\ 1. Find the picture after the heading
1.8Change the numbered list after the heading 'Defining Street Art Does (not\ Have a Conclusion' to a bulleted list Use the symbol '
1.9Insert an automatic table of figures after the text 'Table of Figures' on the last page to display only the 'Figure' images. (2\
1.10Remove the source 'Banksy, J.R. Just Google it' from the sources
1.11Insert an automatic bibliography on the last page. (1\
1.12Insert page numbers in the page footer as follows: se ny 'Mosaic' page numbering style. Align the odd page numbers to the left of the footer.
Q2โ Section header โ
2.1Correct the spelling error in the document. (1\
2.2Change the form control next to the text 'Date' on the first page to accept the current date in the format dd MMMM yyyy.
2.3Find the text that starts with '1. Set an others who need it.'. Format this text to appear in four columns
2.4Add an endnote to the text 'Utopia' as follows: se capital Roman numerals for
2.5.1Apply any table style other than the 'Table Grid' style to the table
2.5.2Replace the symbol in the second row of the seco nd column with a suitable form field. (2\
2.5.3Add help text to the textbox form field in the second row of the third column of the table so that when F1 is pressed
2.5.4Replace the text 'Insert calculation' in the last row of the table with formula to calculate the total amount of the donations. (2\ Save the 2Donations
Q3โ Section header โ
3.1Merge cells A1:M and centre the data vertically (2\
3.2Fill the cells A1:M with any blue pattern of your choice.
3.3Continue the numbering pattern given in cells A3:A6 o allocate a number to EVERY participant (1\
3.4Insert a formula in cell D to display only the participants initials from column B
3.5Insert a formula in cell to allocate a unique code to each participant as
3.6Use a function in cell G to determine the full name of the province for the code in cell
3.7Insert a function in cell M to calculate the average score for the three rounds in cells
3.8The winner of the competition will be announced 31 days after the closing date, e.g. the closing date is 30/07/2019
3.9Use the SUBTOTAL feature to display the maximum total marks for each category. (3\ Save and close the 3Comp spreadsheet. [30
Q4โ Section header โ
4.1Change the tab colour of the Chart _Gra fiek worksheet to yellow
4.2Swop the order of the two worksheets so that the Provinces_Provinsies worksheet appears first. (1\ Work in the Provinces_Provinsies worksheet.
4.3Insert a function in cell M to determine the number of entr ies from Limpopo LP
4.4Sort only the data in cell L3 in
4.5Use a spreadsheet feature to apply any shading to all the cells that contain dates that appear more than once in column E (2\
4.6Use a formula in column J to display the surname of the overall winner who achieved the highest total points column Copy the formula down to the other cells in
4.7Change the chart /graph to display similar to the one shown below NOTE: Change the chart/graph to a bar chart /graph
5.3Open qry5_3 query in Design iew.
5.4Open qry5_4 query in Design V iew and change the query to display the
5.5Open qry5_5 query in Design V iew
5.6Open rpt 5_6 report in Design V iew and do the following:
Q6โ Section header โ
6.1Display the text 'Famous Street Art' as the title in the browser tab (1\
6.2Set the cell padding of the entire table to 8. (2\
6.3Align the picture 6_Art to the right of the page. (1\
6.4Display the heading 'Street Art' in alibri font
6.5Change the width of the 6_5.jpg picture to 195 and the height to 145. (2\
6.6Correct the HTML code found below the comment <! --
6.6-- so that the table includes a row containing the image 6_3 jpg and the text ' 3. Glasses in
6.7Apply bullets to the data in the seventh row of the table.
6.8Insert a hyperlink on the text 'Read More' to link to the website Google.com. Save and close the 6Famous web page [20]20
Q7โ Section header โ
7.1Open the 7Logo document. Use the images provided in the document to create a logo to appear similar to the one below. Save and close the 7Logo
7.2Open the 7Globe word processing document.
7.2.1Insert a text wat ermark with the text 'Graffiti'.
7.2.2Sort the paragraphs below the heading 'North America' from the text the text in descending order. (2\
7.2.3Insert the text from the 7Europe .html file found in your examination folder at the end of the document. NOTE: The text should be linked to the original document (2\
7.3The 7Art spreadsheet contains information about art exhibitions.
7.3.1An art gallery will only be considered for a prize if their exhibitions occurred on or before the current date AND if the re are more than 100 exhibitors. Insert a function in
7.3.2The province with the highest number of exhibitors will be given a prize. Determine which province will receive the prize. Type your answer in cell A1 NOTE: