24S2 ITA Wk8

When you realised that we're already in WEEK 8...

Fill in the Blank

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"?

:

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?

• Product C

• A1

• 3

• None of the above

Multiple Choice

In Excel, what function allows you to name a cell range (e.g., Product_Sales)?

• Naming

• Define Name

• Range Name

• Cell Link

Multiple Choice

If you have named the range A1:C3 as Product_Sales, what would be the most efficient way to use the SUM function to add up their total?

• =SUM(A1:C3)

• =SUM(Product_Sales)

• =SUM("Product_Sales")

• =SUM(Product_Sale)

Multiple Choice

What would be the result of the following formula?

=VLOOKUP(3, A8:F13, 2, FALSE)

• Product A

• Product C

• Product D

• Product F

Multiple Choice

What would be the result of the following formula?

= VLOOKUP(SUM(A8, A10), A8:F13, 2, FALSE)

• Product A

• Product C

• Product D

• Product F

Multiple Choice

Which of the following is an absolute reference for a cell in Row 3?

• $3A

• $E$3

• A$3

• 3F

Multiple Choice

Which of the following is an absolute reference for the cell in Column A, Row 8?

• $A8

• $A$8

• A$8

• A8

Multiple Choice

Which of the following is NOT an absolute reference?

• $CR7

• $A$10

• AA$5

• H7