Font size
S
M
L
XL
WorksheetsGoogle Sheets Finance Quiz
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
What does KPI stand for?
a)
Key Predictive Insight
b)
Known Performance Insight
c)
Key Performance Indicator
d)
Knowledge Process Interface
2.
Which spreadsheet function allows you to import a range from another Google Sheet?
(a)
3.
What function would you use to convert "01/01/2024" from text to date?
a)
VALUE
b)
IMPORTDATA
c)
DATEDIF
d)
IMPORTRANGE
4.
What is the purpose of the SUBSTITUTE function?
a)
Change cell formatting
b)
Replace part of text
c)
Split columns
d)
Calculate dates
5.
Which Google Sheets feature allows you to quickly group and summarize data by rows and columns?
a)
Filter
b)
Pivot Table
c)
Split Text
d)
Protect Range
6.
Which KPI best monitors financial health in a subscription model?
a)
Cash-out
b)
Monthly Recurring Revenue
c)
Average Basket
d)
Employee Satisfaction
7.
In the formula =DATEDIF(A1, B1, "D"), what does "D" represent?
(a)
8.
Which of the following are valid data sources for finance KPIs?
a)
Ads platform
b)
CRM system
c)
Payroll system
d)
Paint software
9.
Which function would you use to retrieve live data from a public .csv URL in Google Sheets?
a)
IMPORTHTML
b)
IMPORTDATA
c)
IMPORTXML
d)
IMPORTRANGE
10.
What does the YEAR function extract from a date?
(a)
11.
What type of analysis is best for measuring client loyalty over time?
a)
Customer View
b)
Detailed Analysis
c)
Transaction Level
d)
Marketing Mix
12.
Which KPI indicates the profitability of a company before taxes and interest?
(a)
13.
In a Google Sheet, what does =XLOOKUP(A2, B:B, C:C) do?
a)
Imports another sheet
b)
Merges sheets
c)
Finds a value in C that matches A from B
d)
Sorts data
14.
Which performance metric includes rent, payroll, and utility expenses?
a)
Gross margin
b)
Net margin
c)
Churn rate
d)
Operating margin
15.
What spreadsheet function returns today’s current date?
(a)
Reset
