1 / 16

Spreadsheet 5

Spreadsheet 5. Function. Objectives. Use functions like Sum and Average Use a shortcut to compute the total for columns and rows. 3.1 Introduction. Spreadsheet allows you to enter formulae to perform calculations efficiently

george
Download Presentation

Spreadsheet 5

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheet 5 Function

  2. Objectives • Use functions like Sum and Average • Use a shortcut to compute the total for columns and rows

  3. 3.1 Introduction • Spreadsheet allows you to enter formulae to perform calculations efficiently • A ‘function’ is a built-in formula that comes with a spreadsheet program • It is used in place of a long formula

  4. 3.1 Introduction

  5. 3.1 Introduction • The Sum function • In cell B10, instead of using the long formula “=B3+B4+B5+B6+B7+B8+B9” to add up cells B3 to B9, a function “=SUM(B3:B9)” is used The range B3:B9 indicates the cells to be summed up

  6. 3.1 Introduction • The Average function • In cell B8, instead of using the formula “=(B4+B5+B6)/3” to average up cells B4 to B6, a function “=AVERAGE(B4:B6)” is used

  7. 3.1 Introduction • The Maximum and Minimum function • The Maximum function returns the maximum value from a range of cells specified • The maximum value in cells B4 to B10 is 60 and the Maximum function will find it

  8. 3.1 Introduction • The Maximum and Minimum function (Cont’d) • The Minimum function returns the minimum value from a range of cells specified • The minimum value in cells B4 to B10 is 29 and the Minimum function will return this value

  9. 3.1 Introduction

  10. 3.2 Copying Cell Contents • You can copy cells by click-and-drag

  11. 3.2 Copying Cell Contents • To copy using click-and-drag • Move the cursor pointer to the bottom-right corner of the cell to be copied • When the mouse pointer changes to a plus sign, right click and drag to select the range that you want to copy to • Release the mouse button at the end • The cell content will be copied to the selected range

  12. 3.2 Copying Cell Contents • = SUM(B1:B3) or = B1 + B2 + B3 • = SUM(C1:C3) or = C1 + C2 + C3

  13. Summary • A function is a built-in formula that comes with a spreadsheet program. It is used in place of long formulae. • The Sum function is used to find the total of the values in a range. • The Average function is used to find the average of the values in a range.

  14. Summary • We can use the click and drag method to copy cell contents.

  15. (A) =C4+C5+C6+C7+C8 90 (c) 90 THE SAME Sec 1 Worksheet 6 Page 15-17

  16. Sec 3 Term 4 Week 1 SST2 Act 1- Formula and function page 114-115 [3T2] SST2 Act 2- Formula and function [Sum] SST2 Act 3- Formatting, Formula and function [bonus] SST2 Act 4- Formula and Functions [Ave, Min, Max] SST2 Act 5- Formula and Functions [Ave, Min, Max] SST2 Act 6- Formatting

More Related