Creating & Editing
11 free practice questions with explanations
PassNova has 11 free Digital Skills Level 2 practice questions on Creating & Editing, each with a clear explanation. Practise them in the browser with instant feedback — 100% free, no sign-up, on any device. Updated for 2026.
Creating & Editing: example questions & answers
11 worked examples with answers and explanations below. Practise them in the browser with instant feedback on every answer.
In a spreadsheet, what does the formula =SUM(A1:A5) do?
- AAdds the values in cells A1 to A5✓
- BCounts the words
- CDeletes the cells
- DSorts the cells
Answer: =SUM(A1:A5) adds together the numbers in cells A1 through A5.
In a spreadsheet, what does =AVERAGE(B1:B10) calculate?
- AThe total
- BThe mean (average) of B1 to B10✓
- CThe largest value
- DThe number of cells
Answer: =AVERAGE(B1:B10) works out the mean of the values in that range.
Which spreadsheet symbol starts a formula?
- A#
- B=✓
- C@
- D&
Answer: Spreadsheet formulas begin with an equals sign, e.g. =A1+B1.
Which chart is best to show how a total is split into parts?
- APie chart✓
- BLine chart
- CScatter chart
- DGantt chart
Answer: A pie chart shows proportions — how a whole is divided into parts.
In a document, which feature applies the same heading style throughout?
- AStyles / heading styles✓
- BSpell check
- CPrint preview
- DWord count
Answer: Applying heading styles keeps formatting consistent and lets you build a contents list.
What does 'mail merge' let you do?
- ASend one personalised letter to many people automatically✓
- BDelete all your emails
- CMerge two photos
- DBlock spam
Answer: Mail merge combines a template with a list of names/addresses to create many personalised documents.
What is the quickest way to copy text you have selected?
- ACtrl + C, then Ctrl + V to paste✓
- BDelete it
- CPrint it
- DSave the file
Answer: Ctrl + C copies the selection and Ctrl + V pastes it.
Before printing a long document, it is good practice to use:
- APrint preview✓
- BSpell check only
- CThe recycle bin
- DA backup
Answer: Print preview lets you check the layout and page count before wasting paper.
Which shortcut usually UNDOES your last action?
- ACtrl + Z✓
- BCtrl + P
- CCtrl + S
- DCtrl + A
Answer: Ctrl + Z undoes the last action; Ctrl + S saves, Ctrl + P prints, Ctrl + A selects all.
A spreadsheet cell reference 'C4' means:
- AColumn C, row 4✓
- BRow C, column 4
- CThe fourth file
- DA formula error
Answer: Cell references give the column letter then the row number, so C4 is column C, row 4.
Which is an advantage of saving work as a PDF before sending it?
- AThe layout stays fixed and can't easily be changed✓
- BIt becomes editable by anyone
- CIt deletes itself
- DIt can't be opened
Answer: A PDF keeps the formatting fixed across devices and is harder for others to alter.