Chapter 4: Spreadsheets 0.0 / 5 ? ICTSpreadsheets and DatabasesGCSECCEA Created by: emoutray800Created on: 06-12-19 11:54 Spreadsheets Contains one or more worksheets. It is used to create/manipulate data. It can also preform calaculations. 1 of 7 Conditional Formatting This is where a cell’s value dictates what happens to the styling (border, shading, background, etc) of a cell 2 of 7 Data Validation Ensure data being entered is suitable, a certain data type is entered, if invalid data is inputted, an error message is displayed. 3 of 7 Vlookup Looks at a value in a table and returns a specific value from a specified column in the same row. 4 of 7 Examples of Data Types Number, Currency, Percentage, Date 5 of 7 Absolute Cell Referencing cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed 6 of 7 Cell The intersetion of a row & a column. 7 of 7
EdExcel IGCSE - Application & Effects & The Social Impact of ICT 5.0 / 5 based on 1 rating Teacher recommended
Comments
No comments have yet been made