Spreadsheets Flashcards
What are the five main components of a Spreadsheet?
Worksheet, cell, active cell, row and column.
What is the definition of a Worksheet?
One page or tab of a workbook or spreadsheet.
What Spreadsheet Component is one page or tab of a workbook or spreadsheet?
A Worksheet
What is the definition of a Cell?
A square on a Spreadsheet.
What Spreadsheet Component is a square on a Spreadsheet?
A Cell
What is the definition of an Active Cell?
The square or ‘cell’ you are currently working in on a spreadsheet.
What Spreadsheet Component is the square or ‘cell’ you are currently working in on a spreadsheet?
The Active Cell
What symbol is used to divide in Spreadsheets?
/
What Symbol is used to multiply in Spreadsheets?
*
What does this formula do?
=SUM(D3:D99)
It adds up all the amounts in cells 3-99.
What does this formula do?
=AVERAGE(D3:D99)
It adds up all the totals in cells 3-99 and then divides it by the number of cells. (Finds the Average)
What do all formula and functions start with?
=
What should a chart or graph always have? (4 things)
Title
Legend or key
Axis labels
Units (if required)
