Question

a. What is the use of formulas?
To format field names
To perform calculations
To highlight range
To define names



b. Which bar shows characters and formulas that you enter in
an active cell?
Address bar Menu bar Title bar Formula
bar



c. What do we call the input to functions which accept values as
numbers?
Г
Functions
Г
Arguments Return values
Formula



d. Which type of reference does not change the cell address on
copying the formula to another cell?
r Relative Referencer Mixed Reference New
Referencer Absolute Reference



e. Which sign is used to make an absolute reference of a
formula?
%
+



f. What type of reference is the combination of Relative and
Absolute reference?
Relative Reference r Mixed Referencer Absolute
Reference None of these



g. What do we call the rectangular area consisting of a group of
adjacent cells?
r Worksheet
Range
Workbook
None of
these



h. Which formulae involve more than one operator?
Basic Complex
r
Dual Compound
1. Which type of reference changes the cell reference
automatically on copying the formula to another cell(s)?
Absolute Reference
Mixed Referenc
RelativeReference
None of these



J. What do we call the pre-designed formulas to perform simple
and complex calculations?
Pre Formulas.
Saved Formulas
Operators
Function​

Answer 1

Answer:

The contents of the active cell appear in the Formula Bar, and the active cell address is displayed in the Name box at the left end of the Formula Bar. The Insert Function button is always available, but the other two formula-editing buttons appear only while you are entering or editing data in a cell.