Flashcards
IT10-Spreadsheet software
Cards in this deck (13)
- 1What can a spreadsheet be used for?-carry out calculations
-ask 'what if?' calculations
-produce graphs and charts - 2What can a cell can contain?-text
-labels
-data
-formulas and functions - 3Where does the formula appear?the formula bar
=(B3*C3)+E4 - 4What functions can be used to carry out common calculations?-sum, =D4+D5+D6+D7, =SUM(D4:D7)
-average, =AVERAGE(B4:B10)
-if, =IF(A1>10, "PASS", "FAIL") - 5What can the content of a cell be formatted by?-font style
-size
-colour
-border style
-background colour - 6What data types can be used when formatting cells?-currency
-number
-real
-integer (whole number)
-date
-text - 7How do you make cells larger?by merging cells
- 8What are the types of cell referencing?-relative cell referencing
-absolute cell referencing - 9What are charts and graphs used for?-making information easier to understand
-making patterns and trends easier to see - 10What is a bar chart used for?-comparing different values
-the biggest bar or column shows the greatest value - 11What is a pie chart used for?-to show how a total is divided among a number of different categories
- 12What is a line graph used for?-to display the trend of sequences of values by using plotted points
- 13What are the benefits of using a spreadsheet?-automatic recalculation
-graphs and charts
-replication
-'what if?'
-formulas
'calculations
Information
- Description
- GCSE IT (IT Chapter 10) Flashcards on IT10-Spreadsheet software, created by jessicaexox on 08/03/2015.
- Created by
- jessicaexox
- Views
- 0
- Rating