BT Excel Vocab Review 3-4

12345678910
Across
  1. 1. Operators that specify the calculations to be performed.
  2. 4. Pre-set settings that determine how Excel behaves when performing an action.
  3. 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.
  4. 8. An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
  5. 9. A file that includes formatting and formulas complete with designs, tools, and specific data types.
  6. 10. A group of cells, and occasionally a single cell, with a designated name.
Down
  1. 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.
  2. 3. A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.
  3. 5. A reference that identifies a cell’s location in the worksheet based on its row number and column letter.
  4. 6. Commands on the default ribbon tabs that are related in functionality.