Scribd
Upload
24 views2 pages

Using SUM Function in Spreadsheets

The report explains how to use spreadsheet functions, specifically the SUM function, in applications like Google Sheets and Microsoft Excel. It details the process of entering numerical data in a column and applying the SUM formula to calculate the total. This method allows for quick and accurate calculations and can be scaled for larger datasets.

Uploaded by

Cicz206018 Ziad
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
24 views2 pages

Using SUM Function in Spreadsheets

The report explains how to use spreadsheet functions, specifically the SUM function, in applications like Google Sheets and Microsoft Excel. It details the process of entering numerical data in a column and applying the SUM formula to calculate the total. This method allows for quick and accurate calculations and can be scaled for larger datasets.

Uploaded by

Cicz206018 Ziad
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

Spreadsheet Functions

Presented By : Ziad Mahmoud


202006018
Presented To : DR Mohamed Khalaf
Spreadsheet Functions

Short Report
Spreadsheets like Google Sheets and Microsoft Excel allow users to perform quick and accurate calculations
using built-in functions. This report explains how to create a dataset and apply the SUM function to calculate the
total.
Process Explanation
Open the Spreadsheet: Start by launching Google Sheets or Excel.
Enter Data: Input 10 numerical values in column A (A1 to A10).
Apply SUM Function:
Click on an empty cell (A11).
Type the formula: =SUM(A1:A10)
Press Enter to get the total sum.
Verify the Result: The total of all numbers appears in A11.
Creating and Summing a Dataset in a Spreadsheet
Using a spreadsheet application like Microsoft Excel or Google Sheets, I created a dataset consisting of 10
numerical values. Each value was placed in a separate row within column A. To calculate the total sum, I used the
built-in SUM function by selecting an empty cell and entering the formula =SUM(A1:A10). This function
automatically summed the values, providing the total. This method is useful for quick calculations and can be
extended to larger datasets efficiently.

You might also like