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 primary task in the first part of the exercise related to rounding?

• Calculate the total including tax and round down to two decimal places

• Calculate the total including tax without rounding

• Calculate the total excluding tax

• Calculate the total including tax and round up to two decimal places

What should be done to the formula to ensure totals are rounded up to two decimal places?

• Add a ROUND function

• Add a MROUND function

• Add a FLOOR function

• Add a CEILING function

Which function is used to round the new salary to the nearest $100?

• FLOOR

• CEILING

• MROUND

• ROUND

What is the main focus of the specialized rounding section?

• Rounding to the nearest ten

• Rounding to the nearest hundred

• Rounding to the nearest thousand

• Rounding to the nearest dollar

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

• To calculate the sum of all prices including tax

• To calculate the total and average of all prices including tax, ignoring errors and hidden rows

• To calculate the average of all prices excluding tax

• To calculate the total of all prices excluding tax

Which option should be selected in the aggregate function to ignore errors and hidden rows?

• Option 1

• Option 9

• Option 4

• Option 7

What is the final step after using the aggregate function?

• Apply number formatting

• Correct errors in the data

• Remove hidden rows

• Recalculate the total