Chapter 6 : Excel

Question 1

What are the advantages of sorting data as a table?

Answer 1

• It makes it easier to sort and search.
• You can use formatting to pick out important facts
• You can use formulas to calculate new information

Question 2

What are fields?

Answer 2

The colums of a table. Each field stores one piece of data.

Question 3

What are records?

Answer 3

The rows of a table. Each record stores all the data about one thing.

Question 4

What is a key field?

Answer 4

A key field stores data that is unique.

Question 5

What is the formula to sum a range of values?

Answer 5

=SUM(A1:A12)

Question 6

What is conditional formatting?

Answer 6

A spreadsheet format, such as cell colour, that is based on a logical test.

Question 7

What does summary data mean?

Answer 7

A result calculated from a group of figures.

Question 8

What are cell references?

Answer 8

Every cell in a spreadsheet table is identified by a letter and a number. If you enter the cell reference into a formula, the computer will take that data stored and use it in the calculation.

Question 9

What are abseloute cell references?

Answer 9

A cell reference that does not change when it is moved or copied to a new location in a spreadsheet table. You add a $ symbol to a cell reference to stop it from changing.

Question 10

What is the formula to find the average?

Answer 10

=AVERAGE(A1:A12)

Question 11

What goes inside of the IF formula?

Answer 11

• A logical test
• The output if the test is true
• The output if the test is false.

Question 12

What is the IF formula?

Answer 12

=IF(A1>A12, “TRUE”,”FALSE”)