VAS Spreadsheets Assessment

A range of cells which goes vertically down the worksheet is known as...

• Range
• Column
• Row 
• Table

An individual box within a worksheet is known as?

• square
• range
• refernce
• cell

Data in a spreadsheet table can be sorted by single or multiple columns and alphabetically and numerically

• True
• False

What is normally used to perform calculations in a spreadsheet?

• Variable
• Formula
• Conditional formating
• Macro

When you key a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equal Sign
• Addition sign
• Division sign

A1:D4 is an example of a cell...

• Range
• Selection
• Highlight
• Choice

Putting cells into A-Z order is called?

• Sort Ascending
• Sort Descending
• Filter Ascending
• Filter Descending

Which of the following is a valid formula?

• =C7*C8
• =(C7\C8)
• =(C7xC8)
• =AVERAGE(C7*C8)

G5 is an example of a?

• Relative Cell Reference
• Cell Coordinate
• Absolute Cell Reference
• Cell Specification

You can present your data graphically, using a 

• chart
• print
• font
• sort