A.
Fill
in the blanks:
1. Excel Provides us a large number of
in-built formulae which are called Functions
2. A group of related cells in a
workbook is called a Range
3. Excel provides a text box called the
formula bar to
write formulas.
4. The Enter key is used to evaluate a formula entered in a cell.
5. The sum function adds a series of numbers.
6. The #REF formula contains an invalid reference to a cell.
7. #VALUE! Formula contains type of data or
cell or function names that cannot be used in the formula.
8. #NAME? formula contain incorrectly spelling spelled cell
or function names.
9. You can cancel a formula by pressing
the Esc key.
10. Cell references and Reference name indicate the location of the cell used in the formula.
11. Operators tell Excel the kind of calculation to be
performed.
12. The active cell in a worksheet is
surrounded by a highlighted border called selector.
B.
Answer
the following questions:
1. Explain the order in
which Excel performs calculations.
Excel perform
calculations order determine by three rules:
Precedence Rule: When there are several calculation operators
in a formula, Excel follows the mathematical rules BODMAS.
Left to Right Rule: When a formula contain operation
with the same level of precedence, such as multiplication and Division or addition
and subtraction, excel calculates them from left to right.
Parentheses Rule: When a
formula contains parentheses, the operators within them are performed first. This
means you can change the order of precedence by using parentheses.
2. What do you understand
by Relative Cell References?
Relative cell references
are the default cell reference in Excel. It is simply the combination of column
and row number. When you copy the formula from one cell to another the relative
cell address changes depending on the relative position of column and row. Relative
references are used when we want to perform a similar operation on multiple
cells and the formula must change according to the relative address of column
and row.
3. Define Cell Range. How
can it be selected?
Cell Ranges is a group
of related cells in a worksheet.
To select a range of cell:
i)
Click
on the cell in one of the corners of the range cell you wish to select.
ii)
Hold
the left mouse button down and drag horizontally and vertically until the range
you wish to select is highlighted.
iii)
Release
the click. You will see the range you want are selected.
4. Give two common examples
of common error while entering formulas in Excel.
The two common error we
will face while entering formulas in Excel are:
i)
Typing
Mistakes
ii)
Logical
Error or Error in Referencing of the Cells.
5. What is Absolute Reference
in Excel?
Absolute Reference in
Excel refers to a reference that is “Locked” so that rows and column won’t
change when copied. Unlike Relative reference, an Absolute reference refers to
an actual fixed location on a worksheet.
6. How can you Create an
Absolute Reference in Excel? Give Example.
To Create an Absolute
Reference in Excel, add a dollar sign ($) before the row and Column. For
example, an absolute reference to A1 looks like this $A$1.
7. Write the use of
common mathematical function in Excel.
Some of the common
Mathematical function in Excel are:
i)
SUM Function:
It is used to quickly add numbers together.
ii)
PRODUCT Function: It is used to multiply all the numbers referenced by it.
iii)
AVERAGE Function: It is used to compute the mean or average of the numbers in a range by
adding a series of numeric values and then divide the result by the number of values.
iv)
MAX Function:
It is used to returns the largest value from a group or range of values.
v)
MIN Function:
It is used to returns the least value from a group of range of values.
vi)
COUNT Function: It is used to tell how many cells in a given range contain numbers,
including dates and formulas that evaluate to numbers.
8. Write the steps to use
the SUM function from the Ribbon.
Using Ribbon, we can use
the SUM function in the following way:
i)
Select
desire range of cell.
ii)
Click
on the Formulas tab on the ribbon.
iii)
In
the Function Library group, click on the down arrow to right of the AutoSum button.
(A list of function appears).
iv)
Click
the SUM function.
9. What is marquee in
Excel?
Marquee is a flashing
border surrounds the cell and a reference to the cell is inserted in cell when
you click each cell.
10. When Excel perform Left
to Right operation?
Excel perform Left and
Right operation when a formula contains both multiplication and division or
addition and subtraction.
11. What are Formulas in
Excel? How can we use Formula?
Formula is a mathematical
statements or instruction that describe the actions to be performed on numeric
values.
We can use formula to perform calculation
on values stored in our worksheet.
0 Comments