Spreadsheet Quiz

What is the correct way to refer to cell that is in column B and Row 4

• B,4

• B4

• 4B

• Row B, Column 4

Which data type would you use for a person's name?

• Number

• Text

• Date

• Currency

Formatting: How can you change the font color of a cell?

• Use the Fill Color option

• Use the Font Color option

• Use the Border Color option

• Use the Number Format option

Basic arithmetic: What is the formula to add the values in cells A1 and B1?

• =A1 + B1

• A1+B1

• SUM(A1,B1)

• ADD(A1,B1)

What does the * do ?

• Addition

• Multiplication

• Subtraction

• Division

Functions: Which function is used to calculate the average of a range of cells?

• SUM

• AVERAGE

• COUNT

• MAX

What is a bar chart best used for?

• Comparing things

• Showing changes over time

• Showing parts of a whole

• Showing how two things are related.

Creating charts: How can you add a title to a chart?

• Click on the chart and type

• Go to the Insert tab and select Chart Title

• Go to the Insert tab and select Chart Title

• All of the above

Which function is used to count the number of cells in a range?

• COUNT

• COUNTIF

• COUNTA

• COUNTBLANK

How do you find out how much money you have left in your budget?

• Take away what you spent from what you earned.

• Add what you spent to what you earned.

• Divide what you spent by what you earned.

• Times what you spent by what you earned.