Question: what Information you need? this questions are all about spreadsheet analysis in excell. in this question you just have to answer that which is the



what Information you need? this questions are all about spreadsheet analysis in excell. in this question you just have to answer that which is the correct macros code
Choose the best description of what object is being referred to in the following line. (Assume it is all in one line even if it may not show up that way in your browser.) Workbooks("macroComputeReturns"). Worksheets("Practice").Range("A5").Font The font object of the cell A5 on the worksheet named "Practice" in the workbook named "macroComputeReturns" The font object of the cell A5 in the collection of worksheets named "Practice" in the collection of workbooks named "macroComputeReturns" The workbook named "macroComputeReturns" containing the worksheet named "Practice" that has a cell A5 with a font. Cell A5, which has a font, belonging to the worksheet named "Practice" in the workbook named "macroComputeReturns" In the Excel object model, what is Copy in the following 8-word expression? Application.Workbooks( "Book1.xlsx" ).Worksheets( "Template" ).Range( "Header" ).Copy It is a method of a range object It is a property of a range object It is a method of a collection It is an Excel object QUESTION 4 In the Excel object model, what is Font in the following expression: ActiveCell.Font.Bold (Hint: Font of a cell is that cell's property, but we are looking at the Bold property now, which makes Font what?) It is a method of the ActiveCell object It is an object. This object is a property of the ActiveCell object It is an object. This object is a property of the Bold object It is a property of the Bold object In the Excel object model, what is Sheet1 in the following 8-word expression? Application.Workbooks( "Book1.xlsx" ).Worksheets( "Sheet1" ).Range( "Date" ).Copy It is a property of a range object named Date It is a collection object It is the name of a particular worksheet object It is an argument of a workbook named Book1.xlsx
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
