Photo AI

Open the 4Sales spreadsheet which contains information on cars bought in September 2023 at Sam's Dealership - NSC Computer Application Technology - Question 4 - 2023 - Paper 1

Question icon

Question 4

Open-the-4Sales-spreadsheet-which-contains-information-on-cars-bought-in-September-2023-at-Sam's-Dealership-NSC Computer Application Technology-Question 4-2023-Paper 1.png

Open the 4Sales spreadsheet which contains information on cars bought in September 2023 at Sam's Dealership. Work in the Sales worksheet. 4.1 Change the format in ... show full transcript

Worked Solution & Example Answer:Open the 4Sales spreadsheet which contains information on cars bought in September 2023 at Sam's Dealership - NSC Computer Application Technology - Question 4 - 2023 - Paper 1

Step 1

Change the format in column H to an appropriate data type and make sure that all the information in the column is visible.

96%

114 rated

Answer

To change the format in column H:

  1. Select column H.
  2. Right-click and choose 'Format Cells.'
  3. Select 'Currency' or 'Accounting' format to ensure monetary values are displayed correctly.
  4. Adjust the column width as necessary to ensure all data is visible.

Step 2

Correct the formula in cell C3 to display the correct result.

99%

104 rated

Answer

The correct formula for cell C3 can be written as:

=SUM(E9:E50)*0.08

This formula calculates 8% of the total values in the price column (E).

Step 3

Insert a function in cell C5 to calculate the total price (column E) for all the Hyundai i-models.

96%

101 rated

Answer

The formula to calculate the total price for all Hyundai i-models in cell C5 is:

=SUMIFS(E9:E50, C9:C50, "Hyundai", D9:D50, "i*")

This uses SUMIFS to sum prices filtered by make and model.

Step 4

Modify the function in cell A11 to only display the initials of the customer.

98%

120 rated

Answer

To display only the initials in cell A11, use the following formula:

=MID(B11, 1, 1) & "." & MID(B11, FIND(" ", B11) + 1, 1) & "."

This formula extracts the first letter of the first name and the first letter of the last name.

Step 5

Insert a formula/function in cell H10 to calculate the final total cost for Basson.

97%

117 rated

Answer

The formula to calculate the final total cost in cell H10 should be:

=IF(G10="Yes", SUM(E10:F10) * 1.05, SUM(E10:F10))

This checks if extras are added and adjusts the total accordingly.

Step 6

Modify the chart to appear as the example below.

97%

121 rated

Answer

To modify the chart:

  1. Select the data for the chart.
  2. Go to the 'Insert' tab and select 'Column Chart.'
  3. Ensure the format is set to display values in thousands.
  4. Edit the chart title to 'Total price.'
  5. Adjust the color of the bars as shown in the example.

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

;