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]
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). ‘Sales’ is an example of a/an:
A
named range.
B
external reference.
C
names manager.
D
scope.
Explanation: 

Detailed explanation-1: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Detailed explanation-2: -Range represents a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells.

Detailed explanation-3: -External reference in Excel is a reference to a cell or a range of cells outside the current worksheet. The main benefit of using an Excel external reference is that whenever the referenced cell(s) in another worksheet changes, the value returned by the external cell reference is automatically updated.

Detailed explanation-4: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1. The reference tells Formula One for Java to use the contents of the referenced cell(s) in the formula.

There is 1 question to complete.
Previous
Next