Spreadsheet For A Purpose Flashcards
What is a spreadsheet?
A document that has columns and rows which are used to calculate numbers and organise information.
What are the two spreadsheet applications?
Google Sheets and MS Excel.
What is a worksheet?
The page of a spreadsheet you are working on.
What is a row?
Cells that go across the spreadsheet.
What is a column?
Cells that go down the spreadsheet.
What is a cell?
An individual spreadsheet box where you enter data.
What is an active cell?
The cell you are currently using.
What is a label?
Text used to describe certain values, the text in an individual cell, data.
What is a value?
Numbers that are entered into an individual cell.
What is a formula?
An equation that makes calculations based on your data.
What is a function?
Predefined formulas that preform calculations using data from your spreadsheet. They need keywords such as sum, average, min, max.
What is a function?
Predefined formulas that preform calculations using data from your spreadsheet. They need keywords such as sum, average, min, max.
What is a fill handle?
A feature to extend and fill a series of numbers, dates, and text to a desired number of cells.
What is an absolute reference?
It refers to a reference that is locked so that rows and columns won’t change when copied.
What is a model?
A system where you can change data to see what happens.
Effects used to move from one slide to another.
Transition.
A tool that displays the list of animated objects on your slide.
Animation pane.
What is the formula if you want to get the data today
=Today( )
A row that is named by a number.
Row heading.
It is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells.
Fill handle.
a name of an individual cell.
Cell reference.
Allows you to move to another worksheet.
Navigation button.
Use of mathematical symbols to calculate numbers in a spreadsheet.
Formulas.
It refers to a reference that is “locked” so that rows and columns won’t change when copied.
Absolute reference.
