Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain how all answers were determined. Thank you. Questions are posed the way they are. If it is missing something, such as a code

Please explain how all answers were determined. Thank you. Questions are posed the way they are. If it is missing something, such as a code fragment, there must be another way to solve it. image text in transcribed

11. The string written by the code fragment into cell 83 is Dim Irow As Integer, icol As Integer row Range("K7:V28).Row col Range( K7.V28).Column Range("B3").Value--(" & irow & ","&icol &")" 12. The string written by the code fragment into cell B4 is Dim nrows As Integer, ncols As Integer nrows Range("K7:V28") Rows.Count ncols . Range("K7:V28").Columns.Count RangeC B4") Value "("& nrows &""&ncols& 13. Make the two ranges refer to the same cell by filling in the blanks: Range("C5").Cells(33,17) Range("N12").Cells The cell absolute string address is 14. You can remove the $ from an absolute Address as follows: Range(Cells(3, 4), Cells(8, 12)).Address(False, False) The String address range is 15. Make the two ranges refer to the same cell. Range(D8").Offset( 3,5 ).Value 27 Range("D8"),Cells).Value 27 Both refer to cell: 16. Find the number of rows and columns for Range( Cells( 5, 12),Cells( 14,27)) Number of rows = , Number of columns ", Lower right: ; express both as strings. Upper left

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

Students also viewed these Databases questions