2024 UPDATED Excel EXAM
preadsheet A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns. Row Horizontal line of cells Cell A Box that holds data Column A vertical line of cells Cell Address The column and the row number of a cell, e.g. C13; F27; Formula Bar the cell that one enters numbers, a formula or text + (the Plus Sign) In Excel it means Add - (The minus sign) In an Excel Formula, it means subtract. / (the Forwardslash) in a formula in Excel it means Divide * (the asterisk) (Shift the number 8 key) in a formula it means multiply : (the colon) Range operator: Means inclusive; including all the cells. For Example; B3:B37 means b3,b4, b5,...to b37 =SUM(A12+A13) Adding two cells =SUM(__ ___ ) the basic formula for most computations Range 2 or more cells that are selected to create a source to be used in a formula
Geschreven voor
- Instelling
- Excel Ohio pre licensing
- Vak
- Excel Ohio pre licensing
Documentinformatie
- Geüpload op
- 25 januari 2024
- Aantal pagina's
- 10
- Geschreven in
- 2023/2024
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
excel
-
questions
-
answers
-
2024