Spreadsheets for Year 5: Learn the Basics of Data Organization and Analysis

Question 1

What do charts and graphs do in a spreadsheet?

Accepted Answer

Show data in a picture format

Answer

Calculate difficult formulas

Answer

Hold a lot of data

Answer

Analyze statistics

Question 2

Why do we format cells in a spreadsheet?

Accepted Answer

To change how they look

Answer

To protect them from being edited

Answer

To create formulas

Answer

To insert pictures

Question 3

Your friend's birthdays are listed in a spreadsheet. How can you find out who has the earliest birthday?

Accepted Answer

Sort the data by birthday and filter for the earliest date.

Answer

Sort the data by name.

Answer

Create a chart of the birthdays.

Question 4

Which tab in a spreadsheet lets you put in and change formulas?

Accepted Answer

Formulas

Answer

Home

Answer

Insert

Answer

Data

Question 5

What file type are Microsoft Excel spreadsheets saved as?

Accepted Answer

.xlsx

Answer

.xls

Answer

.csv

Answer

.txt

Question 6

How do you lock the top row of a spreadsheet so you can see it when you scroll down?

Accepted Answer

Use the Freeze Panes option in the View menu

Answer

Select the top row and put a border around it

Answer

Use the Format Cells dialog box to lock the top row

Answer

You can't lock rows in a spreadsheet

Question 7

What is the software called that you use to create spreadsheets?

Accepted Answer

Spreadsheet

Answer

Word Processor

Answer

Database

Answer

Presentation Software

Question 8

Which of these is NOT a basic part of a spreadsheet?

Accepted Answer

Shapes

Answer

Cells

Answer

Rows

Answer

Columns

Question 9

What do you use a formula in a spreadsheet for?

Accepted Answer

To do calculations

Answer

To change the look of cells

Answer

To make charts

Answer

To organize data

Question 10

Which function do you use to add up the numbers in a range of cells?

Accepted Answer

SUM

Answer

AVERAGE

Answer

COUNT

Answer

MIN

Question 11

What is the purpose of formatting in a spreadsheet?

Accepted Answer

To make it easier to read and understand the data

Answer

To do calculations

Answer

To make charts

Answer

To sort data

Question 12

What is the file extension for a spreadsheet in Microsoft Office?

Accepted Answer

.xls

Answer

.doc

Answer

.ppt

Answer

.pdf

Question 13

Which of the following is NOT a part of a spreadsheet?

Accepted Answer

Pictures

Answer

Rows

Answer

Columns

Answer

Cells

Question 14

Which function would you use to calculate the average of a range of numbers?

Accepted Answer

AVERAGE

Answer

SUM

Answer

MAXIMUM

Answer

MINIMUM

Question 15

What is the purpose of formatting a spreadsheet?

Accepted Answer

To make the spreadsheet easier to read and understand

Answer

To protect the data in the spreadsheet

Answer

To perform calculations on the data

Answer

To share the spreadsheet with others

Question 16

Which of the following is NOT a common spreadsheet application?

Accepted Answer

Microsoft Word

Answer

Microsoft Excel

Answer

Google Sheets

Answer

Apple Numbers

Question 17

What is the extension for a spreadsheet file in Microsoft Excel?

Accepted Answer

.xlsx

Answer

.doc

Answer

.ppt

Answer

.pdf

Question 18

Which of these is NOT a task that can be performed in a spreadsheet?

Accepted Answer

Writing an essay

Answer

Entering data

Answer

Creating graphs

Answer

Performing calculations

Question 19

How do you choose a range of cells in a spreadsheet?

Accepted Answer

Click and drag the mouse over the cells

Answer

Use the keyboard arrow keys to move between cells

Answer

Type in the cell range in the name box

Answer

Double-click on the first cell in the range

Question 20

What is a formula used for in a spreadsheet?

Accepted Answer

To perform calculations on data

Answer

To make cells look different

Answer

To create graphs

Answer

To sort data

Question 21

Which type of chart is best for showing trends over time?

Accepted Answer

Line chart

Answer

Pie chart

Answer

Bar chart

Answer

Scatter plot

Question 22

What is the difference between a cell reference and a cell value?

Accepted Answer

A cell reference is the location of the cell and a cell value is the data in the cell

Answer

A cell value is the location of the cell and a cell reference is the data in the cell

Answer

There is no difference between a cell reference and a cell value

Answer

A cell reference is used to create charts and a cell value is used to perform calculations

Question 23

Which of these is a correct formula for calculating the total of the values in cells A1 to A5?

Accepted Answer

=SUM(A1:A5)

Answer

=A1+A2+A3+A4+A5

Answer

=TOTAL(A1:A5)

Answer

=ADD(A1:A5)

Question 24

What is conditional formatting used for in a spreadsheet?

Accepted Answer

To automatically apply formatting to cells based on certain conditions

Answer

To create charts and graphs

Answer

To perform calculations on data

Answer

To sort and filter data

Question 25

When copying a formula to a new cell, which cell reference type will change to match the new location?

Accepted Answer

Relative reference

Answer

Absolute reference

Question 26

What does a cell reference do in a spreadsheet?

Accepted Answer

Do math using data from different cells

Answer

Find where a cell is

Answer

Show your data as a picture

Answer

Store writing or numbers

Question 27

Which graph is best for showing how data is spread out?

Accepted Answer

Histogram

Answer

Line graph

Answer

Bar graph

Answer

Pie chart

Question 28

What is the formula to add up the numbers in cells A1 to A5?

Accepted Answer

=SUM(A1:A5)

Answer

=AVERAGE(A1:A5)

Answer

=COUNT(A1:A5)

Answer

=MAX(A1:A5)

Question 29

Which of these is a proper cell range?

Accepted Answer

A1:C5

Answer

1:5

Answer

A:C

Answer

1:C

Question 30

Why do we use a header row in a spreadsheet?

Accepted Answer

To show what the data in each column is

Answer

To do math on the data

Answer

To make a picture of the data

Answer

To write the formula for the column

Question 31

Which of these is NOT a plus side to using spreadsheets?

Accepted Answer

Taking away data

Answer

Keeping your data organized

Answer

Doing math

Answer

Showing your data as a picture

Question 32

What is the difference between a relative and an absolute cell reference?

Accepted Answer

Relative references move when copied, but absolute references don't.

Answer

Absolute references move when copied, but relative references don't.

Answer

Relative references are for math, while absolute references are for finding cells.

Answer

Absolute references are for math, while relative references are for finding cells.

Question 33

What does the 'AutoFill' feature do in a spreadsheet?

Accepted Answer

Fills in a series of values automatically

Answer

Makes a graph or chart

Answer

Does math

Answer

Deletes rows or columns

Question 34

Which of these is good practice when working with spreadsheets?

Accepted Answer

Use clear and short column names

Answer

Put all your data in one worksheet

Answer

Leave blank spaces between your data

Answer

Use fancy formulas

Question 35

In a spreadsheet, which part cannot hold data?

Accepted Answer

Paragraphs

Answer

Cells

Answer

Rows

Answer

Columns

Question 36

To enter a formula in a cell, you must start with:

Accepted Answer

An equals sign (=)

Answer

A letter

Answer

A plus sign (+)

Answer

A minus sign (-)

Question 37

What is the function used to add numbers in a spreadsheet?

Accepted Answer

SUM

Answer

SUBTRACT

Answer

MULTIPLY

Answer

DIVIDE

Question 38

Where can you change the font of the text in a spreadsheet cell?

Accepted Answer

Home tab

Answer

Insert tab

Answer

View tab

Answer

Data tab

Question 39

Which of the following is NOT a benefit of using spreadsheets?

Accepted Answer

Printing documents

Answer

Organizing data

Answer

Performing calculations

Answer

Creating visual representations of data

Question 40

Which software is used to create and edit spreadsheets?

Accepted Answer

Excel

Answer

Word

Answer

PowerPoint

Answer

Access

Question 41

Which key combination can you use to copy a selected cell?

Accepted Answer

Ctrl + C

Answer

Ctrl + V

Answer

Ctrl + X

Answer

Ctrl + S

Question 42

In a spreadsheet, which part is used to store data?

Accepted Answer

Cells

Answer

Rows

Answer

Columns

Answer

Graphs

Question 43

What is the main purpose of using formulas in a spreadsheet?

Accepted Answer

To perform calculations automatically

Answer

To format the data

Answer

To create graphs

Answer

To store text

Question 44

Which type of chart is best suited for displaying data that changes over time?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Scatter plot

Question 45

What is the keyboard shortcut to copy a cell's contents?

Accepted Answer

Ctrl+C

Answer

Ctrl+V

Answer

Shift+C

Answer

Shift+V

Question 46

What is the purpose of using a filter in a spreadsheet?

Accepted Answer

To show or hide specific rows or columns

Answer

To sort data

Answer

To perform calculations

Answer

To create a chart

Question 47

Which file format is commonly used to save spreadsheets?

Accepted Answer

.xls

Answer

.doc

Answer

.pdf

Answer

.ppt

Question 48

What is the name of the location where rows and columns meet in a spreadsheet?

Accepted Answer

Cell

Answer

Row

Answer

Column

Answer

Grid

Question 49

What is a spreadsheet mostly used for?

Accepted Answer

Organizing and analyzing information

Answer

Drawing pictures

Answer

Creating presentations

Answer

Writing stories

Question 50

Which symbol tells a spreadsheet to do a calculation?

Accepted Answer

=

Answer

*

Answer

-

Answer

+

Question 51

What is a cell in a spreadsheet?

Accepted Answer

A box where a row and column meet

Answer

A way to change the color of text

Answer

A formula for adding numbers

Answer

A type of chart

Question 52

To add the numbers in cells A1 and B1, which formula would you use?

Accepted Answer

=A1+B1

Answer

A1+B1

Answer

A1&B1

Answer

=SUM(A1:B1)

Question 53

What does the SUM function do in a spreadsheet?

Accepted Answer

Adds a group of numbers together

Answer

Changes the color of cells

Answer

Finds the biggest number

Answer

Creates a chart

Question 54

Which chart is best for showing how something changes over time?

Accepted Answer

Line chart

Answer

Scatter chart

Answer

Bar chart

Answer

Pie chart

Question 55

How can you quickly add up a whole column of numbers in a spreadsheet?

Accepted Answer

Use the AutoSum button

Answer

Draw a chart

Answer

Use a calculator

Answer

Type the numbers again and add them

Question 56

Why do we use formulas in a spreadsheet?

Accepted Answer

To do calculations automatically

Answer

To change the font style

Answer

To print the spreadsheet

Answer

To insert a picture

Question 57

You want to make a chart showing how many students like different fruits. What information do you need?

Accepted Answer

A list of fruits and how many students like each one

Answer

Where each fruit is grown

Answer

The price of each fruit

Question 58

How can you put data in order in a spreadsheet?

Accepted Answer

Select the data and use the sort function

Answer

You can't sort data in a spreadsheet

Answer

Copy and paste the data into a word processor

Answer

Delete the data and type it again in order