Match the following functions to their definition. I. AVERAGE ...

[123654777]

Match the following functions to their definition.
 
  I. AVERAGE
  II. COUNT
  III. MODE.SNGL
  IV. MEDIAN
  V. COUNTA
 
  A. Returns the mean of a set of numbers
  B. Returns the number in the middle of a set of numbers
  C. Counts the number of cells in a range that are not empty
  D. Counts the number of cells in a range that contain numbers
  E. Returns the value the occurs most often in a range

Question 2

________ is a tool in Access that can help you format your calculated fields correctly.
 
  A) Field properties sheet
  B) Navigation Pane
  C) Expression Builder
  D) Navigation bar

[princessflame2016]

Answer to Question 1

A, D, E, B, C

Answer to Question 2

C

[123654777]

Both answers were spot on, thank you once again

[princessflame2016]

Great! Please up vote