Question

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.

please answer all
send me
please​

Answer 1

Now there are three kinds of cell references that you can use in Excel:Relative Cell References.Absolute Cell References.Mixed Cell References.

Answer 2

1Now there are three kinds of cell references that you can use in Excel:

.Relative Cell References.

.Absolute Cell References.

.Mixed Cell References.

2.All Excel formulas begin with the equals sign, =, followed by a specific text tag denoting the formula you'd like Excel to perform. The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet, allowing you to find the sum (or total) of two or more values.

3.Answer. The Excel TEXT Function is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string.

4.Excel shows this error when a formula or function contains numeric values that aren't valid. This often happens when you've entered a numeric value using a data type or a number format that's not supported in the argument section of the formula.03

5.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.

Explanation:

I hope it will help you