Microsoft Excel Practical Exam – Arithmetic Operations & IF

Grade 8

📋 General Instructions

  • ✓ Complete all questions using Microsoft Excel.
  • ✓ Use formulas, do not calculate manually.
  • ✓ Format tables and numbers neatly.
  • ✓ Save the file as: ExcelExam_StudentName.xlsx
1

Simple Arithmetic Operations – Store Invoice

Create a store invoice table with the following columns:

  • Item Name (at least 5 items)
  • Quantity
  • Unit Price
  • Subtotal
  • Discount 10%
  • Total Price

📝 Instructions - Use ALL arithmetic operations:

  • • Subtotal = Quantity × Unit Price (MULTIPLICATION)
  • • Discount 10% = Subtotal × 10% (MULTIPLICATION with percentage)
  • • Total Price = Subtotal − Discount (SUBTRACTION)
  • • Add GRAND TOTAL at the bottom using SUM function (ADDITION of all)
  • • Add AVERAGE PRICE using AVERAGE function (DIVISION)

💡 Example Table:

Item Name Qty Unit Price Subtotal Disc 10% Total Price
GRAND TOTAL:
AVERAGE PRICE:
2

Student Grade Report with Statistics

Create a grade table for at least 6 students with 4 subjects:

  • Student Name (min. 6 students)
  • Mathematics
  • Science
  • Indonesian Language
  • English Language
  • Total Score
  • Average
  • Highest Score
  • Lowest Score

📝 Instructions:

  • • Total Score = Use SUM function to add all 4 subjects
  • • Average = Use AVERAGE function from 4 subjects
  • • Highest Score = Use MAX function to find highest from 4 subjects
  • • Lowest Score = Use MIN function to find lowest from 4 subjects
  • • Use at least 6 students

💡 Example Table:

Name Math Sci Indo Eng Total Avg Max Min
3

Nested IF Function – Grade Classification

Create a grade classification table with the following columns:

  • Student Name (min. 6 students)
  • Final Grade (0-100)
  • Grade (A / B / C / D / E)
  • Status (PASS / FAIL)

📝 Instructions - Use NESTED IF function:

1️⃣ Grade Column - Use nested IF:

  • • Score ≥ 85 = "A"
  • • Score ≥ 75 = "B"
  • • Score ≥ 65 = "C"
  • • Score ≥ 55 = "D"
  • • Score < 55 = "E"

2️⃣ Status Column - Use simple IF:

  • • Score ≥ 65 = "PASS"
  • • Score < 65 = "FAIL"

💡 Example Table:

Student Name Final Grade Grade Status

Submit Your Work

Click the button below to upload your Excel file

📤 Submit Excel File

Microsoft Excel Practical Exam Assignment – Grade 8

Good luck! 💪