Q1.
(a) . Write steps to open the calculator in windows.
(a)
. Write steps to open the calculator in windows.
(b)
. Write steps to change the screen saver in windows.
(c)
. Write the two extensions of any Audio file.
(d)
. In Windows all deleted files go to
(e)
. SMTP stands for
-
(a)
. Write steps to open the calculator in windows.
-
(b)
. Write steps to change the screen saver in windows.
-
(c)
. Write the two extensions of any Audio file.
-
(d)
. In Windows all deleted files go to
Q2.
(a) . Create a MS-Excel spreadsheet as shown below with the file name "Students Result".
(a)
. Create a MS-Excel spreadsheet as shown below with the file name "Students Result".
(b)
. Calculate the Total_Marks of "Physics", "Chemistry" and "Biology" using MS-Excel function.
(c)
. Sort the rows into alphabetical order with respect to "Student Name".
(d)
. Select the columns "Physics", "Chemistry" and "Biology" and draw a column chart.
(e)
. Set the X-axis labels of column chart with the Student Name and legends as "Physics", "Chemistry" and "Biology".
-
(a)
. Create a MS-Excel spreadsheet as shown below with the file name "Students Result".
-
(b)
. Calculate the Total_Marks of "Physics", "Chemistry" and "Biology" using MS-Excel function.
-
(c)
. Sort the rows into alphabetical order with respect to "Student Name".
-
(d)
. Select the columns "Physics", "Chemistry" and "Biology" and draw a column chart.
Q3.
(a)
. Create a table in MS-Access with database name "Employee" with following fields: Employee id (Number), Employee Name (Text), Date of joining (Date), Department (Text).
(b)
. Insert the following data in the above table: Dateof joining Employee id 101 03/15/2005 Production; 102 Mohan 04/10/2006 Maintenance; 11/23/2009 103 Production Ram; 104 05/26/2011 Mohit Administration.
(c)
. Add a new field "salary" and insert the values as per your choice.
(d)
. Sort the above table with respect to field Employee Name in alphabetical order.
(e)
. Update the table by changing the department as "Generation" in place of "Production".
Q4.
(a) . Create MS-PowerPoint file, insert the "Research Proposal" as slide title and format it as font type: Arial, Bold, Size: 96, Color: Black
(a)
. Create MS-PowerPoint file, insert the "Research Proposal" as slide title and format it as font type: Arial, Bold, Size: 96, Color: Black
(b)
. Insert the following in subtitle with font type: Arial, Size: 32 and Color: Black Introduction State of art Research Objectives Methodology
(c)
. Place the bullets in the beginning of all four lines in subtitle area.
(d)
. Insert any picture in the slide using ClipArt.
(e)
. Insert date and slide number in all the slides.
-
(a)
. Create MS-PowerPoint file, insert the "Research Proposal" as slide title and format it as font type: Arial, Bold, Size: 96, Color: Black
-
(b)
. Insert the following in subtitle with font type: Arial, Size: 32 and Color: Black Introduction State of art Research Objectives Methodology
-
(c)
. Place the bullets in the beginning of all four lines in subtitle area.
-
(d)
. Insert any picture in the slide using ClipArt.