Spreadsheet Applications - Chapter 4 Flashcards
What is a worksheet ?
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.
What is a formula ?
A mathematical equation or an expression that is used to define how a particular cell is linked to other cells in a worksheet.
What is a spreadsheet ?
A spreadsheet contains one or more worksheets they are designed to allow applications to perform calculations and recalculations automatically
What is a cell
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 do u add a range of cells together
=SUM(A1:A10) this will add together the contents of all the cells between A1 and A10
How do u find the average of a range of cells ?
=AVERAGE(A1:A10) this will find the average of all the cells from A1 to A10
How do you find the highest value in this range of cells ?
MAX(A1:A10) this will find the highest value out of the cells A1 to A10
How do you find the lowest value in a range of cells ?
MIN(A1:A10) this will find the lowest value out of the cells A1 to A10
What is conditional formatting ?
Conditional formatting is used to change the appearance (colour/shade etc.), or the formatting of a cell based on certain conditions
What is a template ?
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.
What is meant by Importing data ?
Allows data produced in another software application, such as data from a database package, to be used in a spreadsheet.
What is the IF statement
IF ( condition, true, false )
What is the Vlookup function ?
• 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.
What are relative cell references
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.
What are absolute cell references ?
Absolute cell reference - when a formula is copied to other cells, past of the cell reference does not change as the formula is modified.