Transcription of Formulas and Functions with Excel - CDTL
{{id}} {{{paragraph}}}
Example: quiz answers
Formulas and Functions with Excel - CDTL
Centre for Development of Teaching and Learning (CDTL) National University of Singapore email: Formulas and Functions with Excel Kiruthika Ragupathi Assistant Director (Educational Technology) TABLE OF CONTENTS Introduction .. 4 Exploring the Excel Workspace .. 4 Navigating the Workbook .. 4 Setting up Data .. 6 Inserting a new column or row .. 6 Formatting the worksheet .. 6 Verifying Data .. 8 Formulas and Functions .. 8 Constructing a formula .. 8 Inserting a function .. 10 Built-in Functions .. 12 Mathematical Calculations .. 14 Conditional Calculations .. 17 Cutting up & Piecing together Text Strings using Text Functions .. 18 Using Look up tables / References .. 18 Pivot Tables .. 20 Create a PivotTable from worksheet data .. 21 Statistical Functions .. 22 Basic Statistical built-in Functions .. 22 Linear regression Functions .
To use a spreadsheet efficiently, it helps to organie the data so thats it is easy to read. When grading, columns are typically used for each assessment item, whereas rows are used for the individuals.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: