Font size
WorksheetsExcel and Productivity Quiz
Total questions: 10
Worksheet time: 18mins
Which Excel function would you use if you wanted to sum only the sales amounts greater than 500?
SUM
SUMIF
IF
VLOOKUP
You want to combine the first name and last name of students in one cell. Which function should you use?
CONCATENATE
SUM
AVERAGE
IF
Which of the following is an example of a hypertext link?
A bolded word in a Word document
A blue, underlined word that opens a website when clicked
A highlighted paragraph
A table of numbers in Excel
What is the main difference between a function button and a navigation button in a productivity app?
Function buttons perform actions; navigation buttons move you through menus
Function buttons are always at the top; navigation buttons are on the side
Navigation buttons perform actions; function buttons move you between screens
They are the same
You are creating a budget tracker. Which Excel functions could you use to find the highest and lowest expenses?
SUM and AVERAGE
MAX and MIN
COUNT and SUMIF
CONCATENATE and IF
Give one real-life example of how you could use Google Forms outside the classroom.
Explain in 1–2 sentences the purpose of a menu bar in most productivity applications.
Which Excel function would you use to check if a student passed or failed based on their score? Explain briefly.
Name two features that almost all productivity tools share and explain why they are useful.
Imagine you have a list of student names and their scores. Which function could you use to look up a student’s score automatically and how?
