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
Document information
- Uploaded on
- January 25, 2024
- Number of pages
- 10
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers