WorksheetsGoogle Sheets Stock and Production Quiz
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
Which function filters rows based on one or more criteria?
a)
QUERY
b)
SPLIT
c)
XLOOKUP
d)
FILTER
2.
Which Google Sheets function removes duplicate values from a column?
(a)
3.
What is the main purpose of a slicer in Google Sheets?
a)
Apply color schemes
b)
Sort values alphabetically
c)
Dynamically filter charts
d)
Edit formulas
4.
Which feature lets you filter a dataset manually without writing a formula?
a)
Query
b)
Filter
c)
Data Validation
d)
ImportRange
5.
What function retrieves a value from a lookup table by matching a key?
a)
INDEX
b)
FILTER
c)
XLOOKUP
d)
ARRAYFORMULA
6.
What’s the formula to return all values from column A where B = “active”?
(a)
7.
What KPI measures the ratio of products out of stock?
a)
Refund rate
b)
Compliance rate
c)
Shortage rate
d)
Delivery time
8.
Which of these are Procurement KPI examples?
a)
Compliance rate
b)
Purchase discount
c)
Bounce rate
d)
Number of suppliers
9.
What does the QUERY function syntax most resemble?
a)
JavaScript
b)
SQL
c)
Python
d)
Excel Macros
10.
Which formula returns the delivery duration from a ship date to delivery date?
(a)
11.
Which KPI evaluates a supplier's ability to meet requirements?
a)
Price competitiveness
b)
Compliance rate
c)
Refund rate
d)
Inventory age
12.
What KPI is calculated as refund amount divided by turnover?
(a)
13.
Which KPI reflects how long inventory is held before it’s sold or used?
a)
Lead time
b)
Inventory turnover
c)
Supplier discount
d)
Refund rate
14.
Which formula finds a region from a lookup table using INDEX and MATCH?
(a)
15.
Which function in Google Sheets helps extract a specific part of a string, such as the first 5 characters?
(a)
100 %
