Tutorial - How to Use Excel Basics - Part 2
5
0
0
0
Let's sort out your problem!
Hi, I’m Melinda, your helpdesk person. You will find quick answers here. If not, you can contact me and I will respond within 24 hours.
Technical problem
Can't watch or hear it, problem with the website, etc.
Problem with quiz content
Found a mistake, bad timing, etc.
How to use video quizzes
Assign quizzes as homework, embed in blog, etc.
Say thanks!
The author
Similar Resources
Video quiz details
Task Description
Complete multiple choice, matching, true-false or open questions
Video details
Scene summary
This video explain how to use some basic formulas in excel
Video source
Tutorial - How to Use Excel Basics - Part 2Video length
4 minutes 53 seconds
Video genre
Tutorials, how-to & educational videos
Language goals
General topic
Other pedagogical goals
Level
The above lesson is a great teaching resource for:Intermediate (B1), Upper-intermediate (B2)
Student type
This resource is intended for:Adults
Quality check
Quality not yet verified by the community.
Sensitivity
This resource does not contain any images, words or ideas that would upset a reasonable person in any culture.
Copyright license
This resource is licensed by ENALLT under the iSLCollective Copyright License.
Upload date
25/01/2023
Video quiz questions (printable)
1. Guess the end.
True or False: Pivot Tables are used to modify existing data in a spreadsheet.
2. Match the two halves.
Report filters allow
to see certain rows
Column labels are
data set headers
Row labels are
data set rows
Value allows
to view your data differently
3. Choose the correct options.
Which is not permited by nesting If statements?
filter multiple items
set multiple conditions
get more specific results
organize data into easy groups
4. Choose the correct options.
Which of the following functions is used to calculate the times a word or number is repeated?
COUNTIF
SUMIF
AND, OR
5. Guess the end.
What do you have to be certain before using V-LOOKUP?
6. Guess the end.
What is a table array?
7. Guess the end.
People prefer to use V-LOOKUP over Index Match function. (True or False)
8. Choose the correct options.
Which formula is more useful when working with very large data sets?
V-LOOKUP
Index Match
9. Guess the end.
V-LOOKUp also presents some disadvantages when working with large data sets. (True or False)
10. Guess the end.
What is data visualization used for?
Post a comment
Comments
Be the first commenter!