Module 3
MCQ
EASY
1. Which of following is Not one of
the Excel’s what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
2. Which formula is correct if you
want to add the numbers in cells B3
and B4?
A. =sum(B3+B4)
B. Sum=(B3+B4)
C. =SUM(B3:B4)
D. =sum(B3+B4);
3. Which of the following is not an arithmetic
operator?
a. +
b. -
c. *
d. ]
4. When you insert an excel file into a
word document. The data are
A. Hyperlinked
B. Linked
C. bold
D. Using the word menu bar and
toolbars
5. .How many sheets are there, by
default, when we create a new
Excel file ?
A. 1
B. 3
C. 5
D. 10
MODERATE
6. Each excel file is a workbook that
contains different sheets. Which of
the following cannot be a sheet in
workbook?
A. Work sheet
B. Chart sheet
C. Macro sheet
D. Data sheet
7. In this type of chart, the data is plotted
into the concentric circles that is
irregular.
(a) Radar Chart b) Stock chart c) Scatter chart d) Doughnut chart
8. When all the numbers between 50
and 100 in a range should be
displayed in green Color, apply
A. Use =if() function to format
B. Apply Conditional Formatting
command on Format menu
C. Select the cells that contain
number between 50 and 100 then
click green colour on Text Color
tool
D. All of above
HARD
9. <> symbol is used in excel?
A. Function
B. Operator
C. Symbol
D. None of these
A. In
10. Which of the following functions are
used to convert a fraction into an integer
in ms excel?
A. Count()
B. Average()
C. Now()
D. Round()
SAQ
EASY
1) Name any two data types used in excel and discuss their uses? Write
down the syntax of Date and Time function. 3+2
moderate
2) Suppose A5 cell contains marks percentage . now write the syntax to
find out the grade using the following table.
Marks percentage
If 80 to 100 then E grade
If 60 to 79 then A+ grade
If 50 to 59 then A grade
If 40 to 49 then B grade
If 30 to 39 then C grade
If less than 30 then D grade
Write the Syntax of Max() function. 4+1
hard
3) What is the purpose of NOW() function in Ms Excel. Discuss how to
wrap text so as to fit within a cell? Discuss the need for autofill & auto
copy.
15 marks
easy
1. Company A is looking into four potential projects and will accept them if the IRR is
10% or above, as shown in cell E2. What is the formula used in cell C2, which can be
copied down to cell C3 through C5.
What do you mean by range operator?
Enter numbers in a cell A1, A2,A3,A4 and A5 and find out their
addition,percentage and average. (4+5+6)
moderate
2. Explain the logical funtions of ms excel.
What do you mean by goal seek in excel. Mention the steps .
Write the different types of cell reference. Define them (4+5+6)
Hard
3. What are macros in Excel? How would you make a hyperlink in Excel? Discuss different types
of functions in excel. Give example. (5+4+6)
Q.Consider the following Excel worksheet and find out the result of the formula added in B7
cell.
Ans=110
Q. Consider the following Excel Worksheet where A5 cell is empty and A8 cell contains a
space character. Find out the result of the formula added in B9 cell.
Ans=6
Q.What is the other name for XY chart?
points
Bar
Area
Line
Scatter
Ans scatter
Q.Which of the following Excel charts represents only one value for each variable?
A.Bar
B.Scatter
C.Pie
D.Doughnut
Ans:pie
What type of chart is used to emphasize the magnitude of change overtime?
A.Pie
B.Column
C.Bar
D.Area
Q. Consider the following Excel worksheet and construct a formula to calculate the total cost
of Watermelon in all cities using SUMIF function in D13 cell.
Ans
=SUMIF(B2:B11,"Watermelon",C2:C11), =sumif(b2:b11,"Watermelon",c2:c11), =SUMIF(B2:B11,
"Watermelon", C2:C11), =sumif(b2:b11, "Watermelon", c2:c11), =SUMIF(B2:B11,"=Watermelon",C2:C11),
=sumif(b2:b11,"=Watermelon",c2:c11), =SUMIF(B2:B11, "=Watermelon", C2:C11), =sumif(b2:b11,
"=Watermelon", c2:c11)
