Review Google Sheet

Google Sheet มีคุณสมบัติอะไรบ้างที่ Excel ไม่มี?

• Cloud (Online)

• Advance Calculate

• Create Formulas

Google Sheet is look like program........ ?

• Microsoft Power BI

• Microsoft Excel

• Both

Which operator is first calculated?

• +,-

• *,/

• ( )

Function Matching

Groups:

(a) Maximum

,

(b) Minnimum

,

(c) Total

,

(d) Conditon

• Sum

• If

• Max

• Min

Count Function Matching

Groups:

(a) Count Text

,

(b) Count Number

,

(c) Count blank cell

,

(d) Count with Condition

• Count

• CountBlank

• CountA

• CountIf

What is not the benefit of AutoFill?

• Copy Data or Formulas

• Automatic Text Running

• Automatic calculate