Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
| Written by Shoppeiil
S
Shoppeiil
Community Contributor
Quizzes Created: 1 | Total Attempts: 409
Questions: 12 | Attempts: 409

Settings

A basic quiz for a first experience with spreadsheets. For children aged 9 or 10.

• 1.

### What are spreadsheets used to do?

• A.

• B.

To make numbers prettier.

• C.

To organise data in a table.

• D.

To help us calculate rapidly, explore different options and represent data in charts.

D. To help us calculate rapidly, explore different options and represent data in charts.
Explanation
Spreadsheets are used to help us calculate rapidly by performing various mathematical operations on the data. They also allow us to explore different options by easily changing values and formulas. Additionally, spreadsheets enable us to represent data in charts, making it easier to visualize and analyze the information.

Rate this question:

• 2.

• A.

Keynote

• B.

Pages

• C.

Numbers

• D.

LibreOffice Calc

• E.

Word

• F.

Excel

• G.

Powerpoint

C. Numbers
D. LibreOffice Calc
F. Excel
Explanation
The correct answer is Numbers, LibreOffice Calc, and Excel. These three options are spreadsheet programs commonly used for organizing and analyzing data. Keynote, Pages, Word, and PowerPoint are not spreadsheet programs, but rather presentation and word processing software.

Rate this question:

• 3.

• A.

Columns and rows

• B.

Lines and numbers

• C.

Cells and references

A. Columns and rows
Explanation
Spreadsheets are arranged in columns and rows to create a grid-like structure. Columns are vertical sections that are labeled with letters, while rows are horizontal sections labeled with numbers. This arrangement allows data to be organized and displayed in a tabular format, with each cell representing a unique intersection of a column and row. Cells can contain various types of data, such as numbers, text, or formulas, while references enable linking and accessing data from other cells within the spreadsheet.

Rate this question:

• 4.

### All formulae begin with...

• A.

+

• B.

-

• C.

*

• D.

/

• E.

=

E. =
Explanation
The correct answer is "=" because in mathematics, the symbol "=" is used to indicate equality or equivalence between two expressions or values. It is used to show that the value on the left side of the equation is equal to the value on the right side. Therefore, all formulae begin with the "=" sign to establish this equality.

Rate this question:

• 5.

### I want to multiply the number in cell E2 by that in cell B5. What is the formula?

• A.

=E2*B5

• B.

=E2xB5

• C.

=B5*E2

• D.

E2*B5=

A. =E2*B5
C. =B5*E2
Explanation
The correct answer is =E2*B5 or =B5*E2. Both formulas will multiply the number in cell E2 by the number in cell B5. The order of the cells being multiplied does not matter in multiplication, so both formulas are correct.

Rate this question:

• 6.

### =F7/G3 This formula divides the number in cell F7 by the number in cell G3.

• A.

True

• B.

False

A. True
Explanation
The given formula "=F7/G3" is a division formula that divides the number in cell F7 by the number in cell G3. Therefore, the correct answer is true.

Rate this question:

• 7.

### Spreadsheets are useful for ...

• A.

Creating charts and graphs

• B.

Exploring alternatives

• C.

Making work look better

• D.

Presenting research to an audience

A. Creating charts and graphs
B. Exploring alternatives
Explanation
Spreadsheets are useful for creating charts and graphs because they allow users to organize and present data in a visual format. This feature is particularly helpful when analyzing numerical information and identifying patterns or trends. Additionally, spreadsheets enable users to explore alternatives by manipulating the data and conducting "what-if" scenarios. This allows for easy comparison and decision-making.

Rate this question:

• 8.

### Example/s of a cell reference.

• A.

5B

• B.

C1

• C.

L99

• D.

I8

B. C1
C. L99
D. I8
Explanation
The given examples represent cell references in a spreadsheet. In a spreadsheet, cells are identified by their column and row labels. The first example "C1" refers to the cell in column C and row 1. Similarly, "L99" refers to the cell in column L and row 99, and "I8" refers to the cell in column I and row 8. Cell references are used to refer to specific cells in formulas or to retrieve data from those cells.

Rate this question:

• 9.

### What does the function SUM do?

• A.

It helps you put the title in the middle.

• B.

It quickly moves all the selected cells down.

• C.

It quickly adds up values in a range of cells.

• D.

It highlights all selected cells red.

C. It quickly adds up values in a range of cells.
Explanation
The function SUM is used to quickly add up values in a range of cells. This means that if you have a series of numbers in different cells, you can use the SUM function to calculate their total sum. It is a useful tool for performing calculations and obtaining the sum of multiple values without having to manually add them together.

Rate this question:

• 10.

### Which of these could you use a spreadsheet for?

• A.

Presenting data in charts and graphs

• B.

Presenting research homework.

• C.

Calculating pocket money in order to find out how long you need to wait to buy a new 'toy'.

• D.

Budgeting for a party.