Google Sheets – (IGCSE Computer Science)

Match the following, Basic Arithmetic Functions

• Rounds a number to a specified decimal p

• AVERAGE()

• Returns the largest value

• ROUND()

• Returns the smallest value

• MIN()

• Adds a range of numbers

• MAX()

• Finds the mean of numbers

• SUM()

Match the following, Logical Functions

• Returns different values based on a cond

• OR()

• Checks if at least one condition is TRUE

• IF()

• Checks if multiple conditions are TRUE

• AND()

• Returns a custom message if an error occ

• IFERROR()

Match the following, Counting Functions

• Counts values that meet a condition

• COUNTA()

• Counts non-empty cells (numbers + text)

• COUNTIFS()

• Counts values that meet multiple conditi

• COUNTIF()

• Counts numeric values

• COUNT()

Match the following, Text Functions

• Extracts characters from the right

• LEN()

• Joins text with a separator

• LEFT()

• Extracts a certain number of characters

• CONCATENATE()

• Returns the length of text in a cell

• RIGHT()

• Joins two or more text values

• TEXTJOIN()

Match the following, Lookup & Reference Functions (These functions search for values in a table or dataset)

• Searches for a value in the first column

• INDEX()

• Returns value of a cell at a specific

• HLOOKUP()

• Returns value of a dynamically reference

• MATCH()

• Returns row/column number of value range

• VLOOKUP()

• Searches a value in first row of table

• INDIRECT()

Match the following, Cells, Rows, and Columns

• Horizontal line of cells (1, 2, 3…).

• Rows

• A single data point (e.g., A1, B2)

• Columns

• Vertical line of cells (A, B, C…).

• Cells

Match the following, Data Entry & Formatting

• Adjust font, color, alignment, and size.

• Merge Cells

• Combine multiple cells into one.

• Cell Formatting

• Can input words, numbers, and dates

• Text & Numbers

Match the following, Function Type

Groups:

(a) Math & Stats

,

(b) Logical Functions

,

(c) Text Manipulation

,

(d) Lookup Functions

• IFERROR

• MAX

• AVERAGE

• LEFT

• AND

• VLOOKUP

• RIGHT

• OR

• IF

• MIN

• CONCATENATE

• SUM

• HLOOKUP

• MATCH

• LEN

• COUNT

• INDEX

Match the following, Function Type

Groups:

(a) Data Handling

,

(b) Charts & Graphs

,

(c) Automation

,

(d) Collaboration

• ARRAYFORMULA

• IMPORTHTML

• Column

• SORT

• Version History

• Comments

• Scatter

• QUERY

• FILTER

• IMPORTRANGE

• Line

• Pie

• Sharing

Organize these options into the right categories, Google Sheets vs. Microsoft Excel

Groups:

(a) Accessibility Sheets

,

(b) Accessibility Excel

• Local storage, requires installation

• Cloud-based, accessible anywhere