ICT working with excel and using codes and enquiries 3.0 / 5 based on 1 rating ? ICTData and InformationIGCSECIE Created by: corin mccarthyCreated on: 28-03-13 10:08 to add up a range of values SUM 1 of 12 to find the average of a range of values AVERAGE 2 of 12 to find the smallest (minimum) value in a range of values MIN 3 of 12 to find the largest (maximum) value in a range of values MAX 4 of 12 to count the number of numeric values in a range of values COUNT 5 of 12 to count the number of items (text or numbers) in a range of values COUNTA 6 of 12 to find the whole partof a number - the integer part INT 7 of 12 to find the nearest whole number to a numeric value - rounding it up or down ROUND 8 of 12 to find the meaning of a particular value. It does this by 'looking up' the value in a lookup table VLOOKUP 9 of 12 to count the number of specific values in a range of cells COUNTIF 10 of 12 to add up values in a range of cells when cells in another, parallel range match a given specific criteria SUMIF 11 of 12 to make choices or decisions about what will appearin a cell IF 12 of 12
Comments
No comments have yet been made