Question

1. How data is analysed using pivot tables in MS-Excel?
2. List and explain any 5 mathematical functions and statistical functions in
MS-Excel.
3. What is the relationship between directory name, file name and drive in
windows.
4. Differentiate between COUNT, COUNTA, COUNTIF AND COUNT
BLANK function in MS-Excel with their syntaxes and relevant examples.
5. How would you provice a dynamic range of “Data Source" in pivot tables
in MS-Excel? Is it possible to make pivot table using multiple data
sources? Which event would you choose to view whether the pivot table
is modified or not?
6. What are the applications of IT in the health sector?
7. List and explain the factors on which speed of the computer depends.
8. Discuss the applications of IT in railways and banking.
9. What are the different error values that you can get when working with
formulas in MS-Excel.
10. How are the security issues taken care in the organisation?

Answer 1

Answer:

gjcrysrydhvhdtjdiyfjfgjvh vgjftjdgkvgkxfhx!vjgx