The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multiply and Divide

The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multiply and Divide

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial introduces multiplication and division in programming, specifically in VBA. It explains how to use the * symbol for multiplication and the / symbol for division. The tutorial guides viewers through creating macros for these operations in Excel, including adding buttons to execute the macros and display results. The video emphasizes the importance of understanding these basic operations in programming.

Read more

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In VBA, which symbol is used to perform multiplication?

/

*

-

+

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step to practice multiplication in VBA?

Use the division symbol

Add a new subroutine called multiply_practice

Create a new Excel sheet

Change the text on the button

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used for division in VBA?

+

-

*

/

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What should you do after writing the division code in VBA?

Add a new button in Excel

Close the coding window

Delete the previous subroutine

Change the Excel sheet name

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the practical example, what is the result of dividing 60 by 30?

15

2

30

22