Scribd
Upload
23 views2 pages

Excel Final Task Instructions

The document outlines final tasks for Class VIII students at MSB Educational Institute related to MS Excel, including formulas for SUM, AVERAGE, COUNT, MIN, and MAX. It also details formatting instructions for borders, cell colors, and text formatting, as well as conditional formatting for highlighting cars in stock, expensive cars, and top speeds. The goal is to create a well-organized and visually appealing data table.

Uploaded by

mustafa.akberali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
23 views2 pages

Excel Final Task Instructions

The document outlines final tasks for Class VIII students at MSB Educational Institute related to MS Excel, including formulas for SUM, AVERAGE, COUNT, MIN, and MAX. It also details formatting instructions for borders, cell colors, and text formatting, as well as conditional formatting for highlighting cars in stock, expensive cars, and top speeds. The goal is to create a well-organized and visually appealing data table.

Uploaded by

mustafa.akberali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MSB Educational Institute – Haidery

CLASS VIII – MS Excel


FINAL TASK:
Formulas to Apply:

1. SUM:
o To calculate the total price:
Formula: =SUM(C2:C6)
2. AVERAGE:
o To calculate the average horsepower:
Formula: =AVERAGE(D2:D6)
3. COUNT:
o To count how many cars are in stock:
Formula: =COUNTIF(H2:H6, "Yes")
4. MIN:
o To find the minimum price:
Formula: =MIN(C2:C6).
5. MAX:
o To find the maximum top speed:
Formula: =MAX(E2:E6)

Formatting:

1. Borders:
o Select the entire data range (e.g., A1:H6).
o Apply borders: Click on the "Borders" option and choose "All Borders" to make the table neat.
2. Cell Color:
o Color the header row (Row 1) to a light blue or green (for example, fill color #A9C7E9).
o Alternate row colors for better readability (e.g., Row 2, 4, etc., in a light gray like #F1F1F1).
3. Text Formatting:
o Bold the header row text and center-align all the text for clarity.
o Highlight the total values (e.g., total price, average horsepower) using a background color (e.g.,
light yellow #FFF2CC) to make them stand out.

Conditional Formatting:

You can add some conditional formatting to make the data more interactive.

1. Highlight Cars in Stock:


o Select the "Availability" column (H2:H6).
o Go to Home > Conditional Formatting > New Rule > Format cells that contain.
o Choose "Cell Value" "equal to" and type "Yes".
o Set the format to green fill with white text.
2. Highlight Expensive Cars:
o Select the "Price" column (C2:C6).
o Go to Home > Conditional Formatting > New Rule > Format cells that contain.
o Choose "Cell Value" "greater than" and type 70000.
o Set the format to red fill with white text to highlight expensive cars.
3. Top Speed Highlight:
o Select the "Top Speed" column (E2:E6).
o Go to Home > Conditional Formatting > New Rule > Format cells that contain.
o Choose "Cell Value" "greater than" and type 250.
o Set the format to blue fill with white text.

EXPECTED OUTPUT:

You might also like