Scribd
Upload
2 views1 page

Laboratory Activity 01 Basic Excel Functions

The document outlines a lab activity for understanding and applying basic Excel functions including AVERAGE, COUNT, MAX, MEDIAN, MIN, and SUM. It provides step-by-step instructions for using these functions on a sample data set. Additionally, it includes questions and an essay prompt related to the usefulness of these functions in data analysis.

Uploaded by

chrisjohnmarianosk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

Laboratory Activity 01 Basic Excel Functions

The document outlines a lab activity for understanding and applying basic Excel functions including AVERAGE, COUNT, MAX, MEDIAN, MIN, and SUM. It provides step-by-step instructions for using these functions on a sample data set. Additionally, it includes questions and an essay prompt related to the usefulness of these functions in data analysis.

Uploaded by

chrisjohnmarianosk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

IT BA 1 – Fundamentals of Business Analytics

Lab. Activity #1: Using Basic Excel Functions 5. Find the Maximum Value:
o Click on cell B4.
Objective: o Type the
To understand and apply the basic Excel functions: formula =MAX(A2:A10) and press
AVERAGE, COUNT, MAX, MEDIAN, MIN, and Enter.
SUM. o Observe the result in cell B4. This is
the highest value in the range A2.
Materials: 6. Find the Median Value:
• Computer with Microsoft Excel installed. o Click on cell B5.
• Sample data set provided below or another o Type the
numerical data set for practice. formula =MEDIAN(A2:A10) and
press Enter.
Procedure: o Observe the result in cell B5. This is
the median value of the range A2.
1. Open Microsoft Excel and create a new 7. Find the Minimum Value:
workbook. o Click on cell B6.
2. Enter the following data in column A o Type the
(starting from cell A2 to A10): formula =MIN(A2:A10) and press
Enter.
o Observe the result in cell B6. This is
the smallest value in the range A2.
8. Sum the Numbers:
o Click on cell B7.
o Type the
formula =SUM(A2:A10) and press
Enter.
o Observe the result in cell B7. This is
the sum of all the numbers in the
range A2.

3. Calculate the Average: Questions:


o Click on cell B2.
o Type the 1. What is the average value of the data set
formula =AVERAGE(A2:A10) an you entered?
d press Enter. 2. How many numbers are there in the data
o Observe the result in cell B2. This is set?
the average of the values in the 3. What is the maximum value in the data set?
range A2. 4. What is the median value in the data set?
4. Count the Numbers: 5. What is the minimum value in the data set?
o Click on cell B3. 6. What is the sum of all the numbers in the
o Type the data set?
formula =COUNT(A2:A10) and
press Enter. Essay.
o Observe the result in cell B3. This
counts how many numbers are in How are these basic Excel functions can be useful
the range A2. in analyzing numerical data?

Laboratory Activity #1: Basic Excel Functions


Aimee D. Molato, DIT

You might also like