1.Which function would you use to add several numeric values?

a.TOTAL

b.AVERAGE

c.SUM

d.COUNT

2.Which of the following is the correct way to write the IF function?

a. =IF(condition, condition if false, condition if true)

b. =IF(condition:condition if true:condition if false)

c.=IF(condition, condition if true, condition if false)

d. None of the above

3.VLOOKUP in VLOOKUP function stands for Vertical Lookup.

a.True

b.False

4.If you see ##### code, what do you need to do?

a.Check your function syntax

b.Use a different function

c.Re-enter the function formula

d.Widen the column

5.Which function in Excel checks whether a condition is true or not ?

a.SUM

b.COUNT

c.IF

d.AVERAGE

6.What type of chart is useful for showing trends or changes over time ?

a.Pie

b.Column

c.Line

d.Dot

7.Getting data from a cell located in a different sheet is called:

a.Referencing

b.Accessing

c.Functioning

d.None of the above

8.Show do you rearrange the data in ascending or descending order?

a.Data>Sort

b.Data>Form

c.Data>Table

d.None of the above

9.What are the tabs that appear at the bottom of the each workbook called?

a.Location Tab

b.Sheet Tab

c.Reference Tab

d.None of the above

10.What is entered by the function =today()

a.Todays date as text format

b.Time value according to system clock

c.Date value for the day according to system clock

d.None of the above

Section 2

Short Answer Type Questions

This session carries short answer questions, answer any 5 out of 8(5X3=15 Marks)

1.How can you add new rows and columns to an Excel sheet?

2.How do you freeze panes in Excel?

3.How do you create Named Ranges?

4.Explain Pivot tables along with their features?

5.What are Pivot charts in MS Excel?

6.What are the different types of COUNT functions available in Excel?

7.What is VLOOKUP in Excel?

8.How do you find averages in MS Excel? Explain with example.