Sample question Chapter 6
More About Excel 2010’’
Short Questions:
1. What do you understand by formatting numbers and data in MS
Excel?
Ans: Numbers inserted in MS excel could be a value, date or time.
Using this option u can edit numbers in a cell like changing its color, font
etc. The feature Formatting data format’s the data and information of a
cell. The examples of the types of formatting data are: formatting the
fonts, border formatting and formatting cells.
2. What is the formula and how to use it?
Ans: A formula which is made up of a operand and operator. In MS Excel
a formula can be a set of values, cell references, functions given with or
without an operator. A formula in Excel is mandatory to start with an ‘=’
symbol or Excel will treat it as normal text. Any formula can be created
in Excel. Once the formula has been typed into the cell, the formula will
be executed immediately.
3. Explain the basic functions of MS Excel?
Ans: The basic functions of excel are:
Sum(): These options add the values of the selected range of cells
Average(): It calculates the average of the selected range of cells.
Max(): It finds out the largest number in the selected range of numbers.
Min(): It finds out the lowest number in the selected range of numbers.
Count(): It counts the amount of cell values in the selected range of
cells.
4. Explain Error results. What error message we get in MS excel and
define each one of them.
Ans: Sometimes errors are displayed in the formula bar instead of the
result.
#####: The column is not wide enough to display the results or the
value.
#DIV/0!: Division by zero (invalid operation)
#N/A: Data unavailable
#VALUE!: Invalid data
#NAME!: When text is not recognized
#REF!: Invalid cell reference
#NULL!: Ranges do not intersect or the user is using an invalid range
operator.
BROAD QUESTION
5. What is the work of the following Math function, (explain how we
use them with their syntax.)
a. GCD ()
b. COUNT()
c. AUTOSUM
d. AVERAGE()
e. SUM()
Ans: The work of each math function with their full form are:
GCD (Greatest Common Divider): GCD is also known as the HCF (Highest
Common Factor). It is the largest common integer that can divide two
or more numbers without a remainder. We use them with their syntax
like =GCD(A1:A5)
COUNT(): It counts the cell values. We use their syntax like:
=COUNT(A11:C15) Finds the count of values from cells A11 through
C15.
=COUNT(H9,F5,F6): Finds the count of values for three cells.
=COUNT(6,G3): Finds the values of a constant and a cell.
AUTOSUM: This feature is used to add numbers. We use their syntax
like =SUM(A1:A10)
AVERAGE(): It calculates the average of the cell values. We use their
syntax like:
=AVERAGE(B1:B10): finds the average of cells B1 through B10.
=AVERAGE(B2,B7): finds the average of two cells.
=AVERAGE(6,23,D3): finds the average of two constants and one cell.
SUM():It adds all the numbers in a range. We use their syntax like:
=SUM(A1:A10) finds the sum of the cell values A1 through A10.
=SUM(G1,F6) finds the sum of two cell values
=SUM(6,23,D3) finds the sum of two constants and a cell value.