Suppose you want to write a sub to calculate the commission rate of a sales employee based on the sales amount. If the sales amount is greater than 10,000 Euros, the commission rate is 7%. If the sales amount is smaller than or equal to 10, 000 Euros but greater than 5,000, then the commission rate is 5%. Otherwise, the commission rate is 3%. Which of the following code blocks can be inputted in the space in below sub (where red box is) to calculate the commission rate (multiple answers can be selected)?

[Expected time to answer: 3 mins]

Given the spreadsheet setup shown below,

what is the value of x after the following line of code is executed?

x=Selection.Cells(2,3).Value

The

following VBA procedure is intended to calculate and display the average of

three test scores entered by the user.

[Expected time to answer: 5 mins]

Assume that the flowchart segment below is

correctly implemented on VBA. Select the

What will be the value of the variable

“sellingPrice” displayed in the message box when the sub below is run?

[Expected time to answer: 2 mins]

Write a function named “sumSquares”, that takes a positive

integer

That is, the function should calculate:

For example, if a user inputs =sumSquares(3) into a cell,

the result should be 14 (

Which

of the code segments correctly represents the flowchart segment shown below?

[Expected time to answer: 3 mins]

Consider

the code below. What will be the value of x and y when for-next loop ends?

[Expected time to answer: 3 mins]

Write a subroutine named “TaxCalculator” to:

(A) Ask the user for the unit price of a product, the

quantity purchased (which must be a whole amount, such as 5, 12, 30), the tax

rate (as a percentage, taking values from 0 to 100) with an input box.

(B) Calculate:

gross total = unit price x quantity

purchased

tax amount = gross total x tax rate / 100

(C) Display gross total in cell A1 and tax amount in cell A2

of the active worksheet.

Make sure to include “Option Explicit” statement before

the sub.

Select the correct statements (you can select multiple).