Flashcards
Spreadsheets
Cards in this deck (4)
- 1=VLOOKUPStands for vertical look up, in a table looks for a variable and returns what's in that column
- 2=SUMAdds together the specified
cells
- 3=SUMPRODUCTAdds together all columns from the specified cells then multiplies the sums to those of the specified columns adjacent
- 4=IFIf the specified cell equals specified requirements, display x and if it doesn't meet the requirements, display y
Information
- Description
- Key Stage 3 Computing Flashcards on Spreadsheets, created by Zoe Chaffer on 03/06/2022.
- Created by
- Zoe Chaffer · Jun 2022
- Updated
- Jun 3, 2022
- Views
- 0
- Rating