Spreadsheet Basics and Formulas

Front

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?

Back

A grid of rows and columns

Front

What is a cell in a spreadsheet?

Back

A box with a unique address.

Front

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

Back

SUM

Front

What does the SUM formula do?

Back

Adds numbers

Front

In the task 'Total Score', what should be typed in cell A1? Options: Science Score, Maths Score, Art Score, Total Score

Back

Maths Score

Front

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

Back

To find the average of numbers

Front

Which of the following is a common use of a spreadsheet? Writing essays, Creating presentations, Editing photos, Organising data

Back

Organising data

Front

What should you type in cell B2 to calculate the total of cells B1 to B5? Options: =B1+B5, =PRODUCT(B1:B5), =AVERAGE(B1:B5), =SUM(B1:B5)

Back

=SUM(B1:B5)

Front

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

Back

Cell

Front

In spreadsheets, columns are marked with _________.

Back

Letters