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.
Automatically enters the appropriate formula or function into your spreadsheet.
Autosum.
A computer program that calculates numbers and organises information in columns and rows.
Spreadsheet.
it always begin with = sign, it is used to calculate numbers.
Formula.
Is the cell which you have currently selected.
Active cell.
Which bar allows us to view the unseen part of the MS Excel window
Scroll bar.
An expression which calculates the value of a cell.
Formula.
A number enter in an individual cell.
Value.
What is the shortcut in putting absolute reference?
Fnf4.
Lines that run horizontally.
Rows.
Lines that run vertically.
Columns.
