Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Now that we have learned about the use an application of macros it is time to test your comprehension. This quiz will be made up
Now that we have learned about the use an application of macros it is time to test your comprehension. This quiz will be made up of two components. The first part will be somee multiple-choice questions based on the activates we you did earlier in the class. The second part will be for you to create your own macro using af is Microso a. Visual Basics for Applications b. Visual Basics for Automation C. Variable Basics for Applications or 2.What is the short cut key combination to open the compiler a. Shift+F7 b. Alt +F11 c. Ctrl C What does the statement does a. Deletes Entire Rows from 1 to10 in the worksheet "Data" b. Deletes contents from Rows 1 to 10 in the worksheet "Data C. Deletes Entire Columns from 1 to10 in the worksheet "Data" 4 How to Hide a Sheet using VBA code? a. Sheets("Sheetl"LVisible True b. Sheets(Sheetl"Visible False C. Sheetsti ).Visible = &Sbeetlerkiidaen Which menu option can be used to split windows into two In Excel 2007? a. View -> Window-> Split b. Window -> Split c. View->Split Part ll For the second part of this quiz you will create your own macro 1. Create a new workbook and create three worksheets. a. Label the first worksheet with your first name b. Labe the second with your last name c. Label the third with your favorite color 2. Write a script that hides the worksheet with your favorite color 3. Write a second script which saves the workbook with your name and the current date Print Layout
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started