Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. (6 pts) In this exercise, you will write expressions that refer to some of the objects in the Excel object model, which is shown

image text in transcribed

1. (6 pts) In this exercise, you will write expressions that refer to some of the objects in the Excel object model, which is shown in the following figure. Application Workbooks (Workbook) Worksheets (Worksheet) a. How many collections are shown in the above figure? b. For each of these collections, what type of objects are the members of this collection. For example, if the collection is people, the type of its member would be person? c. What expression can be used to refer to the running Application, i.e. Microsoft Excel? d. What expression can be used to refer to the Workbooks collection? e. What expression can be used to refer to the Workbook object whose name is "My Workbook.xlsm"? f. What expression can be used to refer to the second Worksheet object contained in the Workbook object whose name is My Workbook.xlsm

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

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions