Google Sheets Finance Quiz

What does KPI stand for?

• Key Predictive Insight
• Known Performance Insight
• Key Performance Indicator
• Knowledge Process Interface

Which spreadsheet function allows you to import a range from another Google Sheet?

(a)  

What function would you use to convert "01/01/2024" from text to date?

• VALUE
• IMPORTDATA
• DATEDIF
• IMPORTRANGE

What is the purpose of the SUBSTITUTE function?

• Change cell formatting
• Replace part of text
• Split columns
• Calculate dates

Which Google Sheets feature allows you to quickly group and summarize data by rows and columns?

• Filter
• Pivot Table
• Split Text
• Protect Range

Which KPI best monitors financial health in a subscription model?

• Cash-out
• Monthly Recurring Revenue
• Average Basket
• Employee Satisfaction

In the formula =DATEDIF(A1, B1, "D"), what does "D" represent?

(a)  

Which of the following are valid data sources for finance KPIs?

• Ads platform
• CRM system
• Payroll system
• Paint software

Which function would you use to retrieve live data from a public .csv URL in Google Sheets?

• IMPORTHTML
• IMPORTDATA
• IMPORTXML
• IMPORTRANGE

What does the YEAR function extract from a date?

(a)