Lesson 4 - Introduction to Spreadsheet Programs 4.3 - Performing Mathematical Tasks Performing Mathematical Tasks An important advantage of a spreadsheet is that apart from storing and manipulating data, you can also use it to perform various mathematical tasks on the stored data quickly and accurately. To perform these mathematical tasks, you use functions provided by the spreadsheet program. A function is an operation that is performed on the data in the cells by using calculation tools available in the program. For example, after recording your household expenses in a spreadsheet, you can use the AVERAGE function to calculate the average amount you spent for groceries. You can also create your own formulas to perform mathematical calculations. Using formulas and functions in a spreadsheet helps you to easily modify any data in your calculations. This is because formulas and functions refer to the cell address, not the data in the cells. When you change the data in a cell, the applied formula or the function does not change, and the result of the formula is updated automatically. In this simulated lab, you will perform basic mathematical tasks in an Excel 2007 spreadsheet. Click to launch the lab. Follow the steps to complete the lab.
Describe tbe lession 4?
Performing Mathematical Tasks
* Lesson 4 - INTRODUCTION TO SPREADSHEET PROGRAMS 4.3 -
PERFORMING MATHEMATICAL TASKS 
Log in to save your progress and obtain a certificate in Alison’s free Microsoft Digital Literacy - IT Basics, Internet & Productivity Programs online course
Sign up to save your progress and obtain a certificate in Alison’s free Microsoft Digital Literacy - IT Basics, Internet & Productivity Programs online course
Please enter you email address and we will mail you a link to reset your password.