Scribd
Upload
12 views3 pages

Excel Formula Basics and Functions Guide

The document explains various aspects of using cell references and functions in Excel, including the difference between typing and pointing to cell references, the concept of absolute references, and the utility of the Function Library. It also covers circular references, the definition of functions, rules for entering functions, and how to find the GCD of three numbers using the GCD() function. Examples are provided to illustrate these concepts.

Uploaded by

nhs.hmt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views3 pages

Excel Formula Basics and Functions Guide

The document explains various aspects of using cell references and functions in Excel, including the difference between typing and pointing to cell references, the concept of absolute references, and the utility of the Function Library. It also covers circular references, the definition of functions, rules for entering functions, and how to find the GCD of three numbers using the GCD() function. Examples are provided to illustrate these concepts.

Uploaded by

nhs.hmt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Q1. Mention the two ways of entering a cell reference in a formula.

Explain the difference between


them.

Answer:

The two ways of entering a cell reference in a formula are:

1. Typing the cell reference

2. Pointing (clicking) the cell

Difference:

- Typing the cell reference means writing the cell address manually, such as A1 or B5.

- Pointing the cell means selecting the cell by clicking on it, which automatically inserts the reference
and reduces errors.

Q2. What do we know about absolute reference? Explain with the help of an example.

Answer:

An absolute reference is a cell reference that does not change when a formula is copied to another cell.
It remains fixed because it uses the dollar signs ($).

Example:

In the formula =A1 * $B$1, the reference $B$1 is absolute.

When the formula is copied, A1 will change, but $B$1 will remain the same.

Q3. Explain the utility of Function Library.

Answer:

The Function Library provides a collection of built-in functions in Excel.

It helps users insert functions easily, saves time, reduces errors, and gives guidance while entering
arguments.

Functions like SUM, AVERAGE, MAX, and MIN can be selected directly from the Function Library.

Q4. Explain Circular Reference with an example.


Answer:

A circular reference occurs when a formula refers to its own cell directly or indirectly, causing Excel to
repeat the calculation in a loop.

Example:

If cell A1 contains the formula =A1 + 5, it becomes a circular reference because A1 is referring to itself.

Q5. What do you mean by function? Name some of the functions.

Answer:

A function is a pre-written formula in Excel that performs quick and accurate calculations.

Some examples of functions are:

SUM(), AVERAGE(), MAX(), MIN(), COUNT(), RIGHT(), TODAY().

Q6. What are the rules to enter a function?

Answer:

1. A function must begin with an equal sign (=).

2. The function name must be written correctly without spaces.

3. Brackets must be used after the function name.

4. Correct arguments should be entered inside the brackets.

5. Commas must separate multiple arguments.

6. The range used in the function must be valid.

Q7. How will you find the GCD of three numbers in Excel?

Answer:

In Excel, the GCD of three numbers can be found using the GCD() function.

The formula is:


=GCD(number1, number2, number3)

Example:

=GCD(12, 18, 24)

The result will be 6.

You might also like