Q.7 How to insert a table in Presentation by using INSERT TAB?
Q.8 Seema wants to give identical designs to all the slides and handouts, she is going to print from her
presentation.
1. Which two methods can she use to accomplish her work?
2. Compare the two methods and in list their differences.
Q.9 What is the usage of calendar sharing?
Q.10 Explain the following DML commands : SELECT, INSERT.
Q.11 What is a primary key? Explain with example.
Section-C (09 marks)
Answer the question. (9)
Q.12 Write the steps to share the worksheet data.
Q.13 Write down six tips to make your presentation effective.
Q.14 Write any three uses of Database Management System.
Section-D (05 marks)
Answer the questions. (5)
Q.15 Asian Pvt. Ltd. maintains the employee salary details in the worksheet given below:
A B C D E F G H I
1 EmpId EmpName Basic HRA DA PF NetSalary Bonus
2 E101 Ram Chandran 12000
3 E102 Manish Kumar 25000
4 E103 Srikant Naidu 18000
5 E104 Meena Jain 40000
6 E105 Shefali Gupta 38000
7 E106 Abhishek Jain 27000
8 E107 Romilla Babbar 32000
9 E108 Anupriya Singh 21000
Write a formula to do the following tasks:
1. To calculate the HRA as 40% of the basic pay in cells D2:D9
2. To calculate DA as 45% of the basic pay in cells E2:G9
3. To calculate the PF as 10% of the basic pay in cells F2:F9
4. To calculate the net salary as Basic+HRA+DA-PF in calls G2:G9
5. The employees are given a bonus based on the net salary. If the net salary is greater than or equal to 50,000,
display N, otherwise display Y in column H. What formula will enter in cell H2.
Answers
Answered by
1
the answer is question 11
Attachments:
Similar questions