DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Zachary wants to create a formula that adds the values in cells A1 and B1 together and then multiplies the sum by 10. Which of the following formulas should he enter?
|
|
A1+B1x10
|
|
|
=(A1+B1)*10
|
|
|
=A1+B1x10
|
|
|
&A1+B1*10
|
Explanation:
Detailed explanation-1: -For example, to add together cells A1 and B1, move to C1 (or wherever you want the result of the calculation to appear) and type the =. Then use the mouse to click in A1, type the +, click in B1, and hit the enter key.
Detailed explanation-2: -In each blank cell, enter the formula as =A1*B1, =A2*B1 and so on for each cell in column A. Repeat this formula in each of the cells in column C to multiply each cell in column A by the constant in cell B1.
There is 1 question to complete.