Flashcards
Spreadsheets
Flashcards do conjunto (24)
- 1FormattingIn spreadsheet format is to change into the a certain way.
- 2Count functionCount function is a function to only count the numbers in the cells selected.
- 3Example of count if cells selected are A1:A20=COUNT(A1:A20)
- 4CountA functionCountA function is a function that counts numbers and texts within the selected cells.
- 5Example of CountA cells selected are S2:A27= CountA(A2:A27)
- 6Count blank functionCount blank function is to count the amount of blank cells within the cells selected.
- 7Example of Count Blank if cells selected are A2:A27.=COUNTBLANK(A2:A27)
- 8Count IfThis function counts the number of cells that meet a set criteria.
- 9CountIF example of cells are F1:F30. First count the cells for the word Foul, then count the cells numbers less than A1.= COUNTIF(F1:F30,"Foul")
= COUNTIF(F1:F30," - 10SUM function, with example.This function is used to add the values in cells. e.g = SUM(A1:A22)
- 11Average function with example.The average function is to find the average of the values in the cells. E.G -
= AVERAGE(A1:A22) - 12MIN and MAX function, with exampleThe MIN function is used to find the minimum of certain cells, and for MAX function its to find the maximum. E.g -
= MIN(A1:A21), and = MAX(A1:A22) - 13VLOOKUP function, examplesVlookup is to find out a certain value in a vertical laid out table.
=VLOOKUP(what you want to lookup, the table you want to look in, which column you want to return, true or false) - 14E.G of VLOOKUP if A4 is what you're e going to lookup, the table is E4:F10, and the column is 2. You also only want to find you the exact amount.(A4:H1:J5,2,false)
- 15What is FALSE and TRUE in VLOOKUP and HLOOKUP.False means you want to find out the exact match, and True means you want to find out the closest match.
- 16HLOOKUPHlookup is to find out a certain value in a horizontally laid out table.
=HLOOKUP(what you want to lookup, the table you want to look in, which row you want to return, true or false) - 17VLOOKUP example if what you want to lookup goes into A4, the table is E4:F10, the column number is 2, and you want to find the exact match.=VLOOKUP(A4,E4:F10,2,False)
- 18What does False and True mean in VLOOKUP and HLOOKUP.False means that you want to find the exact match, whilst true means true means you want to find the closest match.
- 19HLOOKUPHlookup is to find out a certain value in a horizontally laid out table.
=HLOOKUP(what you want to lookup, the table you want to look in, which row you want to return, true or false) - 20HLOOKUP example if what you want to lookup goes into A4, the table is E4:F10, the row number is 5`, and you want to find the closest match.=HLOOKUP(A4,E4:F10,5,True)
- 21IF statementsAn IF statement check to see if a statement is true or false and then does one of two things depending on the result.
- 22IF function lay out.=IF(Comparison, true value, false value)
=IF(A1>=75,"Pass","Fail") - 23IF statement rulesIf you want to use text you must put them in quotation marks, but if it is for a cell or a number you do not.
- 24Example of IF statements=IF(A>=75,"Pass",'Fail")
= If(A1>=F4,D5,D6)
= IF(A7=F1,"True", "False")
Informações
- Descrição
- ICT (Year 9) FlashCards sobre Spreadsheets, criado por Baited Man em 28-11-2020.
- Criado por
- Baited Man
- Visualizações
- 0
- Avaliação