Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

Selectively increase group and team structure.

Answered: 1 week ago