QUOZR    BADGZ
   GUEST               
LEARNING SPREADSHEETS
Worksheets & Workbooks
Rows & Columns
Cells
ADD SUBTRACT MULTIPLY DIVIDE
Formatting Cells
SUM A RANGE OF CELLS
Computer Shop Project
Project - Calculate Income
Sum Average Min Max
COUNT & COUNTA
Relative & Absolute Referencing
Concatenate
SUM IF
COUNTIF
AVERAGEIF
You are not signed in. Sign In or Sign Up
You can still take all the badges though and simply show or submit your work anyway you please!
   YOU ARE NOW WORKING ON : WORKSHEETS & WORKBOOKS
INSTRUCTIONS  

Spreadsheets

Spreadsheets are use to perform mathematical equations and graphing of data
Many companies and individuals use this software to run business and other data related projects.

You will create a project !



There are 2 main programmes that we can use for Spreadsheets

1. Microsoft Excel (Comes with Microsoft Office Usually)
2. Google Sheets

This badge project will be using excel, but Google sheets are pretty much identical. Just some menu items are in different places and such. I will try to show example for both systems.



Worksheets:

A worksheet is a large grid of cells on a single sheet. The cells are used to hold data



Workbook:

A workbook is a collection of more than one worksheet in the same spreadsheet. They can be used to divide data up into different categories and organise it.

 


3 workbook tabs
Click the + to add new
Right Click to rename

CLAIM THIS BADGE

Using a shareable document
Open up the software you will be using and:-

1. SAVE your file with the title "Learning Spreadsheets'
2. Write your name in a big font and place a horizontal line below it.
3. Screenshot ONE worksheet and paste into your document
2. Add a new Tab from the bottom by clicking the + sign. Call this Tab 'RowsColumns') and screenshot ALL of your tabs. Together, these tabs form a workbook.

Paste both images into your document and explain

That the one worksheet is just one WORKSHEET
The tabs with more worksheets make a WORKBOOK

Submit your work