CPA Spreadsheets review quiz

An individual box within a worksheet is known as?

• square
• range
• refernce
• cell

In Excel, what do all formula begin with?

• !
• -
• +
• =

What would be a correct formula for COUNTA in excel?

• =COUNTA(B3:B9)

• =COUNTAB3+B9

• COUNTA(B3:B9)

• =COUNT(B3:B9)

Which of the functions would help me count the number of Males (M) in class?

• =COUNT

• =COUNTA

• =COUNTIF

• =COUNTDOWN

What kind of a graph is this?

• Bar

• Line

• Stock

• Combination

What kind of a graph is this?

• Line

• Circle

• Pie

• Combination

Look at the image.

How are the names sorted?

• Alphabetically from A to Z

• Alphabetically from Z to A

• Numerically from smallest to largest

• Numerically from largest to smallest

Which function is used to add a colour to data based on a condition?

For example, highlighting the cells in a set of data to green if they are more than 5.

• format cell

• conditional formatting

• fill color

• magic cell

Look at the image.

What do you think is the most likely condition on how the cells are formatted?

• Highlight the cells with values smaller than 10 orange

• Highlight the cells that are empty orange

• Change the text colour of the cells that are empty to orange

• Change the text colour of the cells with values greater than 10 to orange

True or False:

We can use relational operators (like ">" and "<") in excel to compare data

• True

• False