Unit 5 Final Exam Study Guide

Edit Answers
12345678
Across
  1. 3. A(n) ________ report will use functions such as Sum, Min, Max, Average, StDev, Count, and Var to summarize data.
  2. 5. The LOWER function converts all uppercase text to ________ letters.
  3. 7. ________ keeps rows and/or columns visible as you scroll through a worksheet.
  4. 8. The purpose of creating ________ between workbooks is to consolidate the data and automatically update when changes are made to the original data.
Down
  1. 1. If you needed to design a query to calculate the year contained in a date field, you would use the ________ function.
  2. 2. A(n) ________ form is replica of a table or query’s Datasheet view but still retains form properties.
  3. 4. Theme ________ define text, background, accent, hyperlink, and followed hyperlink colors.
  4. 6. A enhanced ________ displays in Office 2010 when the mouse pointer is placed over a button.