Mock-up of a spreadsheet layout

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A spreadsheet mock-up is drawn before the spreadsheet is built to show how it will look.

A False

B True

2. Which item belongs in a spreadsheet mock-up?

A Header labels such as 'Student' and 'Score' above the columns

B The finished formulas typed into every cell

3. Where should a mock-up show the result cell for a total of the Score column?

A In a clearly labelled cell, such as 'Total' below the Score data

B Hidden somewhere off-screen with no label

4. Which is a good use of formatting in a mock-up?

A Bold header labels and a dollar format on price columns

B Leaving all cells unformatted and unlabelled

5. Which header labels clearly describe a table of sales data?

A Column 1, Column 2, Column 3

B Product, Quantity, Unit Price

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Sheet tab: Sales Data		AThe result has no cell location, so the placement of results is missing. Mark a cell such as B12 and label it Total.
2Results cell: B12 = Total Sales		BA labelled result cell placed on the mock-up to show where the answer will appear
3Column headers in row 1 tell the user what each column of data holds		CA worksheet name written on the mock-up to show which sheet holds this part of the layout
4Formatting notes on a mock-up show how values will look, such as currency or bold headers		DThe mock-up has no header labels, so nobody can tell what each column of data means. Add labels such as Name and Mark in row 1.
5Row 1 is left blank, data starts at A2 with no labels		EFormat: C2:C20 as currency, headers bold
6Total result: (no cell shown on the mock-up)		FA1: Name \| B1: Year Level \| C1: Mark

Definitions

spreadsheet mock-up

Fill in the Blanks

Complete each line of code by filling in the missing parts.

_________: Budget Data area: A2:B9

Header row: __ = Item, B1 = Cost Data area: A2:B9

Data area: B2:B9 Total cell B10: =___(B2:B9)

Format row 1 as bold Format B2:B9 as ________

Data area: B2:B9 Result: =SUM(B2:B9) placed in ___

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Row 1: Apple | 2.50 | 4

B Rows 2-6: data entries

C Price column: format $0.00

Question 2

A Headers: A1:C1

B Data area: A1:C11

C Average result: C13

Question 3

A Sheet: Budget

B A1: Item, B1: Cost

C Data area: A2:B9

D A11: Total, B3: result

Question 4

A Sheet 1: Raw Data (A1:C20)

B Sheet 2: Summary

C Summary B2: Average of Sheet 3

Question 5

A Header row: bold, grey fill

B Dates in A2:A10: dd/mm/yyyy

C Prices in B2:B10: dd/mm/yyyy

D Total in B12: bold, $0.00

Answer Key

Mock-up of a spreadsheet layout

Section A: Quick Questions

B — True

A — Header labels such as 'Student' and 'Score' above the columns

A — In a clearly labelled cell, such as 'Total' below the Score data

A — Bold header labels and a dollar format on price columns

B — Product, Quantity, Unit Price

Section B: Match the Pairs

Sheet tab: Sales Data → A worksheet name written on the mock-up to show which sheet holds this part of the layout

Results cell: B12 = Total Sales → A labelled result cell placed on the mock-up to show where the answer will appear

Column headers in row 1 tell the user what each column of data holds → A1: Name | B1: Year Level | C1: Mark

Formatting notes on a mock-up show how values will look, such as currency or bold headers → Format: C2:C20 as currency, headers bold

Row 1 is left blank, data starts at A2 with no labels → The mock-up has no header labels, so nobody can tell what each column of data means. Add labels such as Name and Mark in row 1.

Total result: (no cell shown on the mock-up) → The result has no cell location, so the placement of results is missing. Mark a cell such as B12 and label it Total.

Section C: Definitions

spreadsheet mock-up — A sketch of a spreadsheet's worksheet names, header labels, data areas, formatting and result cells, drawn before building to show how it will look and where results will go.

Section D: Fill in the Blanks

Worksheet: Budget
Data area: A2:B9

Header row: A1 = Item, B1 = Cost
Data area: A2:B9

Data area: B2:B9
Total cell B10: =SUM(B2:B9)

Format row 1 as bold
Format B2:B9 as currency

Data area: B2:B9
Result: =SUM(B2:B9) placed in B10

Section E: Spot the Error

A — Row 1 of the mock-up should show header labels (Item, Price, Qty) so each column is named. Here it holds sample data values instead of labels.

B — The data area must start below the header labels. A1:C11 overlaps the header row in row 1. It should be A2:C11.

D — The result cell belongs beside its label (A11) and outside the data area. B3 sits inside the data area. It should be B11.

C — The mock-up only plans two worksheets, so the result cell cannot take its data from Sheet 3. It should refer to Sheet 1.

C — Formatting in a mock-up must suit the data. Prices need a currency format such as $0.00, not a date format.