NEW
Font size
WorksheetsPost-Test
Total questions: 15
Worksheet time: 3mins
You need to separate names from "Juan Dela Cruz" in one column into first and last names. What should you do first?
Use CONCATENATE
Type first name in Column B and press Ctrl + E
Use the Split command
Press Ctrl + T
To combine first and last names in Column A and B into full names in Column C:
Use COUNTIF
Type full name in C2 and press Ctrl + E
Use Slicer
Use Data Validation
What Excel function should you use to assign numbers 1 to 20 for 20 student names?
COUNTIF
SEQUENCE(COUNTA(B2:B21))
CONCAT
RANK
How do you make Excel count how many students "Passed" in Column D?
Use a pivot table
=COUNTIF(D2:D100,"Passed")
=COUNT(D2:D100,"Passed")
=SUMIF(D2:D100,"Passed")
What is the benefit of using Flash Fill for name formatting?
It validates data
It visually sorts lists
It automates repeated formatting
It replaces formulas
If Flash Fill doesn't work, what should you check?
Macros
Autofill settings
Enable Flash Fill in Options
Developer Tab
You want to filter by "Status" using a slicer. What must be done first?
Format cells
Convert data to table
Create a named range
Use a pivot chart
You created a slicer. How do you clear all filters?
Press Delete
Use Clear Formatting
Click filter icon on slicer
Close Excel
A dropdown list is needed for Gender: Male, Female, Others. What goes in the Data Validation source box?
Gender
Male Female Others
Male, Female, Others
=A1:A3
Which Excel function is used for automated counting based on a condition?
SEQUENCE
COUNTIF
IFERROR
COUNTBLANK
You want Sheet2 to show live updates from Sheet1. Which formula will you use?
=Sheet2!A1
=Sheet1!A1
=AutoLink(A1)
=DataFrom(Sheet1,A1)
What allows the user to select multiple filter values in a slicer?
Alt + Click
Ctrl + Click
Shift + Tab
Alt + Shift
When using dropdowns, what must be selected in the Data Validation window?
Whole Number
List
Text Length
Custom
The purpose of inter-sheet linking is to:
Merge worksheets
Display charts
Reflect live data from one sheet to another
Print multiple sheets
Why should a teacher use Excel for grading and records?
It is stylish
It eliminates teaching
It automates and simplifies data tasks
It entertains students
