Spreadsheets Level 2

If a cell is displaying the contents ####, what does this mean?

• No value is available

• A name is being used that is not recognised

• The cell contents are too large to display in the cell

• The spreadsheet is telling you there is an error in the calculation

Which function is used to decide whether a condition is true or false?

• MAX function

• COUNT function

• IF Function

• MIN function

Which character appears around a cell reference to make it absolute?

• The £ symbol

• The $ symbol

• The * symbol

• The % symbol

Which Paste feature allows you to specify what values you want to paste into a cell, eg values, formulas, formats?

• Paste Special

• Paste

• Paste Link

• Paste All

What format feature is used to make certain cells stand out depending on a specific rule?

• Unconditional formatting

• Specified formatting

• Selective formatting

• Conditional formatting

What does the Letters CSV in a file extension stand for?

• Conditional Sheet View

• Comma Separated Values

• Completed Spreadsheet Version

• Common Standard View

How do you import a CSV file into a spreadsheet?

• Find the file and copy and paste it into a spreadsheet

• Click on data, then advanced

• Click on Data then text into columns

• Click on Data Tab, then from text, find the file you require then click on import

How would you apply a filter to a spreadsheet?

• Apply conditional formatting

• Hide the columns

• Click on sort and filter, then filter on the Home ribbon

• Hide the rows

How do you name a worksheet within a workbook?

• Save it with a different name

• Double Click on the Sheet tab at the bottom and enter the text

• Click on insert, then sheet

• Click on view headings