Flashcards
Topic 10- Spreadsheets flashcards
Cards in this deck (5)
- 1Explain what the use of what if calculation'What if?' calculations allow you to use the spreadsheet to see what would happen if you changed certain figures in the spreadsheet. They are used to predict outcomes.
- 2Choose the best type of chart for: A) Comparing number of boys + girls present in a school each day of the week B)Comparing the number of calories of five different foods C) Showing attendance at a night club every Saturday for eight weeks to show the attendance trendA) Bar
B) Pie
C) Line - 3Explain what is meant by: A) Labels B) Data C) FormulaA) A label is used for titles, headings, names, and for identifying columns or rows of data
B) Data are the values that you enter into the spreadsheet
C) Formulas are used to perform calculations on the cell contents - 4Name the two types of cell referenceAbsolute and Relative
- 5Explain the meaning of the following mathematical operators: / + * -Division
Addition
Multiplication
Subtraction
Information
- Description
- Flashcards on Topic 10- Spreadsheets flashcards, created by Ellie Collins on 05/03/2015.
- Created by
- Ellie Collins
- Views
- 0
- Rating