Spreadsheet software Flashcards
What are spreadsheets designed for
Spreadsheets are designed to help the user with numerical tasks
What are spreed sheets used for
Spreadsheets are used to store information and data
Once you have your information in the spreadsheet what can it run
Powerful calculations
Make graphs and charts
Analyse patterns
Name some spreadsheets programs
Microsoft office
Google docs
OpenOffice
What is a spreadsheet file made of
It is made of one workbook and multiple worksheets, worksheets appear as tabs at the bottom
What do cell reference consist of and refer to
They consists a letter and a number. The letter refers to the column and the number refers to the row.
How do you select a cell
Left click on it
How do you enter data
Double click it
What are the three types of data you can enter into a cell and what are they
The three types of data you can enter into a cell are data, labels and formulas.
Data – values, usually numbers but can be letters or a combination of both.
Labels – headings and descriptions to make the spreadsheet easier to understand.
Formulas – calculations that update automatically if referenced data changes.
How do you adjust a Columns width or a rows height
To adjust a column’s width or a row’s height, move your mouse cursor between two columns or rows. Click and drag to resize.
To automatically resize a row to fit the data entered in a cell, double-click between the current row and the row after it.
What is wrap text
If the text in a cell exceeds the space available, wrap text will resize the cell so it fits.
What are formulas
Formulas are usually simple calculations, eg adding two or more numbers together. They always start with an equals sign (=).
What are the symbols used in formulas
There are a number of symbols used in formulas or calculations. These are the most common ones:
‘+’ add
‘-’ subtract
‘*’ multiply
‘/’ divide
What are functions
Functions make more complex calculations. Simple and regularly used functions include:
SUM – adds values in selected cells
MIN – finds smallest value
MAX – finds largest value
AVERAGE – finds the average value
COUNT – counts how many of the selected cells have numbers in them
Like formulas, all functions start with an equals sign (=) followed by the function’s name, eg SUM, MIN, MAX, etc.
