Microsoft Excel 2010

12345678910
Across
  1. 2. Your Excel formula has dollar signs before the Column and Row reference ($A$1)
  2. 4. Use this feature to quickly filter PivotTable data and knowing at a glance what data is shown
  3. 7. provides a selection of the more commoly used commands in one convenient place.
  4. 10. A time chart in a worksheet cell that provides a visual respresentation of data.
Down
  1. 1. What function is used to join two or more cells of data together?
  2. 3. Use this function to tidy up a list of badly capitalised names
  3. 5. The function that makes it esy to quickly add columns, rows or individual cells
  4. 6. A single page in a file created with an electronic spreadsheet program such as Excel.
  5. 8. What does every formula in Excel begin with
  6. 9. Hides the rows or columns containing data that do not meet the filter criteria you define.