WorksheetsExcel Beginners Test #4
Total questions: 4
Worksheet time: 40secs
Name
Class
Date
1.
Where can you find this feature?
a)
"Home" ribbon
b)
"View" ribbon
c)
"Data" ribbon
d)
"Insert" ribbon
2.
What is the function of this feature?
a)
Split a single column of text into multiple columns
b)
Summarize data from separate ranges
c)
Find values quickly by sorting your data
d)
Group rows or columns
3.
What is the most important step before you can use "Subtotals" function in Excel?
a)
Make sure to use Excel Table
b)
Create a Named Range
c)
Define an index column
d)
Sort the column(s) before using the function
4.
How can you train and ensure user(s) of your file enter the correct data as expected?
a)
Conduct a seminar
b)
Stand and watch them use the file as intended
c)
Create a Youtube video
d)
Make use of Data Validation
100 %
