TOPIC 10 - SPREADSHEETS

TOPIC 10 - SPREADSHEETS

1. WHAT CAN A SPREADSHEET CELL CONTAIN

   • LABELS
     • ANY TEXT IN A CELL DESCRIBING THE DATA IN A ROW OR COLUMN (TITLES,HEADINGS AND IDENTIFY DATA)
   • DATA
     • ANY VALUES (TEXT OR NUMBERS) THAT ARE ENTERED FOR THE USE OF CALCULATIONS
   • FORMULAS&FUNCTIONS
     • MATHIMATICAL CALCULATIONS CARRIED OUT AUTOMATICALLY

2. CONDITIONS

   • DECISIONS ARE BASED ON A CONDITION
   • A TESTABLE CONDITION IS EITHER TRUE OR FALSE
   • CONDITIONS ARE TESTED USING A COMPARISON OPERATOR
   • CONDITIONAL STATEMENT IS ANY ACTION TAKEN DEPENDING ON THE RESULT OF TESTING A CONDITION

3. OPERATORS

   • = EQUALS
   • <> NOT EQUAL
   • < LESS THAN
   • > MORE THAN
   • <= LESS THAN OR EQUAL TO
   • >= MORE THAN OR EQUAL TO

4. IF FUNCTIONS

   • =IF(LOGICAL COMPARISON, TRUE, FALSE)
   • =IF(C1=10, "FULL MARKS, "GOOD TRY")