Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 - use the ROUNDUP function for two decimal places

This video tutorial covers practical exercises on rounding and using the aggregate function in spreadsheets. It begins with calculating totals including tax and rounding them to two decimal places. The next section focuses on specialized rounding for employee salaries, rounding them to the nearest $100. The final section demonstrates using the aggregate function to calculate totals and averages while ignoring errors and hidden rows.

What is the first step to calculate the total including tax in column D?

How do you ensure that the totals are rounded up to two decimal places?

What function is used to calculate the new salary for each employee?

Explain how to use specialized rounding to round the new salary to the nearest $100.

What is the purpose of the aggregate function in this exercise?

How do you ignore errors and hidden rows when calculating totals and averages?

What formatting changes are suggested for the final results of the calculations?