Quiz on Budgeting Skills with Google sheets

Which Google application is best suited for creating a budget spreadsheet?

• Google Docs

• Google Sheets

• Google Slides

• Google Forms

What is the purpose of using formulas in a Google Sheets budget?

• To change the font color

• To automatically calculate totals

• To insert images

• To print the document

Which symbol is used to start a formula in Google Sheets?

• $

• =

• #

• @

What does the SUM function do in Google Sheets?

• Subtracts numbers

• Adds numbers together

• Multiplies numbers

• Divides numbers

Which of the following is NOT a category you would typically find in a personal budget?

• Transportation

• Utilities

• Vacation

• Fictional characters

If you want to share your Google Sheets budget with a classmate, which button should you use?

• Print

• Share

• Insert

• Format

• 145

• 55

• 45

• 100

You want to track your spending on food, transportation, and entertainment. Which Google Sheets feature would help you quickly see the total spent in each category?

• Insert Image

• Filter

• SUM function

• Spell Check

You want to compare your actual spending to your budgeted amounts. Which Google Sheets tool can help you visualize this comparison?

• Chart

• Comment

• Hyperlink

• Merge cells

You want to highlight all expenses over \$100 in your budget. Which feature should you use in Google Sheets?

• Conditional formatting

• Spell check

• Insert comment

• Find and replace