wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Year 7 HT2 Spreadsheet Assessment

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.

What does the formula =SUM(A1:A10) do?

a)

Returns the SUM of the selected cells

b)

Returns the AVERAGE of the selected cells

c)

Returns the HIGHEST value of the selected cells

d)

Returns the LOWEST value of the selected cells

2.

Which formula returns the AVERAGE of the selected cells?

a)

=SUM(A1:A10)

b)

=AVERAGE(B1:B10)

c)

=MAX(C1:C10)

d)

=MIN(B1:B10)

3.

What does the formula =MAX(C1:C10) do?

a)

Returns the SUM of the selected cells

b)

Returns the AVERAGE of the selected cells

c)

Returns the HIGHEST value of the selected cells

d)

Returns the LOWEST value of the selected cells

4.

Which formula returns the LOWEST value of the selected cells?

a)

=SUM(A1:A10)

b)

=AVERAGE(B1:B10)

c)

=MAX(C1:C10)

d)

=MIN(B1:B10)

5.

What does the formula =COUNT(C1:C10) do?

a)

Returns the number of cells values of the selected cells

b)

Returns the SUM of the selected cells

c)

Returns the AVERAGE of the selected cells

d)

Returns the HIGHEST value of the selected cells

6.

Which operator is used to add two numbers/cells in Excel?

a)

+

b)

-

c)

*

d)

/

7.

Which operator is used to multiply two numbers/cells in Excel?

a)

+

b)

-

c)

*

d)

/

8.

Which operator is used to divide one number/cell from another in Excel?

a)

+

b)

-

c)

*

d)

/

9.

What does the formula =COUNTIF(A1:A10, ">5") do?

a)

Counts the number of cells with values greater than 5

b)

Returns the SUM of the selected cells

c)

Returns the AVERAGE of the selected cells

d)

Returns the HIGHEST value of the selected cells

10.

Which formula returns the number of non-empty cells in a range?

a)

=COUNTA(A1:A10)

b)

=COUNTBLANK(A1:A10)

c)

=COUNTIF(A1:A10, ">0")

d)

=COUNT(A1:A10)

11.

What does the formula =IF(A1>10, "Yes", "No") do?

a)

Returns "Yes" if A1 is greater than 10, otherwise returns "No"

b)

Returns the SUM of the selected cells

c)

Returns the AVERAGE of the selected cells

d)

Returns the HIGHEST value of the selected cells

12.

In a worksheet, the vertical spaces with letter headings are called...

a)

columns

b)

files

c)

rows

d)

formulas

13.

In a worksheet, the vertical spaces with letter headings are called...

a)

columns

b)

files

c)

rows

d)

formulas

14.

When you move information while holding down the mouse button (usually the left) to select a range of cells.

a)

Drag

b)

File

c)

Label

d)

Sheet tab

15.

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

a)

Active cell

b)

Autofill

c)

Cell

d)

Cell grid

16.

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

a)

Autofill

b)

Cell Address

c)

Fill down

d)

Worksheet

17.

A function that automatically identifies and adds ranges of cells in your worksheet.

a)

Autosum

b)

Average

c)

Finance

d)

Drag

18.

The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.

a)

Cell

b)

Cell address

c)

Cell grid

d)

Column

19.

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

a)

Cell address

b)

Cell grid

c)

Formula bar

d)

Heading

20.

A document that is stored on your computer. In Excel, a file is also known as a workbook.

a)

File

b)

Fill down

c)

Formula

d)

Grid

21.

A feature that allows you to copy information in an active cell to another cell or range of cells you have selected vertically.

a)

Fill down

b)

Formula

c)

Workbook

d)

Fill right

22.

A combination of numbers and symbols used to express a calculation. Always begins with a = sign.

a)

Formula

b)

Formula bar

c)

Autosum

d)

Average

23.

A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.

a)

Formula bar

b)

Function

c)

Heading

d)

Label

24.

A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.

a)

Function

b)

Fill right

c)

Row

d)

Column

25.

The identifying letters and numbers for columns and rows. Columns are identified with letters and rows with numbers.

a)

Headings

b)

Labels

c)

Rows

d)

Columns

26.

The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!

a)

Label

b)

Function

c)

Row

d)

Cell grid

27.

In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.

a)

Rows

b)

Columns

c)

Labels

d)

Headings

28.

A feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally.

a)

Fill right

b)

Fill down

c)

Formula

d)

Field

29.

An Excel file that contains individual worksheets. Also called a spreadsheet file or file.

a)

Workbook

b)

Sheet

c)

Sheet tab

d)

Formula

30.

Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. Each represents a worksheet within the workbook.

a)

Sheet tabs

b)

Workbook

c)

File

d)

Formula