Donate a coffee

Tutorial - How to Use Excel Basics - Part 2

5
0
Say thanks!
Post your comment
The author
ENALLT
ENALLT
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 length
4 minutes 53 seconds
Video genre
Tutorials, how-to & educational videos
Language goals
listening
Listening comprehension
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
adults
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?
ENALLT
ENALLT
mx
ENALLT is from/lives in Mexico and has been a member of iSLCollective since 2017-09-07. ENALLT last logged in on 2023-01-25, and has shared 3 resources on iSLCollective so far.
See Portfolio
Post a comment
Post your comment
Comments
Be the first commenter!