[PDF] [PDF] 1 4 using microsoft excel - Student

[PDF] EXCEL BASICS: PROJECTS - Elmhurst Public Library

Microsoft Office Folder located For the first project, open the “Excel Basics Projects Workbook” located on the desktop An Excel worksheet can also be used as a means for assessing information such as grading students' work, evaluating 

[PDF] Excel Project 1 Instructionspdf

Excel Group Project 1 1 Data and Sample Calculations The file Excel Project 1 Data xlsx includes three tabs Submit one worksheet per student 10

[PDF] Ms Excel Projects For Students - Unhaggle

Excel Exercises for StudentsFree Microsoft Office 365 for Schools Students 7 Fun Weird Things You Can Create With Microsoft ExcelMs Excel Projects For

[PDF] Microsoft EXCEL

Whenever you start a new project in Excel, you'll need to create a new you may need to work with workbooks that were created in earlier versions of Microsoft Excel, to use another file type, such as a PDF or Excel 97-2003 workbook

[PDF] 1 4 using microsoft excel - Student

Microsoft Excel Student Support Material Primary and Secondary Teacher Education Project Australian Another way is to start MSExcel from the program  

[PDF] Microsoft Excel Projects For High School Students

28 jan 2021 · plans for teaching students microsoft office, excel activities for elementary community, fun excel projects for high school students pdf download, excel

[PDF] 4 INTRODUCTION TO THE EXCEL SPREADSHEET Preparing a

ESSENTIAL MICROSOFT OFFICE XP: Tutorial for Teachers Copyright 4 2 illustrates a typical spreadsheet for keeping track of student grades Fig traditional manual worksheet in so far as it is programmable You can and graphs of all kinds, as well as for data analysis related to class projects where numbers need

[PDF] Ms Excel Projects For Students www1reserveatlakekeoweecom

Related with Ms Excel Projects For Students: james dauray evidence of evolution Microsoft Project 2007: The Missing Manual-Bonnie Biafore 2007-08-17 

[PDF] multiple inheritance java

[PDF] multiplexeur exercices corrigés pdf

[PDF] nahverkehr paris zonenplan

[PDF] naming amides pdf

[PDF] navigon app

[PDF] ncert solutions class 9th maths chapter 2

[PDF] negative effects of immigration essay

[PDF] neoma business school masters programs

[PDF] new york film academy paris france

[PDF] new zealand quarantine rules covid

[PDF] news247.gr

[PDF] nicky hilton rothschild net worth 2020

[PDF] nombre complexe cours terminale s pdf

[PDF] nombre d'habitants à paris 2020

[PDF] nombre premier composé et carré exercices

Unit 1: Introduction to Computer Literacy

ICT 1.4: Using Microsoft Excel

Student Support Material

ii ICT 1.4 Using Microsoft Excel

Student Support Material

Acknowledgements

Materials written and compiled by Greg Shaw

In consultation with

Peter Seth

Amkat Mai

Geoff Gibaru

Incorporating suggestions from staff of PNG teachers colleges Printed by EBC Lae, Papua New Guinea, September 2003

Date: 19 September 2003

PASTEP

Primary and Secondary Teacher Education Project

Australian Agency for International Development (AusAID)

GRM International

Papua New Guinea-Australia Development Cooperation Program

ICT 1.4: Using Microsoft Excel iii

Student Support Material

Unit outline

Unit

Modules

1.1

Computing Basics

(Core) 1.2

Finding Computer Based Information

(Core) 1.3

Using Microsoft Word

(Core) 1.4

Using Microsoft Excel

(Core) 1.5

Using Microsoft Outlook for email

(Optional)

Unit 1

Introduction to

Computer

Literacy

1.6

Making Presentations Using Microsoft PowerPoint

(Optional) Icons

Read or Research

Write or Summarise

Activity or Discussion

A computer activity

iv ICT 1.4 Using Microsoft Excel

Student Support Material

Table of contents

Glossary .............................................................................................................1

Using Microsoft Excel.........................................................................................2

What is Microsoft Excel?.................................................................................2

Starting up Excel.............................................................................................2

Moving around a worksheet............................................................................3

Creating a worksheet......................................................................................4

Doing calculations...........................................................................................5

Making a chart in Excel...................................................................................5

Some more calculations..................................................................................7

Adding a graph to our project..........................................................................8

The features of Excel....................................................................................10

ICT 1.4: Using Microsoft Excel 1

Student Support Material

Glossary

Cell A box in a spreadsheet where text, numbers or formulae can be added Spreadsheet A program that allows us to input, edit and reproduce text and numbers. In particular it allows us to set up formulas to do calculations on numbers and to present reports as charts

Microsoft Excel is a spreadsheet program

Work Book This is the data file that open when we start Excel Worksheet A workbook consists of one or more worksheets that we can link data or have as separate pages in our workbook.

2 ICT 1.4 Using Microsoft Excel

Student Support Material

Using Microsoft Excel

What is Microsoft Excel?

Microsoft Excel (or Excel) is an application that allows us to do calculations with numbers and present reports that often contain numbers. Though Excel is an application for working with numbers we can also prepare text in Excel. Excel is referred to as a spreadsheet application. With Excel we can:

Organize and store data

Do simple and complex calculations

Analyze data to understand it

Format and present reports

Once a structure is set up, with formulas Excel allows us to do calculations for us when we input new data into the spreadsheet. With Excel we can present data in graphs, charts and tables and we can take information from Excel and easily place it into a MSWord document. We will use our project to learn about some of the things that we can do with Excel.

Starting up Excel

You will need to work with your computer for the following exercises

1.4 Computer Activity One

1. You already know how to turn the computer on. If your computer is not on then

start it up now

2. We can start up MSExcel in several ways. One way is to double click on the

MSExcel icon on the desktop. Another way is to start MSExcel from the program files in the Start Menu. Start MSExcel now.

3. You should get a screen that looks a little like the one on the next page. Don't

worry if yours is a little bit different

ICT 1.4: Using Microsoft Excel 3

Student Support Material

What we have on the Excel screen is what looks like a table with rows and columns.quotesdbs_dbs2.pdfusesText_3