Spreadsheet Basics and Formulas

James is organising his monthly expenses and wants to use a tool that allows him to input data in a structured format. What tool should he use?

• A) A type of graph

• B) A grid of rows and columns

• C) A type of chart

• D) A list of numbers.

Emily is organising her study schedule in a spreadsheet. What is a cell in her spreadsheet?

• A box with a unique address

• A type of formula

• A row of data

• A column of data.

Arjun is creating a budget spreadsheet. Which of the following is a basic spreadsheet formula he can use to calculate the total expenses?

• SUM

• ADD

• DIVIDE

• MULTIPLY

What does the SUM formula do?

• Subtracts numbers

• Multiplies numbers

• Adds numbers

• Divides numbers

Alexander is calculating his scores for different subjects. In the task 'Total Score', what should be typed in cell A1?

• Science Score

• Maths Score

• Art Score

• Total Score

In a spreadsheet, what is the function of the AVERAGE formula?

• To find the average of numbers

• To find the sum of numbers

• To find the product of numbers

• To find the difference between numbers

Which of the following is a common use of a spreadsheet?

• Writing essays

• Creating presentations

• Editing photos

• Organising data

What should you type in cell B2 to calculate the total of cells B1 to B5?

• =B1+B5

• =PRODUCT(B1:B5)

• =AVERAGE(B1:B5)

• =SUM(B1:B5)

The intersection of a row and column in a spreadsheet is called a __________.

• Cell
• Formula
• Label
• Value

In spreadsheets, columns are marked with _________.

• Letters
• Numbers
• = sign
• Both a letter and a number