USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cells A1 and A3.
|
|
|
Cells A1, A2, and A3.
|
|
|
All cells in rows 1 and 3.
|
|
|
All cells in column A
|
Detailed explanation-1: -A range reference refers to all the cells between and including the reference. A range reference consists of two cell addresses separated by a colon. The reference A1:A3 includes cells A1, A2, and A3. The reference A1:C3 includes A1, A2, A3, B1, B2, B3, C1, C2, and C3.
Detailed explanation-2: -Answer: There would be 4 cells in the given cell range. Question 11: The cell A1 has value Monday.
Detailed explanation-3: -In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Detailed explanation-4: -=A1+A2+A3 Adds the values in cells A1, A2, and A3.
Detailed explanation-5: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.