Flashcards
[1ST - ICT] module 5 (spreadsheet)
Cards in this deck (20)
- 1a number format that is used for accountingAccounting Number Format
- 2the angle at which a text is displayedOrientation
- 3a function used to count the cells with content in a rangeCount
- 4difference between COUNT and COUNTACOUNT: counts cells containing numbers
COUNTA: counts cells that are not empty - 5a function used to compute for the summation of the number of a rangeSum
- 6a function used to compute for the average of the number of a rangeCOUNTIF
- 7format for COUNTIF function=COUNTIF(range, criteria)
- 8a function used to compute for the summation of a range if a certain condition is metSUMIF
- 9a function used to compute for the average of a range if a certain condition is metAVERAGEIF
- 10format for AVERAGEIF=AVERAGEIF(range, criteria, average range)
- 11the range of cells where you want to look for the criteriaRange
- 12a value or label that determines if a cell is part of the range to be averagedCriteria
- 13format for criteriaword:
"word"
"YES"
special character:
char(code)
char(252) - 14the actual range of cells that will be averagedAverage Range
- 15AVERAGEIF format: what cells will be averaged if the average range is omittedrange
- 16how to change the number of decimal placeshome tab (number group) →
increase/decrease decimal button
OR
format cells →
set number of decimal places - 17how is the negative sign shown in excelusing parentheses
( )
(number) - 18how to add Php / currency symbolformat cells (number group) →
change symbol to Php - 19the small box at the bottom right corner of a selected cellautofill box
- 20formula to find the difference (and where can it be used)=A1-A2
(no difference function)
- to find the profit
(=SalePrice-TotalExpenses)
Information
- Description
- First Sem Grade 11 1️⃣ (ICT) Flashcards on [1ST - ICT] module 5 (spreadsheet), created by Hannah Rabano on 01/10/2021.
- Created by
- Hannah Rabano
- Views
- 0
- Rating