Photo AI

Open the 7New word processing document - NSC Computer Application Technology - Question 7 - 2023 - Paper 1

Question icon

Question 7

Open-the-7New-word-processing-document-NSC Computer Application Technology-Question 7-2023-Paper 1.png

Open the 7New word processing document. 7.1 The shuttle company is upgrading their logo. Use WordArt and the images in the file to create a new logo, as shown below... show full transcript

Worked Solution & Example Answer:Open the 7New word processing document - NSC Computer Application Technology - Question 7 - 2023 - Paper 1

Step 1

7.1 The shuttle company is upgrading their logo. Use WordArt and the images in the file to create a new logo, as shown below.

96%

114 rated

Answer

  1. Open the 7New document in your word processing application.
  2. Insert WordArt and choose a suitable style to create the text 'on time'.
  3. Position the WordArt above the bus image, ensuring it aligns properly within the logo.
  4. Insert the bus image from the provided file and position it below the WordArt.
  5. Group both the WordArt and the bus image to ensure they move together as one object.
  6. Save the final logo as a single image named 7NewLogo.

Step 2

7.2.1 Insert a function in cell D8 to calculate the time a driver should be notified.

99%

104 rated

Answer

  1. Click on cell D8 in the 7Bookings spreadsheet.
  2. Enter the formula: =C8-TIME(1,30,0) to subtract 1 hour and 30 minutes from the departure time in cell C8.

Step 3

7.2.2 Insert a formula in column G to calculate the number of days between the departure and return dates for all clients.

96%

101 rated

Answer

  1. In cell G4, enter the formula: =F4-E4 to calculate the difference between the return date (F4) and departure date (E4).
  2. Drag the fill handle down to apply this formula to other cells in column G.

Step 4

7.2.3 Edit the worksheet as follows:

98%

120 rated

Answer

  1. Go to page layout settings and adjust the print area to ensure that all data in columns A to G are visible on the first printed page.
  2. Edit the print options to include row and column headings, ensuring clarity when printed.

Join the NSC students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;