google spreadsheet !! (notes) Flashcards
1
Q
How to make a cell??
A
Row + Column
2
Q
What sign does the formula always begin with??
A
The ‘=’ sign
3
Q
What are the operators??
A
- Addition ( + )
- Subtraction ( - )
- Multiplication ( * )
- Division ( / )
4
Q
How do you create autofill??
A
- Select the cell/cells
- In the right bottom side of the cell, drag the ‘o’ sign
5
Q
What is relative reference??
A
Cell address will increase/decrease (will change) based on the relative position
6
Q
What is absolute reference??
A
Cell address will *refer to a specific location (never change)
7
Q
Sorting data is by doing??
A
- Ascending (e.g. 1 - 10)
- Descending (e.g. 10 - 1)
8
Q
What is filtering??
A
A process selecting records from a large amount of data on certain conditions
9
Q
How do you sort data??
A
- Select the data to be sorted (blocking)
- Data → Sort Range
- Select ‘’Advanced Sorting Option’’
- If the data has header, tick in the ‘’Data has header now’’
- Choose ‘’Sort by’’ the header depend on you need
- Choose ‘A to Z’ or ‘‘Z to A’ to sort your data
- Click sort
10
Q
How do you filter data??
A
- Select the header
- Menu DATA → Create a filter
- In here you can click the drop down symbol in the header to fill your data
- The filter will automatically apply when you add another data below the existing data
11
Q
How to remove filter??
A
- Select the header
- Data → Remove filter
12
Q
How to apply custom filter??
A
- Apply filter to your data
- Click dropdown symbol (Filter switch)
- Select Filter by condition
- Add the parameter (value)
- OK
13
Q
What are the 2 types of condition??
A
- Greater than
- Less than
14
Q
What is Greater than condition??
A
Shows the data more than the condition
15
Q
What is Less than condition??
A
How the data that less than the condition
