Section 14: Data Analysis

Mark Nicholls – ICT Lounge

IGCSE ICT – SECTION 14 DATA ANALYSIS

MICROSOFT EXCEL STEP BY STEP GUIDE

Mark Nicholls ICT Lounge

Section 14: Data Analysis

Mark Nicholls – ICT Lounge

Data Analysis – Self Study Guide
Contents
Learning Outcomes ……………………………………………………………………………………… Page 3 What is a Data Model? ..................................................................................... Page 4 Spreadsheet Basics…………………………………………………………………………………………. Page 4 – 6 Resizing Column Widths…………………………………………………………………………………. Page 6 Autofil…………………………………………………………………………………………………………….. Page 7 Absolute Cell Reference…………………………………………………………………………………… Page 8 Printing Spreadsheet Values………………………………………………………………………….. Page 9 Printing Spreadsheet Formulae……………………………………………………………………….. Page 10 Basis Formulae (Operators)……………………………………………………………………………. Page 11 – 13 Naming Cells and Cell Ranges………………………………………………………………………… Page 14 – 15 Introduction to Functions………………………………………………………………………………… Page 16 SUM Function……………………………………………………………………………………… Page 16 – 17 AVERAGE Function……………………………………………………………………………… Page 18 MAX Function…………………………………………………………………………………….. Page 18 MIN Function……………………………………………………………………………………… Page 19 Alternative to Typing in Functions………………………………………………………………….. Page 19 – 20 Activity 1 ………………………………………………………………………………………………………… Page 20 INT Function ………………………………………………………………………………………. Page 21 – 22 ROUND Function ……………………………………………………………………………….. Page 22 – 23 Activity 2 ………………………………………………………………………………………………………. Page 23 COUNT Function ………………………………………………………………………………… Page 24 COUNTA Function ……………………………………………………………………………… Page 25 Activity 3 ………………………………………………………………………………………………………. Page 26 COUNTIF Function ……………………………………………………………………………… Page 26 – 28 Activity 4 ………………………………………………………………………………………………………. Page 29 SUMIF Function