F1 ICT 2324 Spreadsheet formula and functions Ex1

Which of the following is not a popular spreadsheet software?

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

What kind of software are spreadsheets?

• Modelling
• Graphics
• Database
• Calculator

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

• Columns
• Fields
• Records
• Blocks

G5 is an example of a?

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

Cells can contain numeric values, formulas or? 

• Text Strings
• Text Values
• Letter Variables
• Word Values

SUM, IF, COUNTIF, AVERAGE & RANK 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)

To show only data that matches specific criteria use a?

• Filter
• Sort
• Validation
• Functiob

Putting cells into A-Z order is called?

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