Spreadsheets

Question 1

Which of the following can be added to a chart to improve clarity and interpretation? (Multiple Response)

A) Data Tables

B) Background soundtrack

C) Trendlines

D) Watermarks

E) Data Labels

Answer 1

A) Data Tables

C) Trendlines

E) Data Labels

Question 2

Match each averaging method with the scenario where it is most appropriate:

A) Mean
B) Median
C) Mode

1.You’re calculating how much each person should contribute to buy a group gift.

2.You’re identifying the most frequently achieved exam result.

3.You want the middle value of a set of exam scores.

Answer 2

A → 1 (Equal distribution = Mean)

B → 3 (Middle value = Median)

C → 2 (Most frequent = Mode)

Question 3

What does the formula ‘=NOW()’ return in a spreadsheet?

A) Current time only

B) A timestamp that changes every 10 minutes

C) The current date and time

D) A static date and time that doesn’t update

Answer 3

C) The current date and time

Question 4

What do the spreadsheet functions ‘=LEFT()’ and ‘=RIGHT()’ do?

A) Perform subtraction between cell values

B) Extract characters from either the start or end of a string

C) Convert lowercase text to uppercase

D) Only work on numbers

Answer 4

B) Extract characters from either the start or end of a string

E.g. =LEFT(“Spreadsheet”, 5) returns “Sprea” — the first five characters.

Question 5

What does the acronym BODMAS stand for, and what is its purpose in calculations?

Answer 5

Brackets, Orders, Division, Multiplication, Addition, Subtraction

It tells you the correct order in which to carry out operations in a calculation.