M9 Lab_Manual_Excel_Basics_V3

Lab Manual

Excel Basics

Module 9

Objectives of this Lab Manual This lab manual is designed to - Exercises for hands on practice Guidelines to complete the exercise Learning Outcome

Exercise What will you do? Calculate the sum of the given data using the relevant function: Expenses 100 150 200 250 300

Guidelines What will be the steps to get the output? • Select the Column from the worksheet that sums the user wants to calculate. Click on Home and then select autosum. By default, it selects as SUM • Another method is to type =SUM and select range i.e.(A2:A6) and click on enter

Learning Outcome You will be able to find the total of the data in a selected range, using the SUM function.

Thank You!