Year 7 Spreadsheet FA

The table shows part of a spreadsheet file.

How many rows are shown in the spreadsheet?

(a)  

The table shows part of a spreadsheet file.

How many columns are shown in the spreadsheet?

(a)  

The table shows part of a spreadsheet file.

Give the cell reference that contains 124.

(a)  

The table shows part of a spreadsheet file.

Give the item that has the maximum profit per item.

• Mars Bar

• Twix

• M&Ms

• Bounty

The table shows part of a spreadsheet file.

Give the item that has the minimum number in stock.

• Mars Bar

• Twix

• M&Ms

• Bounty

The table shows part of a spreadsheet file.

Give the formula that would have been used in D4 to calculate the Profit per item.

• =C4-B4

• =B4-C4

• C4-B4

• =SUBTRACT(C4-B4)

The table shows part of a spreadsheet file.

Select all the columns that would be formatted as currency.

• B

• C

• D

• E

The table shows part of a spreadsheet file.

Select all the cell reference for a label.

• A1

• D2

• C5

• A5

The table shows part of a spreadsheet file.

Give the formula that would give the total Profit made for Twix.

• =A4*D4

• =E4*D4

• =E4+D4

• E4*D4

Label the parts of the excel interface that have the red plus signs.

g

f

e

d

c

b

a

Worksheets

Name Bar

Zoom Controls

Microsoft Account

Column

Formula Bar

Ribbon