FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of these references refers to the entire table range, including column headers, table data, and the totals row?A) [#DATA]B) [#TOTALS]C) [#ALL]D) [#THISROW]
A
A
B
B
C
C
D
D
Explanation: 

Detailed explanation-1: -To refer to specific parts of a table, you can use any of the following specifiers. Item specifier. Refers to. [#All] The entire table, including table data, column headers and total row.

Detailed explanation-2: -An absolute reference in Excel is a reference that cannot be changed when copied, so you won’t see changes in rows or columns when you copy them. Absolute references are used when you want to fix a cell location. These cell references are preceded by a dollar sign.

Detailed explanation-3: -If the data in your Excel sheet is organized in rows rather than columns, then you can reference an entire row in your formula. For example, this is how we can calculate an average price in row 2: =AVERAGE($2:$2)-an absolute whole-row reference is locked to a specific row by using the dollar sign ($).

Detailed explanation-4: -To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.

There is 1 question to complete.
Previous
Next