1. Answer the following questions.
(a) List the three types of cell references and the differences between them.
(b) What is the basic requirement for any formula to work in Excel?
(c) What is a text value and how can it be used in a formula?
(d) Which error does #NUM! in the cell indicate?
(e) Differentiate between an argument and an argument tooltip in a
function.
Answers
Answer:
a) Three types of cell references:
. Relative Cell References.
. Absolute Cell References.
. Mixed Cell References.
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. ... Data from one or more contiguous cells on the worksheet.
An absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. Unlike a relative reference, an absolute reference refers to an actual fixed location on a worksheet.
Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell.
b) 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. Functions. Functions are predefined formulas in Excel.
c) A text value (also called a "text string") is one of Excel's primary content types. Other types of content include numbers, dates, times, and Boolean values. This alignment quickly shows which values Excel considers text.
d) The #NUM! error occurs in Excel formulas when a calculation can't be performed. For example, if you try to calculate the square root of a negative number, you'll see the #NUM! ... error is a matter of adjusting inputs as required to make a calculation possible again.
e) Argument-the value passed in the parenthesis of the function are called arguments. they are the values that function used to perform calculation. Argument tooltip-the tooltip is the hint given for a function that how the argument should be passed.
Answer:
135 degree is the answer