spreadsheets

Question 1

What is a spreadsheet?

Answer 1

A spreadsheet is a type of software application (app) that stores
information in tables.

Question 2

What are the uses of spreadsheets?

Answer 2

• To Store information.
• To Sort, filter and make calculations
• To Draw charts

Question 3

Why do people use spreadsheets?

Answer 3

Using spreadsheets makes storing data quicker, easier and more accurate.

Question 4

What are the 2 criteria of rows?

Answer 4

Rows are:
● Left to right
● Labelled with a number

Question 5

What are the 2 criteria of columns?

Answer 5

Columns are:
● Top to bottom
● Labelled with a letter

Question 6

What is a Cell Reference?

Answer 6

a cell reference is also known as the name of the cell. A cell reference is made up of the column(letter) and row(number).

Question 7

What is data?

Answer 7

‘Data’ is the name for facts
and figures.

Question 8

How can you organize data in a spreadsheet?

Answer 8

you can organize data in a structured format called ‘data table’ in spreadsheets

Question 9

Data does not mean much unless you know how to ___.

Answer 9

Data does not mean much unless you know how to sort, format and analyse the data.

Question 10

The heading of the column is the ___.

Answer 10

The heading of the column is the field name.

Question 11

What is the difference between a field and a field name?

Answer 11

A field name only stores one fact and explains what data is in the field.

Question 12

What is the difference between a record and a row?

Answer 12

A record has several fields and stores all the data about one thing, event or person.

Question 13

What is a primary key?

Answer 13

A primary key is a field that that uniquely identifies the item. A primary key has a different value in each record.

Question 14

What are four ways you can sort a data table?

Answer 14

1. Alphabetical order
2. Numerical order
3. Ascending
4. Descending

Question 15

What is filtering?

Answer 15

When you filter a data table, the spreadsheet will only show records that match your filter criteria. Other records are hidden.

Question 16

What is data validation?

Answer 16

Validation is a type of data check. You decide on rules called validation criteria.
If data and criteria are not matched, the data is wrong.

Question 17

Why is checking data important ?

Answer 17

Data accuracy is important because wrong data can cause big problems. Wrong data can be difficult to find if there is a lot of data. So, software apps have data checks.

Question 18

What makes list validation efficient?

Answer 18

List validation makes data input simpler so the user does not need to type data, instead they choose the right value from a list.

Question 19

What are the advantages of list validation?

Answer 19

The advantages of list validation are:
● Choosing from a list can be quicker than typing.
● There is less chance of making mistakes.
● The data is consistent.

Question 20

What is a formula?

Answer 20

A formula is a mathematical calculation in spreadsheets that uses
arithmetic operators to calculate results.

In spreadsheets, the formula must start with an equal sign(=).