Creating & Editing

In a spreadsheet, what does the formula =SUM(A1:A5) do?

• ACounts the words in each highlighted cell
• BSorts cells A1 to A5 alphabetically
• CRemoves the contents of cells A1:A5
• DAdds the values in cells A1 to A5✓

Answer: =SUM(A1:A5) adds together the numbers in cells A1 through A5.

In a spreadsheet, what does =AVERAGE(B1:B10) calculate?

• AThe sum of the values in the range
• BThe largest value (the maximum)
• CThe number of cells with text or numbers
• DThe mean (average) of B1 to B10✓

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?

• AScatter chart
• BGantt chart
• CPie chart✓
• DLine 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?

• AThe zoom control
• BCheck spelling as you type
• CPrint preview (page layout view)
• DStyles / heading styles✓

Answer: Applying heading styles keeps formatting consistent and lets you build a contents list.

What does 'mail merge' let you do?

• ADelete old emails from your inbox in one go
• BBlock spam or junk mail before it reaches you
• CJoin two photographs together into one picture
• DSend one personalised letter to many people automatically✓

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?

• AType the whole text out again by hand yourself
• BHighlight the text and press Ctrl + P to print
• CCtrl + C, then Ctrl + V to paste✓
• DSave the file and then close the program down

Answer: Ctrl + C copies the selection and Ctrl + V pastes it.

Before printing a long document, it is good practice to use:

• AThe recycle bin
• BPrint preview✓
• CSpell check only
• DA backup

Answer: Print preview lets you check the layout and page count before wasting paper.

Which shortcut usually UNDOES your last action?

• ACtrl + A
• BCtrl + S
• CCtrl + P
• DCtrl + Z✓

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
• CA formula error
• DThe fourth file

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?

• AIt locks or encrypts the file automatically
• BThe layout stays fixed and can't easily be changed✓
• CThe person receiving it can edit the text like a Word file
• DIt saves the document straight into the cloud for you

Answer: A PDF keeps the formatting fixed across devices and is harder for others to alter.