Chapter 4 - Spreadsheet applications Flashcards
What is a worksheet ?
A grid in the form of rows and columns. Spreadsheets are made up of a number of these
What are formula ?
Math equation that is used to link two or more cells
What is conditional formatting ?
allows cells to be shaded a particular colour if a specific criteria is met
What is a template ?
a redefined document containing the main elements of the document it represents e.g budget template
Can you import data into a spreadsheet and if so whats the most common format the data has to be in ?
yes and CSV (comma separated value)
What are headers and footers used for ?
to improve the presentation of the document
What is a function ?
Part of the software app that preforms a specific task and returns a value
what do formulas and functions allow the spreadsheet to do ?
to preform calculations and automatic recalculations
What is the Vlookup function used for ?
uses the value in a selected cell to ‘lookup’ a match in a column of a lookup table
What is a relative cell reference ?
Changes a formula’s cell reference to refer to the next cells
What is an absolute cell reference ?
the cell reference does not change as the formula is modified
can macros be used in spreadsheets ?
yes
What is data modelling ?
uses mathematical formulas and calculations on data to predict outcomes for situations
How are spreadsheets used for data modelling ?
they can be used by companies to make better informed decisions
