ICT- Spreadsheets Flashcards

Pregunta	Respuesta
State one benefit of using Spreadsheets	-Spreadsheet can automatically recalculate sums if one cell has changed in value
What is the difference between data and information?	-Data- meaningless information e.g. 50 -Information- meaningful e.g. £50
Do spreadsheets store data or information?	-Spreadsheets store the data before it is processed but once it is formatted it turns into information.
What is a function?	-A specialised calculation.
Give an example of a function	e.g. =SUM (E3:P3)
Give 3 examples of ways you can format data in a spreadsheet	1) Currency 2) Percentage 3)Text
Give 2 ways you can format the whole spreadsheet	1) Cell Merging (putting 2 or more cells together) 2) Borders
What are labels?	-Titles and Headings
=MAX(A4:H4) What does this formula calculate	-Its calculates the highest (maximum) number within the given cells.
Give another advantage of using Spreadsheets	-Easy to produce graphs and charts after all the data has been inputted.
What are the 3 functions in a Spreadsheet?	1) Labels- titles 2) Data- the values 3) Formulas
What are formulas used for in a Spreadsheet?	-Formulas are used to perform calculations, used as an easier way of working out answers.

Resumen del Recurso

	Creado por Charlotte Adams hace más de 9 años