CREATE AND USE SPREADSHEETS

CREATE AND USE SPREADSHEETS

CERTIFICATE II IN BUILDING AND CONSTRUCTION (PATHWAY ? PARAPROFESSIONAL)

BSBITU202A

LEARNER'S GUIDE BUILDING AND CONSTRUCTION

BC1932

Create and use spreadsheets

BSBITU202A

Learner's guide

First published 2012

ISBN 978-1-74205-833-7

? VET (WA) Ministerial Corporation 2012 All the Department of Training and Workforce Development materials, regardless of format, are protected by copyright law.

This work is made available under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported (CC BY-NC-SA) licence (unless otherwise specified). For more information please visit . Under this licence, you may copy, print, communicate and adapt the material for personal or non-commercial purposes, including educational or organisational use, provided you attribute the Department of Training and Workforce Development, Central Institute of Technology and the Building and Construction Industry Training Fund, link to the Creative Commons website named above and license any new work created incorporating material from this resource under a CC BY-NC-SA Licence. Whilst every effort has been made to ensure the accuracy of the information contained in this publication, no guarantee can be given that all errors and omissions have been excluded. No responsibility for loss occasioned to any person acting or refraining from action as a result of the material in this publication can be accepted by the Department of Training and Workforce Development. Produced in partnership with

Published by and available from Department of Training and Workforce Development

1 Prospect Place West Perth WA 6005 Tel: (08) 6212 9700 Fax: (08) 9227 8393 Email: sales@dtwd..au Website: vetinfonet.dtwd..au

This resource contains units of competency from the BSB07 Business Services Training Package ? BSBITU202A Create and use spreadsheets ? Commonwealth of Australia, used under Creative Commons Attribution-No Derivative Works 3.0 Australia licence .au Microsoft, Windows and Excel are trademarks of the Microsoft group of companies. This product contains various images ?Thinkstock 2012, used under licence. These images are protected by copyright law and are not to be reproduced or re-used in other materials without permission from the owner of Thinkstock.

Contents

Welcome..........................................................................................................................7 Qualification overview......................................................................................................8 Unit overview....................................................................................................................8 Resources...................................................................................................................... 11 Selfchecklist..................................................................................................................12 About the icons...............................................................................................................14

Section 1 ? Introduction to spreadsheets..................................................................15 Introduction.....................................................................................................................15 What can spreadsheets do?...........................................................................................15 Spreadsheet programs...................................................................................................16

Section 2 ? Ergonomics...............................................................................................19 Introduction.....................................................................................................................19 Setting up your workstation............................................................................................19 Lighting...........................................................................................................................22 Eyes and body................................................................................................................23

Section 3 ? Conservation of resources......................................................................25 Introduction.....................................................................................................................25 Conservation techniques................................................................................................25

Section 4 ? Drives, files and folders...........................................................................27 Introduction.....................................................................................................................27 Getting organised...........................................................................................................27

Section 5 ? Getting help Introduction.....................................................................................................................33 How to get help..............................................................................................................33

? VET (WA) Ministerial Corporation 2012 | BC1932

3

Create and use spreadsheets

BSBITU202A

Section 6 ? Toolbars, tool buttons and shortcuts.....................................................35 Introduction.....................................................................................................................35 Toolbars and tool buttons...............................................................................................35 Keyboard shortcuts........................................................................................................37

Section 7 ? Navigating around a spreadsheet...........................................................39 Introduction.....................................................................................................................39 Navigating around a spreadsheet..................................................................................39

Section 8 ? Entering and editing data........................................................................41 Introduction.....................................................................................................................41 Entering and editing data...............................................................................................41 Selecting cells and ranges of cells.................................................................................43 The undo and redo commands......................................................................................44

Section 9 ? Filling, copying, cutting and pasting......................................................47 Introduction.....................................................................................................................47 The Fill function..............................................................................................................47 Copying and pasting.......................................................................................................49 Cutting and pasting........................................................................................................50

Section 10 ? Working with workbooks and worksheets...........................................51 Introduction.....................................................................................................................51 Setting up worksheets....................................................................................................51

Section 11 ? Formatting...............................................................................................53 Introduction.....................................................................................................................53 Basic formatting..............................................................................................................54

Section 12 ? Formulas.................................................................................................57 Introduction.....................................................................................................................57 Basic formulas................................................................................................................57

4

BC1932 | ? VET (WA) Ministerial Corporation 2012

Contents

Section 13 ? Working with rows and columns..........................................................61 Introduction.....................................................................................................................61 Working with rows and columns.....................................................................................61

Section 14 ? Preparing to print...................................................................................65 Introduction.....................................................................................................................65 Page setup.....................................................................................................................65 Headers and footers.......................................................................................................68 Printing...........................................................................................................................70

Section 15 ? Functions................................................................................................75 Introduction.....................................................................................................................75 Functions........................................................................................................................75

Section 16 ? Formula exercises..................................................................................77 Introduction.....................................................................................................................77

Section 17 ? Charts and other inserts........................................................................81 Introduction.....................................................................................................................81 Charts.............................................................................................................................82 Other inserts...................................................................................................................84

Annex A ? Unit details

Annex B ? Learning plan

Annex C ? Assessment plan

Annex D ? Assessments

? VET (WA) Ministerial Corporation 2012 | BC1932

5

Create and use spreadsheets

BSBITU202A

6

BC1932 | ? VET (WA) Ministerial Corporation 2012

Welcome

This learner's guide will take you through the process of learning how to set up, enter data into and print simple spreadsheets.

Areas of explanation include how to:

? work safely and comfortably ? organise your files and folders ? navigate around a spreadsheet and enter data ? use formulas to carry out calculations ? use formatting to enhance the appearance of spreadsheets ? produce charts from data.

This guide will introduce you to the basic principles of electronic spreadsheets. It has been written for people who have little or no knowledge of how spreadsheets are used or what they can do.

However, it does assume that you know your way around a keyboard, have a basic knowledge of how to use menus in a computer program and have a reasonable knowledge of maths (you'll need this for working out the formulas you'll be using in your work).

There are many software companies that produce spreadsheet programs, from the very sophisticated to relatively simple ones available for free. If there are differences between what's in this guide and the way your spreadsheet program operates, your lecturer will point them out and perhaps get you to make notes.

? VET (WA) Ministerial Corporation 2012 | BC1932

7

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download