EDUCATION COLLABORATION
    
  Alias   Guest 
      Sketchr    Class Tracker    My Calendar    My Notes    My ToDo Lists
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
       GUEST      
     
   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




Terms of Service   Terms & Conditions   Privacy   Security   Safety   Contact Us  
quozr.org - DevXel © 2022  |  Online Now:  883