Spreadsheet Applications - Chapter 4 Flashcards

1
Q

What is a worksheet ?

A

A grid in the form of rows and columns a spreadsheet is made up of a number of worksheets and each worksheet can be given a different name as a reference point.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a formula ?

A

A mathematical equation or an expression that is used to define how a particular cell is linked to other cells in a worksheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a spreadsheet ?

A

A spreadsheet contains one or more worksheets they are designed to allow applications to perform calculations and recalculations automatically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a cell

A

A cell is part of a spreadsheet which can store data in a variety of forms for example text, number, formula and so on.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do u add a range of cells together

A

=SUM(A1:A10) this will add together the contents of all the cells between A1 and A10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How do u find the average of a range of cells ?

A

=AVERAGE(A1:A10) this will find the average of all the cells from A1 to A10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How do you find the highest value in this range of cells ?

A

MAX(A1:A10) this will find the highest value out of the cells A1 to A10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

MIN(A1:A10) this will find the lowest value out of the cells A1 to A10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is conditional formatting ?

A

Conditional formatting is used to change the appearance (colour/shade etc.), or the formatting of a cell based on certain conditions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a template ?

A

A predefined layout containing the main elements of the document it represents ; the contents and layout of the template can be edited to suit the the needs of a specific user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is meant by Importing data ?

A

Allows data produced in another software application, such as data from a database package, to be used in a spreadsheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the IF statement

A

IF ( condition, true, false )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the Vlookup function ?

A

• This function uses the value in a selected cell to “lookup” a match in a column of a look table (vertical lookup)
• It returns the value from a specified column from the same row of the look-up table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are relative cell references

A

Relative cell reference - changes a formulas cell references to refer to the next cell (s) when the formula is copied down a column or across and row.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are absolute cell references ?

A

Absolute cell reference - when a formula is copied to other cells, past of the cell reference does not change as the formula is modified.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a macro

A

A small program written to perform repetitive tasks automatically

17
Q

What is the purpose of using charts to display results ?

A
  • can assist in the communication of information.
  • a range of charts can be used such as bar charts, pie charts and so on.
18
Q

What is data modelling ?

A

Data modelling uses mathematical formulas and calculations on data to help predict outcomes for given situations.