Tamil Nadu Open University (TNOU) 2006 B.A MS-Excel - Question Paper

TERM-END EXAMINATION- JANUARY 2006.
MS-EXCEL
Time: three hours Maximum marks: 100
part A - (8 x five =40 marks)
ans any 8 ques..

1. elaborate the basic features of Spread Sheet?
2. discuss how to create a workbook.
3. elaborate the built-in functions used to obtain the maximum number, minimum number, total and average?
4. How to create various borders in worksheet?
5. explain how string formatting and number formatting can be done Excel Sheet.
6. discuss the steps to add 3 rows and 2 columns in a sheet.
7. What is the method to sort the list of numbers in ascending and descending order?
8. How to split windows into panes?
9. What is Goal seek, and track modifications feature of Excel?
10. explain the concept of Auto filter and advanced filter of Excel.

part B - (6 x 10=60 marks)
ans any 6 ques..

11. discuss how to create a MS-Excel work sheet to compute the employee pay. obtain out the gross pay, detection and net pay.
12. Write a macro that formats a worksheet to have a line of spacing of 1.5 lines. The font is "Arial" and font
size of 10 points. The documents should have left, right and top margin as 2".
13. How to create an Excel sheet to compute mean and standard deviation for the data 75, 59, 60, 63, 49,
58,64,72,76,78,72?
14. Write the steps to create an Ms-Excel worksheet to draw a pie graph for your own sample data.
15. Write down the steps to create an Ms-Excel worksheet and do different choices of Fill-series.
16. How to convert text in to a column?
17. discuss pivot table and pivot chart report.
18. discuss the concept of auditing. Auto format and conditional formatting.

Earning:   Approval pending.