Hasmeet

saluja
Hasmeet
saluja B.
Com 1"A"
 TABLE OF CONTENT

Sno. Content Page No.

Section -1 Application of Information Technology 1-25

1. How to create mail in a Gmail account? Write the uses of Inbox, Sent, 1-5
Outbox, Draft, Spam and Trash labels.
2. How to design Google form? Write the steps with appropriate windows. 6-7
3. How to create different student classes in Google classroom. 8-9
4. How do teachers create assignments and provide due dates, or grades in 10-12
Google Classroom?
5. How do students find assignments, due dates, or grades in Google 13-14
Classroom?
6. How to use social media platforms like twitter, Facebook and YouTube? 15-17
7. How to use social media platforms like Flickr, Skype, yahoo and 18-21
WhatsApp?
8. How to use Google spreadsheets, Google Slides and Google forms? 22-25
Section -2 MS WORD 26-49
1. Prepare a grocery list having four columns (Serial number, the name of 27-28
the product, quantity and price) for the month of April, 06.
2. Create a telephone directory. 29-30
3. Design a time-table form for your college. 31-32
4. XYZ Publications plan store lease an e-book design dapper your 33-34
syllabus. Design the First page of the book as per the given
specifications.
5. Create the following one page documents. 35-36
6. Create the following documents 37-38
7. Convert following text to a table, using comma as delimiter Type the 39-40
following as show (do not bold).
8. Enter the following data into a table given 41-42
9. Wrapping of text around the image. 43
10. How to install MS-Office in Windows operating system. 44-45
11. How to convert word, excel and PowerPoint into pdf & pdf to word. 46-49
Section - 3 MS-Excel 50-71
1. Enter the Following data in Excel Sheet 51-52
2. Given the following worksheet 53-54
3. Given the following worksheet 55-56
4. Company XYZ. Ltd. pays a monthly salary to its employees who consist 57-58
of basic salary, allowances & deductions. The details of allowances and
deductions are as follows:
5. Create Payment Table for a fixed Principal amount, variable rate of 59-60
interests and time in the form at below:
6. Use an array formula to calculate Simple Interest for given principal 61-64
amounts given the rate of Interest and time
7. The following table gives a year wise sale figure of five salesmen in Rs. 65-68
8. Enter the following data in Excel Sheet 69-71
Section – 4 MS Power Point 72-91
1. Do the following task 73-78
2. Do the following 79-83
3. Do the following 84-88
4. Creating an animation looks like the leaf is falling in a tree 89-91
Section-5 MS-Access 92-99
1. Crate a database named "college" and perform the following tasks 93-95
2. Create the employee table in MS-Access with the referential integrity- 96-99
foreign key.
 LIST OF FIGURES

Sno. Content Page No.

Screenshot -01 Output of Creating Gmail 2

Screenshot -02 Output of Creating Gmail 3
Screenshot -03 Output of Composing a mail 3
Screenshot -04 Output of Composing a mail 4
Screenshot -05 Output of Designing Google Form 6
Screenshot -06 Output of Designing Google Form 7
Screenshot -07 Output of Creating Student Class in Google Classroom 8
Screenshot -08 Output of Creating Student Class in Google Classroom 9
Screenshot -09 Output of Creating Student Class in Google Classroom 10
Screenshot -10 Output of Creating Student Class in Google Classroom 11
Screenshot -11 Output of Creating Student Class in Google Classroom 11
Screenshot -12 Output of finding Assignments 13
Screenshot -13 Output of finding Due Dates 14
Screenshot -14 Sign up in Twitter 15
Screenshot -15 Sign up in Facebook 16
Screenshot -16 Sign up in Youtube 17
Screenshot -17 Sign up in Flickr 18
Screenshot -18 Sign up in Skype 19
Screenshot -19 Sign up in Yahoo 20
Screenshot -20 Sign up in Whatsapp 20
Screenshot -21 Output of Google Spreadsheets 23
Screenshot -22 Output of Google Slides 24
Screenshot -23 Output of Google forms 25
Screenshot -24 Output of Grocery List 28
Screenshot -25 Output of Telephone Directory 30
Screenshot -26 Output of Telephone Directory 30
Screenshot -27 Output of College Time Table 32
Screenshot -28 Output of Book Title (XYZ Publication) 34
Screenshot -29 Output of Inviting Friends 35
Screenshot -30 Output of Certificate 36
Screenshot -31 Output of Garage Sale 36
Screenshot -32 Output of Newsletter 38
Screenshot -33 Output of a Table 40
Screenshot -34 Output of Table of Salesperson 42
Screenshot -35 Output of Wrapping of image 43
Screenshot -36 Output of MS- Office (Excel) 45
Screenshot -37 Output of Converting Word to pdf 46
Screenshot -38 Output of Converting Excel to pdf 47
Screenshot -39 Output of Converting Power point to pdf 48
Screenshot -40 Output of Converting pdf to Word 49
Screenshot -41 Output of Regional Sales Projections 52
Screenshot -42 Output of Grade of Students 54
Screenshot -43 Output of Sales 56
Screenshot -44 Output of Number of Instalments 58
Screenshot -45 Output of rate of Interest 60
Screenshot -46 Output of Salesman 62
Screenshot -47 Output of Bar Graph 63
Screenshot -48 Output of Salesman of 2022 63
Screenshot -49 Output of Pie chart 64
Screenshot -50 Output of Expenses ( Including 3-D Column and Pie Chart) 68
Screenshot -51 Output of Sam’s Book Stall 71
Screenshot -52 Output of Line chart 71
Screenshot -53 Output of Lighthouse Co. Ltd. 76
Screenshot -54 Output of Lighthouse Co. Ltd. 76
Screenshot -55 Output of Lighthouse Co. Ltd. 77
Screenshot -56 Output of Lighthouse Co. Ltd. 77
Screenshot -57 Output of Lighthouse Co. Ltd. 78
Screenshot -58 Output of food fair 82
Screenshot -59 Output of food fair 82
Screenshot -60 Output of food fair 83
Screenshot -61 Output of Holiday 87
Screenshot -62 Output of Holiday 87
Screenshot -63 Output of Holiday 88
Screenshot -64 Output of Holiday 88
Screenshot -65 Output of leaf falling from tree 90
Screenshot -66 Output of leaf falling from tree 91
Screenshot -67 Output of leaf falling from tree 91
Screenshot -68 Output of database college 94
Screenshot -69 Output of database college 95
Screenshot -70 Output of Employee database 98
Screenshot -71 Output of Employee database 98
Screenshot -72 Output of Employee database 99
Screenshot -73 Output of Employee database 99
Computer Fundamental and MS Office 2024-2025

SECTION: 01
APPLICATION OF INFORMATION
AND TECHNOLOGY

Hasmeet B.COM 1 A 1|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 1. How to create mail in Gmail account? Write the

uses of Inbox, Sent, Outbox, Draft, Spam and Trash labels.

SOLUTION –
Step-1 Creating a mail in Gmail

Screenshot 01: Creating Gmail Account

1.Go to the Google Account sign in page

2. Click Create account .
. From the drop down , select if this account is for your:
. Personal use
. Child
. Business
3. Enter your name
.You’ll be asked to add your birthday and gender.
4. In the "Username" field, enter a username.

Step-2 Sign in to Your Gmail Account

o Go to Gmail.
o Enter your email address and password, then click "Sign In."
Screenshot 01: Output of Creating Gmail

Hasmeet
1. Go to the Google Account sign in page. B.COM 1 A 2|P a g e
saluja

2. Click Create account.

• From the drop down, select if this account is for your:

Computer Fundamental and MS Office 2024-2025

Screenshot 02: Output of Creating Gmail

Step -3 Compose a New Email

o Click the "Compose" button, usually located in the top left corner of the Gmail
interface.

Screenshot-03 Output of Composing a mail

Hasmeet B.COM 1 A 3|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

Step-4 Fill in the Email Details

o To: Enter the recipient's email address.
o Subject: Enter a brief subject for your email.
o Body: Write your message in the main text area.

Step-5 Add Attachments (Optional)

o If you want to attach files, click the paperclip icon at the bottom of the
compose window and select your file(s).

Screenshot-04 Output of Composing a mail

Step-6 Send the Email

o Once you're satisfied with your email, click the "Send" button.

USES OF DIFFERENT LABELS IN GMAIL

• Inbox:
o This is where you'll find all your incoming emails. It’s the main hub for
managing your messages. Unread emails will be bolded until you open them.

• Sent:
o Contains all the emails you have sent. This is useful for referencing past
communications or ensuring that a message was successfully delivered.

• Outbox:
Hasmeet B.COM 1 A 4|P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o This is where emails are temporarily stored when they can't be sent
immediately (usually due to network issues). Once the email is sent, it moves
to the Sent folder.

• Drafts:
o Contains emails you have started but haven't sent yet. These are saved
automatically, so you can return to them and finish writing later.

• Spam:
o Filters out unwanted or suspicious emails. Gmail automatically sorts emails it
suspects to be spam into this folder. You should check this occasionally to
ensure important emails haven't been misclassified.

Trash:
o Contains emails you have deleted. They remain here for 30 days before being
permanently deleted. You can recover emails from the Trash if you
accidentally deleted them.

Hasmeet B.COM 1 A 5|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 2. How to design Google form? Write the steps with

appropriate windows.

SOLUTION -
STEPS TO DESIGN A GOOGLE FORM
Step-1 Open Google Forms
Go to Google Forms and sign in with your Google account.

Step-2 Start a New Form

Click on "Blank form" to start a new form.

Screenshot-05 Output of designing Google Form

Step-3 Name Your Form

o Enter a title for your form in the "Form Title" field.
Step-4 Add a Description (Optional)
o You can add a description to provide more information about the form in the
"Form Description" field.

Step-5 Add Questions

o Click on the "+" button to add a new question.

Hasmeet B.COM 1 A 6|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

o Choose the type of question you want to add (e.g., short SOLUTION, multiple
choice, checkbox, etc.).
o Enter the question text and possible SOLUTION if applicable.

Screenshot-06 Output of designing Google Form

Step-6 Customize Your Form

Click on the palette icon to customize the theme, background color, and font.
You can also add images or videos to your form.

Step-7 Preview Your Form

Click on the eye icon to preview your form and make any necessary
adjustments.

Step-8 Send Your Form

Click on the "Submit" button to share your form.
You can share the form via email, link, or embed it on a website.

Step-9 Collect and Analyse Responses

o Click on the "Responses" tab to view the collected responses.
o You can see a summary of the SOLUTION and download the data as a
spreadsheet.

Hasmeet B.COM 1 A 7|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 3. How to create different student classes in Google

classroom?

SOLUTION-
STEPS TO CREATE DIFFERENT STUDENT CLASSES IN
GOOGLE CLASSROOM
1. Sign in to Google Classroom
Go to Google Classroom and sign in with your Google account.

2. Create a New Class

Click on the "+" button at the top right corner and select "Create class".

3. Enter Class Details

Class Name: Enter a name for your class.
Section (Optional): Add a section name, grade level, or class time.
Subject (Optional): Choose a subject or enter a custom one.
Room (Optional): Enter the location for the class.
Description (Optional): Add any additional details about the class.

Screenshot-07 Output of Creating Student class in Google Classroom

Hasmeet B.COM 1 A 8|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

4. Create the Class

o Click "Create" to finalize the class setup. Google Classroom will generate a
unique class code that you can use to invite students2.

5. Repeat for Additional Classes

o Repeat the above steps to create more classes as needed.

Screenshot-08 Output of Creating Student Class in Google Classroom

Hasmeet B.COM 1 A 9|P a g e

saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 4. How do teachers create assignments and provide

due dates, or grades in Google classroom?

SOLUTION-

CREATING ASSIGNMENTS IN GOOGLE CLASSROOM

Screenshot-09 Output of Creating Student Class in Google Classroom

1. Open Your Class

Go to Google Classroom and select the class where you want to create an
assignment.

2. Go to Classwork
Click on the "Classwork" tab at the top of the page.

3. Create an Assignment
o Click on the "+ Create" button and select "Assignment" from the dropdown
menu.

Hasmeet B.COM 1 A 10 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-10 Output of Creating Student Class in Google Classroom

4. Enter Assignment Details

o Title: Enter the title of the assignment.
o Instructions: Add any instructions or guidelines for the assignment.

Screenshot-11 Output of Creating Student Class in Google Classroom

Hasmeet B.COM 1 A 11 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

5. Set a Due Date

o Click on the "Due date" field to set a specific due date and time for the
assignment.

6. Assign to Students
o Choose which students will receive the assignment. You can assign it to the
entire class or select specific students.

7. Post the Assignment

o Click the "Assign" button to post the assignment immediately, or click the
dropdown arrow next to "Assign" to schedule it for later or save it as a draft.

Hasmeet B.COM 1 A 12 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 5. How do students find assignments, due dates, or

grades in Google classroom?

SOLUTION-

Step-1 Finding Assignments and Due Dates

1. Open Google Classroom
Go to Google Classroom and sign in with your Google account.

2. Select the Class

Click on the class you want to check for assignments.

3. Navigate to the Classwork Tab

Click on the "Classwork" tab at the top of the page. This is where all the
assignments, quizzes, and materials are posted.

4. View Assignments
Under the Classwork tab, you'll see a list of all the assignments organized by
topic. Each assignment will show its title and due date.
You can click on an assignment to see more details and submit your work.

Screenshot-12 Output of Finding Assignments

Hasmeet B.COM 1 A 13 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Step-2 Checking Due Dates

1. View the To-Do List
o On the main Google Classroom homepage, click on the "To-Do" button
(usually located on the left sidebar).
o This list shows all your upcoming and past due assignments across all your
classes.

2. Check Calendar
o In the Classwork tab, click on the "Google Calendar" link. This opens a calendar
view showing all your assignment due dates.

Screenshot-13 Output of Finding Due Dates

Hasmeet B.COM 1 A 14 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 6. How to use social media platforms like Twitter,

Facebook and YouTube?

SOLUTION-

I. Twitter

Screenshot-14 Sign up in Twitter

1. Sign Up for Twitter:

o Go to Twitter and click on the "Sign Up" button. Follow the prompts to create
your account.

2. Set Up Your Profile:

o Add a profile picture, cover photo, bio, and any other details to personalize
your profile.

3. Follow Users:
o Search for and follow friends, celebrities, or topics that interest you.

4. Tweet:
o Click the "Tweet" button to share your thoughts in 280 characters or less. You
can also add photos, videos, or GIFs.

5. Engage:

Hasmeet B.COM 1 A 15 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Like, retweet, or reply to other users' tweets to engage in conversations.

II. Facebook

Screenshot-15 Sign up in Facebook

1. Sign Up for Facebook:

Go to Facebook and click on "Create New Account." Follow the prompts to
set up your profile.

2. Set Up Your Profile:

Add a profile picture, cover photo, and fill out your personal information.

3. Add Friends:
Search for people you know and send friend requests. You can also join groups
and follow pages that interest you.

4. Post Updates:
Share status updates, photos, videos, and links by posting on your timeline.

5. Engage:
o Like, comment, and share posts from your friends and the pages you follow.
You can also send private messages via Messenger.

Hasmeet B.COM 1 A 16 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

III. YouTube

Screenshot-16 Sign up in YouTube

1. Sign Up for YouTube:

o Go to YouTube and sign in with your Google account. If you don’t have one,
you can create it.

2. Set Up Your Channel (Optional):

o If you plan to upload videos, you can create a channel. Go to your profile
picture and click "Your Channel" to set it up.

3. Search and Watch Videos:

o Use the search bar to find videos on topics that interest you. You can subscribe
to channels to follow their content.

4. Engage:
o Like, comment, and share videos. You can also create playlists to organize
your favourite videos.

5. Upload Videos (If You Have a Channel):

o Click on the camera icon with a plus sign to upload videos. Add a title,
description, and tags to make your video searchable.

Hasmeet B.COM 1 A 17 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 7. How to use social media platforms like Flickr,

Skype, Yahoo and WhatsApp?

SOLUTION-

I. Flickr

Screenshot-17 Sign up in Flickr

1. Create an Account:

o Sign up using your email or connect with your Google or Yahoo account.
2. Upload Photos:
o Click on the upload button, select photos from your device, and add descriptions,
tags, and albums.

3. Organize Photos:
o Create albums to group similar photos and manage your photos easily.
4. Share Photos:
o Share your photos with friends, family, or the public by using the share button.

Hasmeet B.COM 1 A 18 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

II. Skype

Screenshot-18 Sign up in Skype

1. Download and Install:

o Get Skype from the official website or app store.

2. Create an Account:
o Sign in with your Microsoft account or create a new one.
3. Add Contacts:
o Import contacts or add them manually.
4. Make Calls:
o Click on a contact and choose to make a voice or video call.
5. Chat:
o Send messages, files, and emoticons.

III. Yahoo
1. Create an Account:
o Sign up using your email or connect with your Google account.
2. Use Mail:
o Compose and send emails, manage your inbox, and organize emails into folders.
Hasmeet B.COM 1 A 19 | P a g e
Hasmeet
saluja B.COM 1 A 19 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

3. Browse News:
o Access Yahoo News for the latest updates and customize your news feed.
4. Use Yahoo Finance:
o Track stocks, get financial news, and manage your portfolio.

Screenshot-19 Sign up in Yahoo

Screenshot-20 Sign up in WhatsApp

Hasmeet B.COM 1 A 20 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

1. Download and Install:

o Get WhatsApp from the app store.
2. Verify Your Phone Number:
o Enter your phone number and verify it via SMS.
3. Add Contacts:
o Import contacts from your phone's address book.
4. Send Messages:
o Start chatting with contacts using text, voice messages, images, and videos.
5. Make Calls:
o Make voice or video calls directly from the app.

Hasmeet B.COM 1 A 21 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 8. How to use Google Spreadsheets, Google Slides

and Google forms?

SOLUTION-
I. Google Sheets (Spreadsheets)
1. Open Google Sheets:
o Go to Google Sheets and sign in with your Google account.

2. Create a New Spreadsheet:

o Click on the "+" (Blank) button to create a new spreadsheet.
3. Enter Data:
o Click on any cell and start typing to enter your data. Use the tabs at the bottom
to add more sheets.

4. Use Formulas and Functions:

o Enter formulas in the cells to perform calculations (e.g., =SUM(A1:A10) to
sum a range of cells).

5. Format Cells:
o Highlight cells and use the toolbar options to change text size, color,
alignment, and more.

6. Share and Collaborate:

o Click the "Share" button in the top-right corner to invite others to view or edit
your spreadsheet.

Hasmeet B.COM 1 A 22 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-21 Output of Google Spreadsheets

II. Google Slides

1. Open Google Slides:
o Go to Google Slides and sign in with your Google account.

2. Create a New Presentation:

o Click on the "+" (Blank) button to create a new presentation.

3. Add Slides:
o Click the "+" button to add new slides. Choose from different slide layouts.
4. Insert Content:
o Add text, images, videos, shapes, and more using the toolbar options.
5. Customize Design:
o Use themes, background colors, and fonts to customize your slides.
6. Present and Share:
o Click the "Present" button to start a presentation. Share your slides by clicking
the "Share" button in the top-right corner.

Hasmeet B.COM 1 A 23 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-22 Output of Google Slides

III. Google Forms

1. Open Google Forms:
o Go to Google Forms and sign in with your Google account.

2. Create a New Form:

o Click on the "+" (Blank) button to create a new form.

3. Add Questions:
o Use the "Add question" button to insert different types of questions (e.g.,
multiple choice, short SOLUTION , checkboxes).

4. Customize Form:
o Add a title and description. Use themes to change the form's appearance.
5. Share the Form:
o Click the "Send" button to share the form via email, link, or embed it on a
website.

6. Analyse Responses:
o Click on the "Responses" tab to view and analyse the collected responses. You
can also download the responses as a spreadsheet.

Hasmeet B.COM 1 A 24 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-23 Output of Google Forms

Hasmeet B.COM 1 A 25 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

SECTION:02
MS-WORD

Hasmeet B.COM 1 A 26 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 1. Prepare a grocery list having four columns (Serial

number, the name of the product, quantity and price) for the
month of April, 06.
➢ Font specific actions for Title (Grocery List):14-point Arial font
in bold and italics.
➢ The headings of the columns should be in 12-point and bold.
➢ The rest of the document should be in 10-point Times New
Roman.
➢ Leave a gap of 12-points after the title.

SOLUTION-

Formatting Instructions:
1. Title (Grocery List):
o Font: Arial
o Font Size: 14-point
o Bold and Italic
o Leave a gap of 12 points after the title
2. Column Headings:
o Font Size: 12-point
o Bold
3. Rest of the Document:
o Font: Times New Roman
o Font Size: 10-point

Steps to Set Up the Table in Excel:

1. Enter the Data:

o Open a new Excel sheet.
o In the first row, merge columns A to D and enter the title "Grocery List."
o Leave one row blank to create a 12-point gap.
o Enter the column headings in row 3: "Serial No.", "Name of Product",
"Quantity", and "Price."
o Enter the data in rows 4 to 8.

Hasmeet B.COM 1 A 27 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

2. Format the Title:

o Select the merged cell for the title.
o Change the font to Arial, 14-point, and apply bold and italics.
o Leave one row blank after the title.
3. Format the Column Headings:
o Select the cells with the column headings.
o Change the font size to 12-point and apply bold formatting.
4. Format the Rest of the Document:
Select the data cells (rows 4 to 8).
Change the font to Times New Roman, 10-point.

Screenshot-24 Output of Grocery List

Hasmeet B.COM 1 A 28 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 2. Create a Telephone Directory.

➢ The heading should be 16-point Arial Font in bold.
➢ The rest of the document should use 10-point font size.
➢ Other headings should use 10-point Courier New Font.
➢ The footer should show the page number as well as the date last updated.

SOLUTION-

Steps to Enter Data in Microsoft Word:

1. Open Microsoft Word:
o Launch Microsoft Word and open a new blank document.
2. Enter the Heading:
o Type the heading "Telephone Directory."
o Highlight the text "Telephone Directory."
o Go to the Home tab, select "Arial" as the font, set the font size to 16-point, and
click the "Bold" button to make the text bold.
3. Enter the Rest of the Document:
o Type the content of the document.
o Highlight the remaining text (after the heading).
o Go to the Home tab and set the font size to 10-point.
4. Format Other Headings:
o Highlight the text for any additional headings.
o Go to the Home tab, select "Courier New" as the font, and set the font size to
10-point.

5. Add Footer:
o Go to the Insert tab.
o Click on "Header & Footer" and select "Footer."
o Choose a footer style that includes both page number and date.
o Insert the date last updated by typing it manually or using the "Insert Date and
Time" option in the footer.

Hasmeet B.COM 1 A 29 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-25 Output of Telephone Directory

Screenshot-26 Output of Telephone Directory

Hasmeet B.COM 1 A 30 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 3.

Design a time-table form for your college.

➢ The first line should mention the name of the collegein 16-point Arial
Font and should be bold.
➢ The second line should give the course name/teacher's name and the
department in 14-pointArial.
➢ Leave a gap of 12-points.
➢ The rest of the document should use 10-point Times New Roman font.
➢ The footer should contain your specifications as the designer and date of
creation.

SOLUTION –

Step-by-Step Guide

1. Open Microsoft Word:

o Start a new blank document.
2. Enter the College Name:
o Type the name of the college.
o Highlight the text.
o Go to the Home tab, select Arial as the font, set the font size to 16-point, and
click the Bold button.
3. Enter Course Name/Teacher's Name and Department:
o Press Enter to move to the next line.
o Type the course name/teacher's name and the department.
o Highlight the text.
o Go to the Home tab, select Arial as the font, and set the font size to 14-point.
4. Leave a Gap of 12-Points:
o Press Enter twice to create a blank line.
5. Set Up the Timetable Table:
o Insert a table to create the timetable.
o Go to the Insert tab, click Table, and select the desired number of rows and
columns.

Hasmeet B.COM 1 A 31 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

6. Format the Rest of the Document:

o Highlight the entire table.
o Go to the Home tab, select Times New Roman as the font, and set the font size
to 10-point.

7. Add Footer:
o Go to the Insert tab, click Header & Footer, and select Footer.
o Enter your specifications as the designer and the date of creation.

Screenshot-27 Output of College Time Table

Hasmeet B.COM 1 A 32 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 4.
XYZ Publications plan store leases an e-book design dapper your syllabus.
Design the First page of the book as per the given specifications.
➢ The title of the book should appearinboldusing20-pointArialfont.
➢ The name of the author and his qualifications should be in the center of
the page in 16-point Arial font.
➢ At the bottom of the document should be the name of the publisher and
address in16-point Times New Roman.
➢ The details of the offices of the publisher (only location) should appear in
the footer.

SOLUTION –

Steps to Enter Data in Microsoft Word:

1. Open Microsoft Word:
o Start a new blank document.

2. Enter the Title of the Book:

o Type the title of the book.
o Highlight the text.
o Go to the Home tab, select Arial as the font, set the font size to 20-point, and
click the Bold button.
o Align the title to the center of the page using the center alignment option.

3. Enter the Author Name and Qualifications:

o Press Enter a few times to move the cursor to the center of the page.
o Type the author's name and qualifications.
o Highlight the text.
o Go to the Home tab, select Arial as the font, and set the font size to 16-point.
o Align the text to the center of the page.

4. Enter the Publisher Name and Address:

o Press Enter a few more times to move the cursor to the bottom of the page.
o Type the publisher's name and address.
o Highlight the text.
o Go to the Home tab, select Times New Roman as the font, and set the font size
to 16-point.
o Align the text to the center of the page or bottom-align using the alignment
options.

Hasmeet B.COM 1 A 33 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

5. Add Footer:
o Go to the Insert tab.
o Click Header & Footer and select Footer.
o Enter the location of the publisher's offices.

Screenshot-28 Output of Book Title (XYZ Publications)

Hasmeet B.COM 1 A 34 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

QUESTION 5. Create the following one-page documents.

➢ Compose a note inviting friends together at your house, including a list of

things to bring with them.
➢ Design a certificate in landscape orientation with a border around the
document.
➢ Design a Garage Sale sign.

SOLUTION-

Screenshot-29 Output of Inviting Friends

Hasmeet B.COM 1 A 35 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

Screenshot-30 Output of Certificate

Screenshot-31 Output of Garage Sale

Hasmeet B.COM 1 A 36 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

QUESTION 6.
Create the following documents:

➢ A newsletter with a headline and 2 columns in portrait orientation,

including at least one image surrounded by text.
➢ Use a newsletter format to promote upcoming projects or events in your
classroom or college.

SOLUTION –

STEP-BY-STEP GUIDE TO CREATING A NEWSLETTER IN

MICROSOFT WORD
1. Open Microsoft Word:
o Start a new blank document.
2. Set Page Orientation to Portrait:
o Go to the "Layout" tab.
o Click on "Orientation" and select "Portrait."
3. Add a Headline:
o At the top of the document, type your headline (e.g., "Upcoming Projects and
Events").
o Highlight the headline text.
o Go to the "Home" tab, set the font size to 20-point (or your preferred size),
and apply bold formatting.
o Center the headline using the center alignment option.
4. Create Two Columns:
o Place the cursor at the beginning of your text area (below the headline).
o Go to the "Layout" tab.
o Click on "Columns" and select "Two."
5. Add Text for the Newsletter:
o Begin typing or paste the content you have prepared for the newsletter.
o Include sections or paragraphs about the different projects and events you
want to promote.
6. Insert an Image:
o Place the cursor where you want to insert the image.
o Go to the "Insert" tab.
o Click on "Pictures" and select the image you want to include.
o Once the image is inserted, click on it to select it.
7. Wrap Text Around the Image:
o With the image selected, go to the "Format" tab under "Picture Tools."
o Click on "Wrap Text" and select "Square" or "Tight" to wrap the text around
the image.
8. Format the Columns:
o Ensure your text is evenly distributed between the two columns.
o You can adjust the column width and spacing if needed by going to the
"Layout" tab, clicking on "Columns," and selecting "More Columns."

Hasmeet B.COM 1 A 37 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

ADDING IMAGE AND WRAPPING TEXT AROUND IT:

1. Insert Image:
o Make sure the image is surrounded by text and fits well within the columns.
2. Wrapping Text Around Image:
o Select the image, click on "Wrap Text" under "Format," and choose "Square"
or "Tight" to ensure the text flows around the image smoothly.

Screenshot-32 Output of Newsletter

Hasmeet B.COM 1 A 38 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

QUESTION 7.
Convert following text to a table, using comma as delimiter Type the
following as shown (do not bold).
Color, Style, Item
Blue, A980, Van
Red, X023, Car
Green, YL724, Truck
Name, Age, Sex
Bob, 23, M
Linda, 46, F
Tom, 29, M

SOLUTION –

STEPS TO CREATE A TABLE IN MICROSOFT WORD:

1. Open Microsoft Word:
o Start a new blank document.
2. Select the Text:
o Highlight all the text you just typed.
3. Convert Text to Table:
o Go to the "Insert" tab.
o Click on "Table" in the Tables group.
o Select "Convert Text to Table..."
4. Set Up the Table:
o In the "Convert Text to Table" dialog box, make sure the following options are
selected:
▪ Number of columns: 3 (or select "AutoFit to contents" for automatic
column adjustment)
▪ Number of rows: It should automatically match the number of lines of
text.
▪ Separate text at: Choose "Commas"
o Click "OK" to convert the text into a table.
5. Format the Table:
o Adjust the column widths if necessary to ensure that all content is visible.
o Format the table using the Table Tools in the "Design" and "Layout" tabs as
needed.

Hasmeet B.COM 1 A 39 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-33 Output of a Table

Hasmeet B.COM 1 A 40 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

QUESTION 8.
Enter the following data into a table given below:

Salesperson Dolls Trucks Puzzles

Kennedy, Sally 1327 1423 1193
White, Pete 1421 3863 2934
Pillar, James 5214 3247 5467
York, George 2190 1278 1928
Banks, Jennifer 1201 2528 5467
Atwater, Kelly 4098 3079 1928
Pillar, James 5214 3247 1203
York, George 2190 1278 2067
Banks, Jennifer 1201 2528 5467
Atwater, Kelly 4098 3079 1928

Add a column Region (values: S, N, N, S, S, S) between the Salesperson and

Dolls columns to the given table Sort your table data by region and within
Region by Sales person in ascending order:
In this exercise, you will add a new row to your table, place the word Total at
the bottom of the Sales person column, and sum the Dolls, Trucks, and Puzzles
columns.

SOLUTION –
Steps to Create the Table in Microsoft Word:
1. Open Microsoft Word:
o Start a new blank document.
2. Insert a Table:
o Go to the "Insert" tab.
o Click on "Table" and select a 5x4 table (5 rows and 4 columns).
3. Enter the Data:
o Fill in the data as follows:
4. Add a Column for Region:
o Right-click the table and select "Insert" -> "Insert Columns to the Left."
o Enter "Region" in the new column header and fill in the values: S, N, N, S, S,
S.

Hasmeet B.COM 1 A 41 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

5. Sort the Table:

o Highlight the entire table.
o Go to the "Layout" tab under "Table Tools."
o Click on "Sort."
o Sort by "Region" first, then by "Salesperson" in ascending order.
6. Add a Total Row:
Click on the last row of the table.
Go to the "Layout" tab under "Table Tools."
Click "Insert Below" to add a new row.
In the new row, type "Total" in the Salesperson column.
Sum the Dolls, Trucks, and Puzzles columns.

Screenshot-34 Output of Table of Salesperson

Hasmeet B.COM 1 A 42 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 9. Wrapping of text around the image.

SOLUTION –
USING MICROSOFT WORD
1. Insert an Image:
o Go to the Insert tab and click Pictures to add your image.

2.
Click on the image to select it.
Go to the Format tab that appears when the image is selected.
Click Wrap Text in the Arrange group.
Choose a text wrapping option like Square, Tight, or Through.

USING GOOGLE DOCS

1. Insert an Image:
Click Insert > Image to add your image.

2.
Click on the image to select it.
Click on the text wrapping icon below the image.
Choose Wrap text and adjust the margins as needed.

Screenshot-35 Output of Wrapping of image

Hasmeet B.COM 1 A 43 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 10. How to install MS-Office in Windows operating

system?
SOLUTION –
STEPS TO INSTALL MICROSOFT OFFICE
1. Purchase or Sign In:
o If you haven't already purchased Microsoft Office, you can buy it from the
official Microsoft website or a trusted retailer.
o If you have already purchased Office, sign in to your Microsoft account.

2. Download Office:
o Go to the official Microsoft Office website (office.com).
o Sign in to your Microsoft account if you're not already signed in.
o Select "Install Office" and choose the version you want to install (e.g., Office
365, Office 2019).

3. Download the Installer:

o Click on the "Install Office" button.
o The installer will download automatically.

4. Run the Installer:

o Once the download is complete, open the installer file.
o Follow the prompts to install Office on your computer.

5. Complete the Installation:

o The installer will guide you through the installation process.
o Once the installation is complete, you can open any Office application (e.g.,
Word, Excel, PowerPoint) from the Start menu or desktop shortcut.

Hasmeet B.COM 1 A 44 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-36 Output of MS Office (Excel)

Hasmeet B.COM 1 A 45 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 11. How to convert word, excel and PowerPoint into

pdf & pdf to word?

SOLUTION –
CONVERTING WORD, EXCEL, AND POWERPOINT TO PDF
For Word to PDF:
1. Open the Word Document:
Open your Word document in Microsoft Word.

2. Go to 'File' Menu:
Click on the "File" tab in the upper-left corner.

3. Select 'Save As':

Choose the location where you want to save the PDF (e.g., This PC,
OneDrive).

4. Choose PDF Format:

In the "Save as type" dropdown menu, select "PDF (*.pdf)".

5. Click 'Save':
Click the "Save" button to convert your Word document to a PDF.

Screenshot-37 Output of Converting Word to pdf

Hasmeet B.COM 1 A 46 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

For Excel to PDF:

1. Open the Excel Workbook:
o Open your Excel workbook in Microsoft Excel.

2. Go to 'File' Menu:
o Click on the "File" tab in the upper-left corner.

3. Select 'Save As':

Choose the location where you want to save the PDF.

4. Choose PDF Format:

In the "Save as type" dropdown menu, select "PDF (*.pdf)".

5. Click 'Save':
Click the "Save" button to convert your Excel workbook to a PDF.

Screenshot-38 Output of Converting Excel to pdf

For PowerPoint to PDF:

1. Open the PowerPoint Presentation:
o Open your PowerPoint presentation in Microsoft PowerPoint.

2. Go to 'File' Menu:

Hasmeet B.COM 1 A 47 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Click on the "File" tab in the upper-left corner.

3. Select 'Save As':

o Choose the location where you want to save the PDF.

4. Choose PDF Format:

o In the "Save as type" dropdown menu, select "PDF (*.pdf)".

5. Click 'Save':
o Click the "Save" button to convert your PowerPoint presentation to a PDF.

Screenshot-39 Output of Converting PowerPoint to pdf

CONVERTING PDF TO WORD:

Using Microsoft Word:
1. Open Microsoft Word:
o Start Microsoft Word.
2. Open the PDF File:
o Go to the "File" tab and click "Export".
o Click on “Create PDF/XPS Document”.
o Locate and select the PDF file you want to convert.

3. Convert PDF to Word:

Hasmeet B.COM 1 A 48 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Word will prompt you that it will convert the PDF to an editable Word
document.
o Click "OK" or "Yes" to proceed with the conversion.

4. Save the Converted Document:

o After the conversion, go to the "File" tab, click "Save As", and save the
document in the Word format.

Screenshot-40 Output of Converting pdf to Word

Hasmeet B.COM 1 A 49 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

SECTION:03
MS-EXCEL

Hasmeet B.COM 1 A 50 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 1.
Enter the following data in Excel Sheet
REGIONAL SALES PROJECTION
State Qtr1 Qtr2 Qtr3 Qtr4 Qtr Total Rate Amount
Delhi 2020 2400 2100 3000 15
Punjab 1100 1300 1500 1400 20
U.P. 3000 3200 2600 2800 17
Haryana 1800 2000 2200 2700 15
Rajasthan 2100 2000 1800 2200 20
Total
Average

a. Apply Formatting as follow:

Title in TIMES NEW ROMAN
Font Size-14
Remaining text-ARIAL, Font Size-10
State name and Qtr. Heading Bold, Italic with Gray Fill Color.
Numbers in two decimal places.
Qtr. Heading in Center Alignment.
Apply Border to whole data.
b. Calculate State and Qtr. Total
c. Calculate Average for each quarter
d. Calculate Amount=Rate*Total.

SOLUTION –
To perform the calculations in Excel based on the data provided:

ENTER THE DATA:

2. Calculate State Total (Qtr Total):
o In cell F2 (Qtr Total for Delhi), enter the formula to sum the quarterly sales:
Excel=SUM (B2:E2)

Calculate Amount (Amount = Rate * Total):

o In cell H2 (Amount for Delhi), enter the formula to calculate the amount:
Excel=F2*G2

2. Calculate Qtr Totals:

Hasmeet B.COM 1 A 51 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o In cells B7 to E7 (Qtr Total row), enter the formulas to calculate the total sales
for each quarter:
Excel=SUM (B2:B6)

3. Calculate Averages for Each Quarter:

o In cells B8 to E8 (Average row), enter the formulas to calculate the average
sales for each quarter:
Excel=AVERAGE (B2:B6)

1. Select the Data Range:

Highlight the range of cells you want to format, including the Qtr1, Qtr2, Qtr3,
Qtr4, Qtr Total, and Amount columns.

2. Format Cells:
Right-click on the selected range and choose "Format Cells..." from the
context menu.

3. Number Formatting:
In the Format Cells dialog box, go to the "Number" tab.
Select "Number" from the category list.
Set the number of decimal places to 2.
Click "OK" to apply the formatting.

Screenshot-41 Output of Regional Sales Projection

Hasmeet B.COM 1 A 52 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 2.
Given the following worksheet
A B C D
1 Roll No. Name Marks Grade
2 1001 Sachin 99
3 1002 Sehwag 65
4 1003 Rahul 41
5 1004 Sourav 89
6 1005 Harbhajan 56

Calculate the grade of these students on the basis of following guidelines:

If Marks Then Grade
>=80 A+
>=60 and <80 A
>=50 and <60 B
<50 F
SOLUTION –
Here's how you can calculate the grades of students based on their marks using Excel:

1. Enter Your Data:

o Make sure you have entered the marks and student details as shown below:

2. Add a Column for Grades:

o Add a new column next to the Marks column and label it "Grade."

3. Enter the Formula:

o In the first cell of the Grade column (e.g., D2), enter the following formula to
calculate the grade based on the marks:
excel=IF(C2>=80, "A+", IF(C2>=60, "A", IF(C2>=50, "B", "F")))
o This formula checks the value in cell C2 (the Marks cell). If the marks are 80
or above, it assigns an "A+" grade. If the marks are between 60 and 79, it
assigns an "A" grade. If the marks are between 50 and 59, it assigns a "B"
grade. If the marks are below 50, it assigns an "F" grade.

4. Copy the Formula:

o Copy the formula from D2 down to the rest of the cells in the Grade column to
calculate grades for all students.

Hasmeet B.COM 1 A 53 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-42 Output of Grade of Students

Hasmeet B.COM 1 A 54 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 3.
Given the following worksheet
A B C D E F G
1 Salesman Sales in (Rs.)
2 No. Qtr1 Qtr2 Qtr3 Qtr4 Total Commission
3 S001 5000 8500 12000 9000
4 S002 7000 4000 7500 11000
5 S003 4000 9000 6500 8200
6 S004 5500 6900 4500 10500
7 S005 7400 8500 9200 8300
8 S006 5300 7600 9800 6100

Calculate the commission earned by the salesman on the basis of following

Candidates:
If Total Sales Then Commission
<20000 0% of sales
>20000 and <25000 4% of sales
>25000 and <30000 5.5% of sales
>30000 and <35000 8% of sales
>=35000 11% of sales
The total sales are the sum of sales of all the four quarters.

SOLUTION –
1. Enter the Sales Data:
o In cells A1 to G1, enter the headers:

2. Enter the Sales Figures:

o In rows 3 to 8, input the sales data for each salesman:

3. Calculate the Total Sales:

o In cell F3, enter the formula to calculate the total sales for S001:
excel=SUM (B3:E3)

4. Calculate the Commission:

o In cell G3, enter the formula to calculate the commission based on the total
sales:
excel=IF (F3<20000, 0, IF (F3<25000, F3*0.04, IF (F3<30000, F3*0.055, IF (F3<35000,
F3*0.08, F3*0.11))))

Hasmeet B.COM 1 A 55 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-43 Output of Sales

Hasmeet B.COM 1 A 56 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 4.
Create Payment Table for a fixed Principal amount, variable rate of interests and
time in the form at below:
No. of Instalments 5% 6% 7% 8% 9%
3 XX XX XX XX XX
4 XX XX XX XX XX
5 XX XX XX XX XX
6 XX XX XX XX XX

SOLUTION-
Step-by-Step Guide to Create the Payment Table in MS Excel:
1. Open Microsoft Excel:
Start a new blank workbook.
2. Create Headers:
In cell A1, type No. of Instalments.
In cell B1, type 5%.
In cell C1, type 6%.
In cell D1, type 7%.
In cell E1, type 8%.
In cell F1, type 9%.

3. Enter Rows for Number of Instalments:

In cell A2, type 3.
In cell A3, type 4.
In cell A4, type 5.
In cell A5, type 6.

4. Calculate Monthly Payments Using PMT Function:

o Assumptions:
▪ Let's assume a fixed principal amount of ₹100,000 (for example).
▪ The number of instalments will be in months.
o Use the PMT function to calculate the monthly payment for each interest rate
and number of instalments.

Hasmeet B.COM 1 A 57 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Formula for PMT:

=PMT (rate/12, nper, -principal)

Screenshot-44 Output of No. of Instalments

Hasmeet B.COM 1 A 58 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 5.
Use an array formula to calculate Simple Interest for given principal
amounts given the rate of Interest and time
Rate of Interest 8%
Time 5 Years
Principal Simple Interest
1000 ?
18000 ?
5200 ?

SOLUTION –
Simple Interest Formula
Simple Interest=P×R×T100\text {Simple Interest} = \frac {P \times R \times T}{100}
Where:
PP is the principal amount
RR is the rate of interest per annum
TT is the time period in years

Data Entry
1. Enter the Headers and Data:
Set up your Excel sheet as follows:

2. Calculate Simple Interest:

In the cell next to the principal amount (e.g., C4 for the first principal), enter
the formula to calculate the simple interest:
excel=A4 * $B$1 * $B$2 / 100

Hasmeet B.COM 1 A 59 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-45 Output of Rate of Interest

Hasmeet B.COM 1 A 60 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 6.
The following table gives a year wise sale figure of five salesmen in
Rs.
Salesman 2019 2020 2021 2022
S1 10000 12000 20000 50000
S2 15000 18000 50000 60000
S3 20000 22000 70000 70000
S4 30000 30000 100000 80000
S5 40000 45000 125000 90000

a. Calculate total sale year wise.

b. Calculate the net sale made by each salesman.
c. Calculate the maximum sale made by the salesman.
d. Calculate the commission for each salesman under the condition.
>> If total sales > 4,00,000 give 5% commission on total sale
made by the salesman.
>> Otherwise give 2% commission.
e. Draw a bar graph representing the sale made by each salesman.
f. Draw a pie graph representing the sale made by a salesman in 2000.

SOLUTION –
CALCULATIONS:
a. Calculate Total Sales Year-wise:
• In cell B7, enter the formula to calculate total sales for 2019:
excel=SUM (B2:B6)

b. Calculate Net Sale Made by Each Salesman:

• In cell F2, enter the formula to calculate the total sales by each salesman:
excel=SUM (B2:E2)

c. Calculate the Maximum Sale Made by a Salesman:

• In cell F7, enter the formula to find the maximum total sales:
excel=MAX (F2:F6)

d. Calculate the Commission for Each Salesman:

Hasmeet B.COM 1 A 61 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

• In cell G2, enter the formula to calculate the commission:

excel=IF(F2>400000, F2*0.05, F2*0.02)

Screenshot-46 Output of Salesman

DRAWING THE GRAPHS:

e. Draw a Bar Graph Representing the Sale Made by Each Salesman:
1. Select the range A2:E6.
2. Go to the "Insert" tab.
3. Choose "Bar Chart" from the Charts group.
4. Format the chart as needed.

Hasmeet B.COM 1 A 62 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Chart Title
₹ 1,40,000.00

₹ 1,20,000.00

₹ 1,00,000.00

₹ 80,000.00

₹ 60,000.00

₹ 40,000.00

₹ 20,000.00

₹-
S1 S2 S3 S4 S5

Series1 Series2 Series3 Series4

Screenshot-47 Output of Bar Graph

f. Draw a Pie Chart Representing the Sale Made by a Salesman in 2022:

1. Make another separate table with Salesman and 2022 data being side by side.
2. Select the range J2:J6 and K2:K6.
3. Go to the "Insert" tab.
4. Choose "Pie Chart" from the Charts group.
5. Format the chart as needed.

Screenshot-8 Output of Salesman of 2022

Hasmeet B.COM 1 A 63 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Chart Title

Salesman S1 S2 S3 S4 S5

Screenshot-49 Output of Pie Chart

Hasmeet B.COM 1 A 64 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 7.
Enter the following data in Excel Sheet
PERSONAL BUDGET FOR FIRST QUARTER
Monthly Income (Net): 1,475
EXPENSES JAN FEB MARCH QUARTER
QUARTER AVERAGE
TOTAL
Rent 600.00 600.00 600.00
Telephone 48.25 43.50 60.00
Utilities 67.27 110.00 70.00
Credit Card 200.00 110.00 70.00
Oil 100.00 150.00 90.00
AV to Insurance 150.00
Cable TV 40.75 40.75 40.75
Monthly Total

a. Calculate Quarter total and Quarter average.

b. Calculate Monthly total.
c. Surplus=Monthly Income-Monthly total.
d. What would be the total surplus if monthly income is 1500.
e. How much does the telephone expense for March differ from quarter
average?
f. Create a 3D column graph for telephone and utilities.
g. Create a pie chart for monthly expenses.

SOLUTION –

Personal Budget for First Quarter

Data Entry:

1. Enter the Headers and Data:

o Set up your Excel sheet as follows:

2. Calculate Quarter Total and Quarter Average:

o For each expense, in the "QUARTER TOTAL" column, use the formula to
sum the values for January, February, and March. For example, in cell E2
(Quarter Total for Rent):

Hasmeet B.COM 1 A 65 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

excel=SUM (B2:D2)

o For each expense, in the "QUARTER AVERAGE" column, use the formula to
calculate the average for the quarter. For example, in cell F2 (Quarter Average
for Rent):

excel=AVERAGE (B2:D2)

3. Calculate Monthly Total:

o In the "Monthly Total" row, sum the monthly expenses. For example, in cell
B9 (Monthly Total for January):

excel=SUM (B2:B8)

4. Calculate Surplus:
o Surplus = Monthly Income - Monthly Total. For example, in cell B10 (Surplus
for January):

excel=1475 - B9

5. Total Surplus if Monthly Income is ₹1500:

o Adjust the surplus calculation by changing the monthly income in the formula.
For example, in cell B11 (Surplus for January with ₹1500 income):

excel=1500 - B9

6. Difference of Telephone Expense for March from Quarter Average:

o Calculate the difference between March's telephone expense and the quarter
average. In cell G3:

excel=D3 - F3

GRAPHS:

a. 3D Column Graph for Telephone and Utilities:

1. Select the data range A3:D4 (Telephone and Utilities for all three months).

2. Go to the "Insert" tab.

3. Choose "3D Column" from the Charts group.

b. Pie Chart for Monthly Expenses:

1. Select the data range A2:B8 for January (excluding totals and averages).

Hasmeet B.COM 1 A 66 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

2. Go to the "Insert" tab.

3. Choose "Pie Chart" from the Charts group.

Difference for March Telephone Expense:

• In cell G3:
excel=60.00 - 50.58 = 9.42

c. Calculate the Total Surplus if the Monthly Income is ₹1500

1. Surplus (₹1500):
o In cell B10, enter the formula for the surplus with a monthly income of ₹1500:

excel=1500 - B9

2. Example Calculation:
For January:

excel=1500 - 1206.27 = 293.73

For February:

excel=1500 - 1054.25 = 445.75

For March:

excel=1500 - 930.75 = 569.25

d. Calculate the Difference for March Telephone Expense from Quarter

Average

3. Difference Calculation:
o In cell G3 (assuming G3 is the appropriate cell for difference calculation):

excel=D3 - F3

o Example Calculation for March:

excel=60.00 - 50.58 = 9.42

Updated Graphs and Calculations:

e. 3D Column Graph for Telephone and Utilities:

Hasmeet B.COM 1 A 67 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

1. Select the data range A3:D4 (Telephone and Utilities for all three months).

2. Go to the "Insert" tab.

3. Choose "3D Column" from the Charts group and create the chart.

f. Pie Chart for Monthly Expenses in January:

1. Select the data range A2:B8 for January (excluding totals and averages).

2. Go to the "Insert" tab.

3. Choose "Pie Chart" from the Charts group and create the chart.

g. Difference of Telephone Expense for March from Quarter Average:

Calculate the difference for March's telephone expense compared to the quarter
average. In cell G3:

excel=D3 - F3

The calculation will be:

excel=60.00 - 50.58 = 9.42

Screenshot-50 Output of Expenses (including 3-D Column and Pie Chart)

Hasmeet B.COM 1 A 68 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

QUESTION 8.
Enter the following data in Excel Sheet

TOTAL REVENUE EARNED FOR SAM’S BOOK STALL

Publisher Name 1997 1998 1999 2000 Total

A Rs.1,000.00 Rs.1100.00 Rs.1,300.00 Rs.800.00

B Rs.1,500.00 Rs.700.00 Rs.1,000.00 Rs.2000.00
C Rs.700.00 Rs.900.00 Rs.1,500.00 Rs.600.00
D Rs.1,000.00 Rs.200.00 Rs.200.00 Rs.1,100.00
a) Compute the total revenue earned.
b) Plot the line chart to compare the revenue of all publishers for 4 years.
c) Chart Title should be Total Revenue of Sam’s Book Stall (1997-2000)
d) Give appropriate categories and value axis title.

SOLUTION –
Data Entry:
1. Enter the Data:
o Set up your Excel sheet with the following data:

a. Compute the Total Revenue Earned:

1. Total Revenue:
o In the "Total" column, use the formula to calculate the total revenue for each
publisher. For example, in cell F2 (Total for Publisher A):

excel

=SUM(B2:E2)

b. Plot the Line Chart:

1. Create the Line Chart:

o Select the data range A1:E5.

o Go to the "Insert" tab.

o Choose "Line Chart" from the Charts group and select "Line with Markers."

Hasmeet B.COM 1 A 69 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

c. Chart Title:

1. Add Chart Title:

o Click on the chart title and enter "Total Revenue of Sam's Book Stall (1997-
2000)."

d. Axis Titles:
1. Add Axis Titles:
Click on the chart to select it.

Go to the "Chart Design" tab.

Click on "Add Chart Element," then "Axis Titles," and add titles for both the
horizontal and vertical axes.

Enter "Years" for the horizontal axis.

Enter "Revenue (Rs.)" for the vertical axis.

Chart Visualization:
Title: Total Revenue of Sam's Book Stall (1997-2000)

Horizontal Axis Title: Years

Vertical Axis Title: Revenue (Rs.)

Hasmeet B.COM 1 A 70 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-51 Output of Sam’s Book Stall

Total Revenue of Sam's Book Stall (1997-2000)

2500

2000
Revenue (in Rs.)

1500

1000

500

0
Publisher Name A B C D
Years

Series1 Series2 Series3 Series4

Screenshot-52 Output of Line Chart

Hasmeet B.COM 1 A 71 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

SECTION:04
MS-Power Point

Hasmeet B.COM 1 A 72 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 1.
Do the following text:
• Start a new blank presentation
• Your first Slide is going to be a Title Slide
• Write the Text as in preview below:
o Lighthouse Co Ltd
o Make the font of “Lighthouse” Arial Black and size 88
• Insert a second slide this should be with a layout of Bulleted List
• Write the Text as in preview below
• [Title]: Lighthouse Co Ltd
• [Body]:
i. Mission Statement
ii. Company Objectives
iii. Management Team
iv. Employees
v. Sales
Make the Font Color of the Points to Green
Insert a third slide that should be an Organization Chart.
Include the following people in the chart:
a. David Brent, General Manager
b. Tim Canterbury, Head of Sales
c. Gareth Keenan, Assistant to the General Manager
d. Dawn Tinsley, Human Resources Manager
Add a fourth slide and this should be a Table Chart.
The chart should look like the following:
New Products Discontinued Products
Digital Cameras 8mm Cameras
Ultra Slim Video Camera 8x Zoom Video Camera
25 “Plasma TVs21” Black and White TVs
DVD Recorders Video Players
7.1 Dolby Surround Systems 2 channel stereo systems
o Make the titles New Products and Discontinued Products with a shadow
effect and centered in the cell. Widen columns to fit Text as above.
• The Fifth slide should be a Chart slide. The chart should be a bar
chart, and include the following data must be used to form the chart:
January February March April
TVs 20 27 90 75
DVDs 30 38 34 31
Wifi equipment 45 46 45 43
Video Recorders 25 29 15 40

Hasmeet B.COM 1 A 73 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

• Change the colours of the chart so that the series of bars are red,
yellow, pink and green.
• Add a light-coloured background to all slides in the presentation.
• Add also Transition effects between each slide and also different
effects for all
• text and pictures in the presentation. Reverse the order of the second
and third slides
• Save the presentation as Light House Ltd.

SOLUTION –
STEP-BY-STEP GUIDE TO CREATE A POWERPOINT
PRESENTATION
1. Start a New Blank Presentation
• Open Microsoft PowerPoint.
• Select "Blank Presentation" to start a new presentation.

2. Title Slide
• Click on the "Title Slide" layout.
• Enter the title "Lighthouse Co Ltd".
• Below the title, list the following points:
1. Mission Statement
2. Company Objectives
3. Management Team
4. Employees
5. Sales
• Highlight these points and change the font color to green.

3. Insert Second Slide (Initially Third Slide) - Organization Chart

• Click on the "New Slide" button and select "Title and Content" layout.
• Enter the title "Organization Chart".
• Insert an organizational chart by going to "Insert" -> "SmartArt" -> "Hierarchy" and
select "Organization Chart".

• Fill in the following people:

o David Brent, General Manager

Hasmeet B.COM 1 A 74 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Tim Canterbury, Head of Sales

o Gareth Keenan, Assistant to the General Manager
o Dawn Tinsley, Human Resources Manager

4. Insert Third Slide (Initially Second Slide) - Table Chart

• Click on the "New Slide" button and select "Title and Content" layout.
• Enter the title "Product Chart".
• Insert a table by going to "Insert" -> "Table".
• Create a table with 2 columns and 5 rows and fill in the following data:
• Make the titles "New Products" and "Discontinued Products" have a shadow effect
and center the text in the cells.
• Adjust the column width to fit the text.

5. Insert Fourth Slide - Bar Chart

• Click on the "New Slide" button and select "Title and Content" layout.
• Enter the title "Sales Data".
• Insert a bar chart by going to "Insert" -> "Chart" -> "Bar".
• Enter the following data in the chart:
• Change the bar colors to red, yellow, pink, and green respectively.

6. Reorder Slides
• Rearrange the slides by dragging the slide thumbnail for the organization chart to the
position after the title slide.

7. Save the Presentation

• Save the presentation by going to "File" -> "Save As".
• Enter the file name "Light House Ltd" and choose a location to save the file.
• Click "Save".

Hasmeet B.COM 1 A 75 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-53 Output of Lighthouse Co Ltd

Screenshot-54 Output of Lighthouse Co Ltd

Hasmeet B.COM 1 A 76 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-55 Output of Lighthouse Co Ltd

Screenshot-56 Output of Lighthouse Co Ltd

Hasmeet B.COM 1 A 77 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-57 Output of Lighthouse Co Ltd

Hasmeet B.COM 1 A 78 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 2.
Do the following:
Load your Presentation Application and start a new presentation
• The first slide is a Title Slide. Select the appropriate layout and
enter the title: ‘Annual Food Fair’
• Add the subtitle: A Celebration of Eating
• Insert a small, red circle at the bottom right of the title slide.
• Change the font color for the whole title and subtitle to blue, and
apply a text shadow effect just to the words Food and Fair.
• Insert a second slide to the presentation, selecting a layout
appropriate for a series of bullet points, and using the title: The
Menu. Enter the following text:
i. Chocolate Desserts
ii. Cakes and Puddings
iii. Roast Meals
iv. Using Pasta Creatively
• Change the line spacing for these bullet points to 1.5 lines.
• Increase the font size for the words The Menu in the title.
• Add a footer with your name and the text: Food Fair so they both appear
on every slide, and number all the slides. (Make sure the number is not
obscured by the red circle on the title slide)
• Insert a third slide, which is to be an organization chart. Use the title Meet
The Team. Enter: Maggie Peet, Manager at the top of the chart, and show
the following three as reporting to Maggie Peet: Brian Webb, Bookings,
Janine Newton, Publicity; Gregg Brown, Accounts
• Embolden the text in the title of the third slide, and change the font to
Arial.
• Apply a light-coloured background to all the slides in the presentation
• On the third slide, insert an image suitable for the topic of food from an
image library. Reduce the size of the image and place it where it will not
interfere with text.
• Save the presentation as Food Fair.
• Print the presentation with three slides per page, and close the
presentation.
SOLUTION –
STEP-BY-STEP GUIDE TO CREATING A POWERPOINT
PRESENTATION:

Hasmeet B.COM 1 A 79 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

1. Open Microsoft PowerPoint:

o Start a new blank presentation.

2. Create the Title Slide:

o Select the "Title Slide" layout.
o Enter the title as "Annual Food Fair."
o Add the subtitle "A Celebration of Eating."
o Insert a small red circle at the bottom right of the title slide:
▪ Go to the "Insert" tab.
▪ Click on "Shapes" and select the circle shape.
▪ Draw a small circle at the bottom right corner.
▪ Right-click on the circle, choose "Format Shape," and change the fill
color to red.
o Change the font color for the title and subtitle to blue:
▪ Highlight the text.
▪ Go to the "Home" tab and select blue from the "Font Color" drop-
down.
▪ Apply a text shadow effect to the words "Food" and "Fair":
▪ Highlight "Food" and "Fair."
▪ Go to the "Text Effects" drop-down in the "Home" tab.
▪ Select "Shadow" and choose the desired shadow effect.

3. Insert Second Slide for the Menu:

o Insert a new slide with the "Title and Content" layout.
o Enter the title as "The Menu."
o Increase the font size for "The Menu" in the title:
▪ Highlight the title text.
▪ Go to the "Home" tab and adjust the font size.
o Add the following bullet points with 1.5 line spacing:
1. Chocolate Desserts
2. Cakes and Puddings
3. Roast Meals
4. Using Pasta Creatively

Hasmeet B.COM 1 A 80 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Highlight the bullet points.

o Go to the "Line Spacing" option in the "Home" tab and select 1.5.

4. Insert Third Slide for the Organization Chart:

o Insert a new slide with the "Title and Content" layout.
o Enter the title as "Meet The Team."
o Embolden the text in the title and change the font to Arial:
▪ Highlight the title text.
▪ Go to the "Home" tab, select "Bold," and choose "Arial" font.
o Insert an organization chart:
▪ Go to the "Insert" tab.
▪ Click on "SmartArt" and select "Hierarchy."
▪ Choose the "Organization Chart" option and fill in the details:
▪ At the top: Maggie Peet, Manager
▪ Reporting to Maggie Peet: Brian Webb, Bookings; Janine
Newton, Publicity; Gregg Brown, Accounts
o Insert an image related to food:
▪ Go to the "Insert" tab.
▪ Click on "Pictures" and choose an image from your library.
▪ Resize the image and place it where it doesn't interfere with the text.

5. Apply a Light-Coloured Background:

o Go to the "Design" tab.
o Select "Format Background."
o Choose a light color for the background.

6. Add Footer with Name and Text:

o Go to the "Insert" tab.
o Click on "Header & Footer."
o Check "Footer" and enter your name and "Food Fair."
o Check "Slide number" to add slide numbers.
o Ensure the number is not obscured by the red circle on the title slide.
o Apply to all slides.

Hasmeet B.COM 1 A 81 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

7. Save the Presentation:

o Go to the "File" tab.
o Click on "Save As."
o Enter the file name "Food Fair" and select the location to save the file.
o Click "Save."

Screenshot-58 Output of Food Fair

Screenshot-59 Output of Food Fair

Hasmeet B.COM 1 A 82 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-60 Output of Food Fair

Hasmeet B.COM 1 A 83 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 3.
Do the followings:
• Load your Presentation Application and start a new presentation
• The first slide is a Title Only Slide. Select the appropriate layout and
enter the title Cook Family Cruises.
• Add a small blue rectangle at the top left of this slide. Change the font
color for the whole title to red, and apply a text shadow effect just to the
word Cruises.
• Insert a second slide to the presentation, selecting a layout appropriate
for a series of bullet points, and using the title: Our Itinerary. Enter the
following text:
a. Canary Islands
b. Mediterranean
c. Greek Islands
• Change the line spacing for these bullet points to 2 lines. Increase the font
size of the word Itinerary in the title. Add a footer with your name and the
text: Cruise Information so they both appear on every slide, and number
all the slides.
• Insert a third slide, which is to be a graph. Use the title Our Market Share.
Use the following data to produce a pie chart: Cook 54%; Jackson 28%;
Wilson 12%; Bennett 5%
Embolden the text in the title of the third slide, and change the font to
Arial.
• Apply a different t background to each slide in the presentation.
• On the third slide, insert an image suitable for the topic of holidays from
an image library. Reduce the size of the image and place it where it will
not interfere with text.
Add a 4-slide containing nothing but the text: Travel with us for less!!
• Save the presentation as a holiday.
• Print the presentation with 4 slides per page, and close the
presentation.
SOLUTION –
STEP-BY-STEP GUIDE TO CREATING A POWERPOINT
PRESENTATION:
1. Start a New Presentation
• Load your Presentation Application: Open Microsoft PowerPoint.

Hasmeet B.COM 1 A 84 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

• Start a New Presentation: Click on "Blank Presentation".

2. Title Slide
• Select the Title Slide Layout: Click on "Layout" and select "Title Slide".
• Enter the Title: Type "Cook Family Cruises" in the title box.
• Add a Blue Rectangle:
o Go to the "Insert" tab.
o Click on "Shapes" and select the rectangle shape.
o Draw a small rectangle at the top left of the slide.
o Right-click on the rectangle, select "Format Shape", and change the fill color
to blue.
• Change Font Color and Apply Shadow:
o Highlight the title text.
o Go to the "Home" tab, click on "Font Color" and select red.
o Highlight only the word "Cruises".
o Go to the "Text Effects" drop-down, select "Shadow", and choose a shadow
effect.

3. Our Itinerary Slide

• Insert a New Slide: Click on "New Slide" and select "Title and Content" layout.
• Enter the Title: Type "Our Itinerary" in the title box.
• Enter Bullet Points:
o In the content box, type:
▪ "Canary Islands"
▪ "Mediterranean"
▪ "Greek Islands"
• Change Line Spacing and Font Size:
o Highlight the bullet points.
o Go to the "Home" tab, click on "Line Spacing" and select 2.0.
o Highlight the word "Itinerary" in the title.
o Increase the font size from the "Font Size" drop-down.
• Add Footer:
o Go to the "Insert" tab, click on "Header & Footer".

Hasmeet B.COM 1 A 85 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

o Check the box for "Footer" and type your name and "Cruise Information".
o Check "Apply to All" to ensure it appears on every slide.
o Add slide numbers by checking "Slide number".

4. Our Market Share Slide

• Insert a New Slide: Click on "New Slide" and select "Title and Content" layout.
• Enter the Title: Type "Our Market Share" in the title box.
Create Pie Chart:
Go to the "Insert" tab, click on "Chart" and select "Pie".
Enter the data:
Cook: 54%
Jackson: 28%
Wilson: 12%
Bennett: 5%
Bold and Change Font:
Highlight the title text.
Click on the "Bold" icon and change the font to Arial.
Insert Image:
Go to the "Insert" tab, click on "Pictures" and select an image related to
holidays.
Resize and place the image where it does not interfere with the text.

5. Travel with Us Slide

Insert a New Slide: Click on "New Slide" and select "Title Only" layout.
Enter the Text: Type "Travel with us for less!!" in the title box.

6. Customize Backgrounds
Apply Backgrounds:

o Go to the "Design" tab.

o Click on "Format Background".
o Choose a different background for each slide.

7. Save the Presentation

• Save the File:

Hasmeet B.COM 1 A 86 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Go to the "File" tab, click on "Save As".

o Enter the file name "holiday".
o Choose the location to save the file.
o Click "Save".

Screenshot-61 Output of Holiday

Screenshot-62 Output of Holiday

Hasmeet B.COM 1 A 87 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-11 Output of Holiday

Screenshot-12 Output of Holiday

Hasmeet B.COM 1 A 88 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 4. Creating an animation looks like the leaf is falling

from a tree.

SOLUTION-
STEP-BY-STEP GUIDE TO CREATE A LEAF FALLING
ANIMATION IN MS POWERPOINT:
1. Open Microsoft PowerPoint:
• Start a new blank presentation.

2. Insert a Background Image:

• Add a Tree Background Image:
o Go to the "Insert" tab.
o Click on "Pictures" and select a background image with a tree (you can use an
image from your library or find one online).

3. Insert a Leaf Image:

• Add a Leaf Image:
o Go to the "Insert" tab.
o Click on "Pictures" and select a leaf image.
o Resize the leaf image to your desired size.

4. Position the Leaf:

• Place the Leaf on the Tree:
o Click on the leaf image and drag it to the starting position on the tree.

5. Add Custom Path Animation:

• Apply Custom Path Animation:
o Click on the leaf image to select it.
o Go to the "Animations" tab.
o Click on "Add Animation" and select "Custom Paths."
o Choose the "Down" motion path.

6. Customize the Custom Path:

• Edit the Custom Path:

Hasmeet B.COM 1 A 89 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

o Click on the animation path to customize it.

o Drag the red endpoint to create a curving path that simulates the natural fall of
a leaf.
o You can adjust the curve by adding additional points along the path:
▪ Right-click on the motion path line, select "Edit Points," and drag the
points to create a more realistic path.

7. Preview the Animation:

Preview Your Animation:
Click on the "Slide Show" tab.
Click on "From Current Slide" to preview how the leaf falls from the tree.

8. Save Your Presentation:

Save Your Work:
Go to the "File" tab.
Click on "Save As" and choose a location to save your presentation.
Name your file and click "Save."

Screenshot-65 Output of leaf falling from tree

Hasmeet B.COM 1 A 90 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-66 Output of leaf falling from tree

Screenshot-67 Output of leaf falling from tree

Hasmeet B.COM 1 A 91 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

SECTION:05
MS-ACCESS

Hasmeet B.COM 1 A 92 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 1.
Create a database named “college” and perform the following
tasks:
A. Create a table named “student” having following fields:
Class, Roll no and Name with these Information i.e., Field Name, Data
type and Description
B. Fill at least 5 records.
C. Prepare a query to display all records and Name should be in ascending
order.
SOLUTION –
STEP-BY-STEP GUIDE TO CREATE A DATABASE IN MS
ACCESS
1. Open Microsoft Access:
• Start MS Access and select "Blank Database."

2. Create a New Database:

• Name the database "college" and click "Create."

3. Create a Table:
• Create a Table Named "student":
o Open the new database.
o Click on the "Table Design" icon in the "Tables" group.
o Enter the fields and their data types as follows:
▪ Field Name: Class
▪ Data Type: Short Text
▪ Description: Class of the student
▪ Field Name: Roll no
▪ Data Type: Number
▪ Description: Roll number of the student
▪ Field Name: Name
▪ Data Type: Short Text
▪ Description: Name of the student
o Set the "Roll no" field as the primary key:

Hasmeet B.COM 1 A 93 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

▪ Right-click on the "Roll no" field and select "Primary Key."

o Save the table as "student."

4. Enter Records into the "student" Table:

• Open the "student" table in Datasheet View.
• Enter at least 5 records, such as:

5. Prepare a Query to Display All Records with Names in Ascending Order:

Create a Query:
Go to the "Create" tab.
Click on the "Query Design" icon in the "Queries" group.
Add the "student" table to the query design window.
Drag the fields (Class, Roll no, Name) to the query grid.
Sort the "Name" field in ascending order:
In the "Sort" row under the "Name" column, select "Ascending."
Run the query by clicking the "Run" button (red exclamation mark).
Save the query as "Student Name Ascending."

Screenshot-68 Output of Database College

Hasmeet B.COM 1 A 94 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-69 Output of Database College

Hasmeet B.COM 1 A 95 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

QUESTION 2.
Create the employee table in MS-Access with the referential integrity-foreign
key.
Note: This is a tentative list; the teachers’ concern can add more program as per
requirement.
SOLUTION –
STEP-BY-STEP GUIDE TO CREATING AN EMPLOYEE
TABLE IN MS ACCESS:
1. Open Microsoft Access:
• Start MS Access and select "Blank Database".

2. Create a New Database:

• Name the database "company" and click "Create".

3. Create the employee Table:

• Create the employee Table:
o Open the new database.
o Click on the "Table Design" icon in the "Tables" group.
o Enter the fields and their data types as follows:
▪ Field Name: Employee ID
▪ Data Type: AutoNumber
▪ Description: Unique ID for the employee
▪ Field Name: FirstName
▪ Data Type: Short Text
▪ Description: First name of the employee
▪ Field Name: LastName
▪ Data Type: Short Text
▪ Description: Last name of the employee
▪ Field Name: Department ID
▪ Data Type: Number
▪ Description: ID of the department (foreign key)
o Set the "Employee ID" field as the primary key:

Hasmeet B.COM 1 A 96 | P a g e
saluja
 Computer Fundamental and MS Office 2024-2025

▪ Right-click on the "Employee ID" field and select "Primary Key".

o Save the table as "employee".

4. Create the department Table:

• Create the department Table:
o Open the new database.
o Click on the "Table Design" icon in the "Tables" group.
o Enter the fields and their data types as follows:
▪ Field Name: Department ID
▪ Data Type: AutoNumber
▪ Description: Unique ID for the department
▪ Field Name: Department Name
▪ Data Type: Short Text
▪ Description: Name of the department
o Set the "Department ID" field as the primary key:
▪ Right-click on the "Department ID" field and select "Primary Key".
o Save the table as "department".

5. Establish Relationships:
• Add Referential Integrity:
o Go to the "Database Tools" tab.
o Click on "Relationships".
o Add both the "employee" and "department" tables to the Relationships
window.
o Drag the "Department ID" field from the "department" table to
the"Department ID" field in the "employee" table.
o In the Edit Relationships dialog box, check "Enforce Referential Integrity" and
"Cascade Update Related Fields" if necessary.
o Click "Create" to establish the relationship.

6. Enter Records into the department Table:

• Open the "department" table in Datasheet View.
• Enter at least 3 records, such as:

Hasmeet B.COM 1 A 97 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

7. Enter Records into the employee Table:

• Open the "employee" table in Datasheet View.

Screenshot-70 Output of Employee Database

Screenshot-71 Output of Database Employee

Hasmeet B.COM 1 A 98 | P a g e
saluja
Computer Fundamental and MS Office 2024-2025

Screenshot-72 Output of Database Employee

Screenshot-73 Output of Database Employee

Hasmeet B.COM 1 A 99 | P a g e
saluja