24S2 ITA Wk8
Presentation
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
Anson Chew
Used 3+ times
FREE Resource
24 Slides • 9 Questions
1
2
3
4
5
6
Fill in the Blanks
What should be the Input Range for the Combo Box if you want to only display the options of "Product C", "Product D", "Product E"?
7
Multiple Choice
From the image, what would the A1 cell value be when you have used it as the Cell Link for the Combo Box and you have selected Product C from the Combo Box?
8
9
10
Multiple Choice
11
Multiple Choice
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Multiple Choice
What would be the result of the following formula?
=VLOOKUP(3, A8:F13, 2, FALSE)
30
Multiple Choice
What would be the result of the following formula?
= VLOOKUP(SUM(A8, A10), A8:F13, 2, FALSE)
31
Multiple Choice
32
Multiple Choice
33
Multiple Choice
Show answer
Auto Play
Slide 1 / 33
SLIDE
