Answer:
The loop increments the value of new while the loop condition is true
The end value of new is 3
Explanation:
Given
The above code segment
Required
What the loop does and the result
We have:
--- initialize new to 0
--- The loop condition;
i.e. the loop will be repeated 3 times (when i = 3, 4 and 5)
--- For each increment of i, new is incremented by 1
So, the value of new is:
<em>i = 3: new = 0 + 1 = 1</em>
<em>i = 4: new = 1 + 1 = 2</em>
<em>i = 5: new = 2 + 1 = 3</em>
To multiply two cells in Excel, use a multiplication formula like in the above example, but supply cell references instead of numbers. For example, to multiply the value in cell A2 by the value in B2, type this expression is A2*B2.
What do you under stand by Excel?
Microsoft's spreadsheet program Excel is a part of the Office family of products used for business purposes. Users can format, arrange, and compute data in a spreadsheet using Microsoft Excel.
To create formula in the selected cell follow these steps:
The PRODUCT function would be the quickest technique to multiply several cells or ranges.
Where number1, number2, etc. are numbers, cells or ranges that you want to multiply.
to multiply values in cells A2, B2 and C2, use this formula is PRODUCT(A2:C2)
To multiply the numbers in cells A2 through C2, and then multiply the result by 3, is PRODUCT(A2:C2,3)
Learn more about Excel click on this:
#SPJ4
