Excel Tutorial
Excel tutorials, quizzes & AI guides — all levels
RSS
  • Online Excel Exercises
  • Training
  • Excel Tests
  • Sitemap
  • Premium Quizzes
  • Shop
  • My account

Beginner Excel Exercise: Mastering Basic Calculations

This beginner Excel exercise focuses on fundamental calculations, guiding you through essential steps such as:

  • Enter numbers into cells: Learn the fundamental step of accurately inputting data.
  • Perform calculations with numbers: Practice basic arithmetic operations to understand how Excel processes data.
  • Use cell references in calculations: Discover how to create dynamic and efficient formulas using cell references.
  • Apply Excel’s built-in functions like the SUM function

By the end of this exercise, you’ll gain a solid foundation that will serve as a valuable starting point in your Excel journey.

Presentation Exercise

Click the button below to start the Excel beginner exercise and practice basic calculations.

SUM and AVERAGE Exercise - Calculate a ticket office's revenue over 5 days

Calculate a week of ticket revenue from full-price and half-price customers: unit totals with absolute references, row totals, then SUM and AVERAGE — 10 guided steps.

The full-price reference must be locked.

1 / 10

Write in D2 the formula to calculate the full-price amount.

Revenue — Q1 · 474

=B2*$C$11

The $C$11 rate stays locked, the B2 reference shifts down.

2 / 10

Fill the formula down from D2 to D6 using the fill handle.

Revenue — Q2 · 475

=B6*$C$11

The half-price ticket rate must be locked.

3 / 10

Write in E2 the formula to calculate the half-price amount for Monday.

Revenue — Q3 · 476

=C2*$C$12

Same as column D: $C$12 stays locked, C2 shifts.

4 / 10

Fill the formula down from E2 to E6 using the fill handle. What formula do you get in E6?

Revenue — Q4 · 477

=C6*$C$12

Add up Monday's full-price and half-price totals.

5 / 10

Write in F2 the formula to calculate Monday's total revenue (full price + half price).

Revenue — Q5 · 478

=D2+E2

Both references (D2 and E2) shift down together.

6 / 10

Fill the formula down from F2 to F6 using the fill handle.

Revenue — Q6 · 479

=D6+E6

Use the SUM function to make this easier.

7 / 10

Write in B7 the formula to calculate the total number of full-price customers.

Revenue — Q7 · 480

=SUM(B2:B6)

Fill to the right using the fill handle.

8 / 10

Fill the formula from B7 across to F7.

Revenue — Q8 · 481

=SUM(F2:F6)

Use the AVERAGE function on the range B2:B6.

9 / 10

In B8, calculate the average number of full-price customers over the week.

Revenue — Q9 · 482

=AVERAGE(B2:B6)

Use the fill handle to fill the formula to the right.

10 / 10

Fill the formula across to cell F8.

Revenue — Q10 · 483

=AVERAGE(F2:F6)

Your score is

0%

The other courses in this module

  1. Learn how to use the SUM function in Excel
  2. Beginner Excel Exercise: Mastering Basic Calculations
  3. Learn how to use the Dollars in an Excel formula
  4. Exercise: Calculate the income of the week
  5. Exercise to learn how to use the Dollar Sign in Excel

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you’re a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You’ll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!

Most Viewed Posts

  • Displaying Negative Numbers in Parentheses in Excel (310,065)
  • Top 10 Excel Functions You Must Know (232,001)
  • How to make automatic calendar in Excel (212,775)
  • Dash for a zero in Excel automatically (190,812)
  • Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel (171,033)
  • Date Format in Excel (154,872)
  • Use Excel Online for Free (135,368)
  • Excel Split Date and Time (133,843)
  • How to calculate VAT in Excel? (127,133)
  • Exchange rate in Excel 🏛️ (124,419)
  • Add Emojis to your Excel charts or slicers (117,213)
  • Why Excel Formulas Use Comma or Semi-Colon (102,149)
  • Master XLOOKUP function in Excel (101,857)
  • UNIQUE Function – Remove duplicates with formulas (98,081)
  • Change the default Date format in Excel (94,903)

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net