Chapter Four

Question 1

What is a spreadsheet

Answer 1

its one or more worksheets. Its presented in a grid in the form of rows and columns. this allows applications to perform calculations and recalculations quickly

Question 2

what are cells

Answer 2

cells store data in a variety of forms and can be formatted. for example numbers, dates or currency

Question 3

what is a formula

Answer 3

a mathematical expression that’s used to define a particular cell is linked to other cells in a worksheet

Question 4

what does =A1+B1mean

Answer 4

adding the content

Question 5

What does =D1-C1 mean

Answer 5

subtracting the content

Question 6

what does =A2*B2 mean

Answer 6

multiplying the content

Question 7

what does =A3/A4 mean

Answer 7

dividing content

Question 8

how do you find the auto sum of cells

Answer 8

=SUM(A1:A10)

Question 9

How do you find the avg or cells

Answer 9

=AVERAGE(A1:A10)

Question 10

How do you find the highest value of a range of cells

Answer 10

=MAX(A1:A10)

Question 11

How do you find the lowest value of a range of cells

Answer 11

=MIN(A1:A10)

Question 12

What’s conditioning format

Answer 12

its used to change the appearance or format of cells. this would be used if a teacher used a spreadsheet to record test results and they wanted every score over 60 to go green and every score below go red

Question 13

what is a template

Answer 13

it refers to a document that has been performed using a predetermined layout for the user

Question 14

what is importing data

Answer 14

data that can be imported into a spreadsheet from other software sources such as a database

Question 15

what are headers and footers

Answer 15

this improves the presentation of worksheets. headers are placed at the top. footers are placed at the bottom. you can add titles, names and page numbers to these.

Question 16

what is the if statement equation

Answer 16

=IF(CONDITION,TRUE,FALSE)

Question 17

What does the VLOOKUP function do

Answer 17

it uses the value in a selected cell to look up a match in a column of a look table. it returns the value from a specified column from the same row of the look up table

Question 18

what’s a relative cell reference

Answer 18

it adjusts and changes the formula and makes sure it refers to the to the correct cell

Question 19

what’s an absolute cell reference

Answer 19

when you want a cell reference in a formula to always stay the same so when you copy or drag the formula the cell reference doesn’t change.

Question 20

how is using charts helpful

Answer 20

can assist in the communication of info when an organisations doing a presentation for clients. there are three different types of charts: bar, line and pie.

Question 21

what is a macro

Answer 21

a small program written to preform a repetitive task automatically.

It can eliminate the need for the user to repeat steps of common preformed tasks.

Question 22

what is data modelling

Answer 22

this uses mathematical formulas on data to help predict outcomes for given situations