ROUND | CSE 148 – Excel Exam 1

Still feeling nervous for your exam? Check out the Excel Cram Kit (Exam 1) for practice modules that emulate the difficulty that you'll face on your exam. Each module includes a thorough step-by-step explanation where I walk you through the entire problem solving process!

ROUND explained

Simply put, the ROUND function enables us to round numbers. That's it.

So if we had the following number:

I could round it to 2 decimal places using the ROUND function:

The ROUND function allows us to round a given number to a specific decimal place.

Coding a ROUND function

Let's first check out the ROUND function template, and then apply it.

=ROUND(number, num_digits)

In the above situation, we wanted to round 5.6324...

=ROUND(5.6324, num_digits)

...to 2 decimal places.

=ROUND(5.6324, 2)

When we plug this into Excel, we get the same output as we got on the calculator!

It's important to remember...

The num_digits argument doesn't represent the total number of digits, it represents the number of digits after the decimal point!

For example, if we wanted to round to a whole number, all we'd need to do is place a "0" as the second argument, signifying we want 0 digits after the decimal point.

Practice problem

Round the number 17.91635 to 3 decimal places.

=ROUND(B1, B2)

Answer: 17.916

Excel (Exam 1) Follow-along Guide

It's no secret you retain info better when you write it down. That's why I created the Excel (Exam 1) Follow-along Guide for you!

As you come upon key concepts highlighted in yellow, like this sentence here, you can fill-in-the-blanks on your Follow-along Guide so that you remember all the important stuff for later!

You can obtain the Excel (Exam 1) Follow-along Guide for FREE by entering your email below!

Next, let's learn the difference between the WEEKDAY and WORKDAY functions and how we can use them.

Free Resources

Each exam concept broken down in simple, real-world examples!

ToolsExcel (Exam 1) Follow-along Guide
LessonYEAR, MONTH, DAY
LessonSUM & AutoSUM
LessonRelative vs. Absolute Cell References
LessonRANK
LessonCOUNT
LessonROUND
LessonWEEKDAY vs. WORKDAY
LessonVLOOKUP
LessonPMT
LessonIF
LessonPercent change
LessonExcel charts
LessonImporting text files

Practice Problems

Step-by-step walkthrough for each of the questions you need to be ready for!

"I bought this Cram Kit the night before my exam, and it helped me tremendously. It provides step-by-step explanations for all the units covered in class."

Matt Lamanna
Oct. 24, 2021

Rating: 5 out of 5.

Leave a Comment