MOD3/4 Topic Test - Using Spreadsheets - Cam Nationals in IT

A rectangular area formed by the intersection of a column and a row

• Cell

• Relative Cell Reference

• Column

• Worksheet

What does the icons highlighted in the red box control?

• Change font type (family)

• Wrap text onto multiple lines

• Add font emphasis (bold italic underline)

• Change cell alignment (position)

What does the icon in the highlighted red box control?

• Change font size (measured in points)

• Add cell boarders (type, style, thickness)

• Merge cells and centre contents

• Change data type into currency

Data is raw ...... and figures before they have been processed

Validation is ensuring that only the ..... data is stored

What data type are whole numbers e.g. 17 or 331?

• Boolean

• Currency

• Integer

• Real

What data type are true or false values e.g. Y or N?

• Boolean

• Text

• Integer

• Real

What are the methods that you can use for validation in spreadsheets (select two)

• Tick lists and radio buttons

• Conditional formatting

• Absolute cell references

• Drop down lists

Which is the correct symbol for division in a spreadsheet formula?

• +

• *

• /

• &

Replication is where you .... data in cells using the fill handle and spreadsheets try to recognise and copy patterns