pre-defined spreadsheet functions

Question 1

Function: SUM()

Answer 1

📘 Purpose: Adds all the numbers in a range.

🧮 Example: =SUM(A1:A5) → Adds values from A1 to A5.

Question 2

Function: AVERAGE()

Answer 2

📘 Purpose: Calculates the average (mean) of a range.

🧮 Example: =AVERAGE(B1:B5) → Finds the average of values in B1 to B5

Question 3

Function: DATE()

Answer 3

📘 Purpose: Returns the current or specified date.

🧮 Example: =DATE(2025,4,16) → Returns April 16, 2025.

Question 4

Function: MAX()

Answer 4

📘 Purpose: Finds the highest number in a range.

🧮 Example: =MAX(C1:C10) → Returns the largest value in C1 to C10.

Question 5

Function: MIN()

Answer 5

📘 Purpose: Finds the lowest number in a range.

🧮 Example: =MIN(D1:D10) → Returns the smallest value in D1 to D10.

Question 6

Function: COUNT()

Answer 6

📘 Purpose: Counts the number of numeric values in a range.

🧮 Example: =COUNT(E1:E10) → Counts only the numbers in E1 to E10.

Question 7

Function: COUNTA()

Answer 7

📘 Purpose: Counts all non-empty cells in a range.

🧮 Example: =COUNTA(F1:F10) → Counts both text and numbers in F1 to F10.

Question 8

Function: COUNTIF(range, criteria)

Answer 8

📘 Purpose: Counts cells that meet a specific condition.

🧮 Example: =COUNTIF(G1:G10, “>50”) → Counts how many cells in G1:G10 are greater than 50.

Question 9

Function: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Answer 9

📘 Purpose: Looks for a value in the first column and returns a value from another column.

🧮 Example: =VLOOKUP(“John”, A2:C10, 3, FALSE) → Finds “John” in column A and returns the value from column C.

Question 10

Function: PMT(rate, nper, pv)

Answer 10

Purpose: Calculates loan payments based on interest rate, number of periods, and loan amount.

🧮 Example: =PMT(0.05/12, 60, -10000) → Monthly payment for a $10,000 loan at 5% interest for 5 years.

Question 11

Function: IF(logical_test, value_if_true, value_if_false)

Answer 11

📘 Purpose: Returns one value if a condition is true and another if false.

🧮 Example: =IF(H1>50, “Pass”, “Fail”) → If H1 is greater than 50, returns “Pass”; otherwise, “Fail”.