wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Yr 7 - Spreadsheet - KEQ2

Total questions: 15

Worksheet time: 11mins

Name
Class
Date
1.

What is this box called in a spreadsheet

2.

What is this called

3.

Label the two highlighted areas in the spreadsheet

4.

A cell is a place in the spreadsheet, which is a small box, where values can be entered

a)
A cell is a large area in a spreadsheet for storing images.
b)
A cell is a row in a spreadsheet that contains formulas.
c)
A cell is a feature in spreadsheets that automatically calculates totals.
d)
A cell is a small box in a spreadsheet for entering values.
5.

What is the primary function of a spreadsheet cell?

a)

To store large datasets for analysis.

b)

To enter and store individual data values.

c)

To automatically generate charts.

d)

To format text in documents.

6.

Which of the following best describes a cell in a spreadsheet?

a)

A cell is a column that contains multiple rows.

b)

A cell is a small box where data can be inputted.

c)

A cell is a tool for creating graphs.

d)

A cell is a feature that summarizes data.

7.

How can a cell in a spreadsheet be identified?

a)

By its color and size.

b)

By its row and column coordinates.

c)

By the type of data it contains.

d)

By the number of formulas it holds.

8.

How can you quickly navigate to a specific cell in a spreadsheet?

a)

By scrolling through the entire sheet

b)

By using the 'Go To' function

c)

By manually counting the rows and columns

d)

By creating a new spreadsheet

9.

What is the purpose of using formulas in spreadsheet cells?

a)

To format the text within the cell.

b)

To perform calculations and automate data processing.

c)

To change the color of the cell.

d)

To insert images into the spreadsheet.

10.

Which of the following is a valid way to reference a cell in a spreadsheet?

a)

By its font style.

b)

By its background color.

c)

By its row and column label, such as A1.

d)

By its size in pixels.

11.

What happens when you merge cells in a spreadsheet?

a)

The data in all cells is combined into one cell.

b)

The cells are deleted from the spreadsheet.

c)

The cells are hidden from view.

d)

The cells are split into multiple smaller cells.

12.

Which of the following is a method to protect data in a spreadsheet?

a)

By hiding the spreadsheet.

b)

By using password protection for the sheet.

c)

By changing the font color to white.

d)

By printing the spreadsheet.

13.

What is the purpose of using cell references in spreadsheet formulas?

a)

To create a visual representation of data.

b)

To ensure formulas automatically update when data changes.

c)

To format the text within the cell.

d)

To insert images into the spreadsheet.

14.

Which of the following is a feature that allows you to view only specific data in a spreadsheet?

a)

Sorting

b)

Filtering

c)

Highlighting

d)

Formatting

15.

How can you adjust the width of a column in a spreadsheet?

a)

By dragging the column border.

b)

By changing the font size.

c)

By inserting a new row.

d)

By deleting the column.