NAME: ________________________

Microsoft Excel Terminology Test

Question Types


Start With


Question Limit

of 26 available terms

Upgrade to
remove ads

5 Written Questions

5 Matching Questions

  1. Functions
  2. Spreadsheet
  3. Output
  4. Absolute cell reference
  5. Order of precedence
  1. a The information the worksheet is designed to generate
  2. b The rules for determining how to perform calculations containing multiple arithmetical operators
  3. c Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location
  4. d A type of software for evaluating information
  5. e A prewritten formula that provides a shortcut to common calculations

5 Multiple Choice Questions

  1. A page in an Excel workbook
  2. Found directly above column headings; shows location in spreadsheet and what was typed in cell
  3. Data that is to be entered into a worksheet
  4. Tabs you use to select different sheets
  5. A single cell or any rectangular block of cells

5 True/False Questions

  1. Cell/active cellA special worksheet which contains a single chart only

          

  2. Relative cell referenceCell reference which changes according to the location of the cell in which the reference occurs

          

  3. FormulasAn arithmetical expression used to calculate values

          

  4. Data seriesA group of related data points

          

  5. Plot areaThe area defined by the X and Y axes of a chart

          

Create Set