Mocks don't measure how much you know. They measure how you behave under pressure. Use them for that.

MS Office — quick quiz

5 HR Police PC-pattern questions on MS Office. Instant scoring and solutions, no signup — see where you stand in a few minutes.

Question 1 of 5

Hard

In MS Excel, a user wants to apply a formula to calculate the average of values in cells B2 to B10, but wants to exclude any cells that contain zero. Which function should be used?