Spreadsheet Unit Test CSA II

Match it! Select the correct answer from the pull down...Good luck!

The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occurred?

What is the BEST way to resolve repeated pound signs in a formula's result?

Which component of a chart describes what is contained within the chart?

What type of chart uses the height of a bar to represent a value?

Which of the following two formatting features are applied to $5,698.87?

Data presented in a spreadsheet can be easily understood by using what?

Which chart will BEST represent a comparison of the average family income in three states, with emphasis on the states?

A spreadsheet is created with drop down items that a user can select from. This is an example of which function?