Spreadsheet Introduction

Which of the following is not a popular spreadsheet software?

• MS Excel
• Google Sheets
• Google Spreads
• Open Office Calc

A spreadsheet is made of cells organised into horizontal rows and vertical?

• Columns
• Fields
• Records
• Blocks

SUM, IF, COUNTIF, AVERAGE & VLOOKUP are all examples of?

• Functions
• Formulas
• Filters
• Validations

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1,A6)

Which of the following is a valid formula?

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

Putting cells into A-Z order is called?

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

A feature to make data fit inside a cell?

• Wrap Text
• Warp Text
• Conditional Formatting
• Filter Text

To show the quantities in particular categories use a?

• Column Chart
• Line Graph
• Scatter Graph
• Sort Chart

Column charts should always include?

• Title, Axis Labels & Correct Scale
• Title, Legend, Correct Scale
• Axis Labels & Legend
• Correct Scale, Colours & Title

Which chart should you use to show changes over time?

• Line
• Scatter
• Pie
• Bar