google spreadsheet !! (notes)

Question 1

How to make a cell??

Answer 1

Row + Column

Question 2

What sign does the formula always begin with??

Answer 2

The ‘=’ sign

Question 3

What are the operators??

Answer 3

• Addition ( + )
• Subtraction ( - )
• Multiplication ( * )
• Division ( / )

Question 4

How do you create autofill??

Answer 4

1. Select the cell/cells
2. In the right bottom side of the cell, drag the ‘o’ sign

Question 5

What is relative reference??

Answer 5

Cell address will increase/decrease (will change) based on the relative position

Question 6

What is absolute reference??

Answer 6

Cell address will *refer to a specific location (never change)

Question 7

Sorting data is by doing??

Answer 7

• Ascending (e.g. 1 - 10)
• Descending (e.g. 10 - 1)

Question 8

What is filtering??

Answer 8

A process selecting records from a large amount of data on certain conditions

Question 9

How do you sort data??

Answer 9

• 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

Question 10

How do you filter data??

Answer 10

• 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

Question 11

How to remove filter??

Answer 11

• Select the header
• Data → Remove filter

Question 12

How to apply custom filter??

Answer 12

• Apply filter to your data
• Click dropdown symbol (Filter switch)
• Select Filter by condition
• Add the parameter (value)
• OK

Question 13

What are the 2 types of condition??

Answer 13

• Greater than
• Less than

Question 14

What is Greater than condition??

Answer 14

Shows the data more than the condition

Question 15

What is Less than condition??

Answer 15

How the data that less than the condition

Question 16

What is conditional formatting??

Answer 16

A feature that *used to format cells using specific colour, border, font, etc

Question 17

How to use conditional formatting??

Answer 17

• Select the determine data
• Menu format → Conditional Formatting
  »> Apply to range (To apply where your formatting will be)
  »> Format rules (Create a condition ru»> Formatting style (Create style such as adding colour, border, font, etc.)

Question 18

How to remove the conditional formatting??

Answer 18

• Select the determine data
• Menu format → Conditional formatting
• In right of your screen ‘’Conditional Format Rules’’
• Click symbol (🗑️) to delete the rule

Question 19

What is chart??

Answer 19

A graphical representation of information

Question 20

What are the examples of chart??

Answer 20

Pie, bar, line, column, etc

Question 21

How do you create a chart??

Answer 21

• Select all the data (including the header)
• Menu Insert → Chart
• Chart Editor

Question 22

What are the 4 types of chart editor??

Answer 22

• Chart type
• Data range
• X-Axis
• Series

Question 23

What is chart type??

Answer 23

The type of chart

Question 24

What is data range??

Answer 24

Data that want to convert to be a chart

Question 25

What is X-Axis??

Answer 25

Horizontal axis of chart

Question 26

What is series??

Answer 26

Vertical axis of chart (Y-Axis)