Across
- 1. Operators that specify the calculations to be performed.
- 4. Pre-set settings that determine how Excel behaves when performing an action.
- 7. A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
- 8. An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
- 9. A file that includes formatting and formulas complete with designs, tools, and specific data types.
- 10. A group of cells, and occasionally a single cell, with a designated name.
Down
- 2. A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
- 3. A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
- 5. A reference that identifies a cell’s location in the worksheet based on its row number and column letter.
- 6. Commands on the default ribbon tabs that are related in functionality.