Learn Programming

(:title Quiz: Excel Macros:) (:keywords quiz, test, Python, variable, Macro, VBA, Visual Basic, Applications, course:) (:description Learning assessment on Excel Visual Basic for Applications (VBA). VBA Macros are recorded and edited to customize and automate Excel workflows:)

1. An Excel workbook must be saved as a Macro-enabled workbook before a VBA program can be included. What is the file extension on a Macro-Enabled Excel workbook?

(:div id=q1a:)

Incorrect. xls (older Excel versions) and xlsx (new Excel version) are the file extensions for regular workbooks (not macro-enabled).

(:divend:)

(:div id=q1b:)

Incorrect. Missing the additional characters. In Windows, view the file Extensions by selecting Folder Options in a File Explorer with View...Options...View Tab...Unselect "Hide Extensions for known file types".

(:divend:)

(:div id=q1c:)

Correct. The file extension is xlsm to indicate and Excel file (xls) that is macro-enabled (+m).

(:divend:)

2. Visual Basic for Applications (VBA) is a backend programming language for Excel. Programs in VBA are called Macros.

(:div id=q2a:)

Correct.

(:divend:)

(:div id=q2b:)

Incorrect.

(:divend:)

3. In VBA, how do you retrieve the value from the current Active Sheet, Cell A5?

(:div id=q3a:)

Incorrect. The cell reference needs to be a string "A5".

(:divend:)

(:div id=q3b:)

Correct.

(:divend:)

(:div id=q3c:)

Incorrect. Use an equal sign (=), not "is".

(:divend:)