IT 101 Midterm Exam Part 2 Hands On

Republic of the Philippines
BATANGAS STATE UNIVERSITY

COLLEGE OF ACCOUNTANCY BUSINESS ECONOMICS AND
INTERNATIONAL HOSPITALITY MANAGEMENT
CITE Building, Pablo Borbon Main 1, Rizal Avenue, Batangas City
Name: ________________________________ Score: ______________________________

SR Code: ______________________________ Class Schedule: ______________________
MIDTERM EXAMINATION
IT 101: IT APPLICATION TOOLS IN BUSINESS
PART II: HANDS-ON EXAMINATION FOR LABORATORY PART (90 points)
Direction: Perform the following activities using the Microsoft Word, Excel and PowerPoint in your respective computer
devices. Please follow the instructions given for each package in order to arrive in a single and required output. You only
have one (1) day to finish this hands-on examination. Please budget your time. GOODLUCK!
I. MICROSOFT WORD (30 points)

Create a Business Letter
Instructions:
(i). Type the company name and address
Open a blank Microsoft Word document. Type the following information:
Batangas State University
Rizal Avenue, Batangas City
Batangas City, 4200
(ii). Select All of the text and use the Font options to format the type:
Tahoma, 12 font size, bold, centered, and dark red
(iii). Use the official logo of BatStateU for company logo

Resize the picture
Center it above the Company name and address

(iv). Type a sample business letter:
Dear Dr. Ronquillo,

Write in complete sentences and in paragraph form (add indention to the first sentence) 10 things you like about
Batangas State University.

Sincerely,

Your Name
(iv). Format the business letter as follows:

Select All of the text and use the Font options:
Times New Roman, 12 font size, bold, left alignment, justified.
Upload your output to Google Classroom using cas file name.
II. MICROSOFT EXCEL (30 points)
A. Using Sheet 1 and the data given, follow the instructions given below: (10 points)
III.
A B C D E F G
1 Mon Tue Wed Thur Fri TOTAL
2 Breakfast 3,560 3,186 2,952 3,395 3,436
3 Lunch 20,163 21,416 19,912 19,681 18,628
4 Bar 9,873 12,172 12,642 12,711 18,846
5 Snacks 2,405 3,544 2,694 3,120 3,712
6 TOTALS
Instructions:
(i). Calculate the totals for each meal and get the grand total.
(ii). Format the Sheet 1 as follows:
Just follow the format used for the appearance given in the table above, but make all the “Totals” bold, two decimal
places, comma, insert rows above Row number 1 and merge the cells above using the caption “TITLE” across
columns A-G and make it size 16, bold, Italic and Times New Roman.
(iii). Rename the Sheet 1 as Req A.
B. Using Sheet 2 and the data given, follow the instructions given below: (10 points)
A B C D E F G H I
1 XYZ COMPANY SALES PERFORMANCE
2
3
4 SALESPERSON ANNUAL QTR1 QTR2 QTR3 QTR4 TOTAL AVERAGE
TARGET SALES SALES COMMISSION
5
6 ALBERT 750 148 256 133 154 X
7 MICHAEL 650 187 143 258 143 X
8 CARL 800 233 200 216 152 X
9 GEORGE 700 256 145 136 259 X
10 LUCY 1,000 249 212 215 124 X
11
12 TOTAL X X X X X X
13
14 COMMISSION 6% of
Total sales
15
Instructions:
(i). Given the table above, write formulas or describe how you would calculate the Total Sales in column G and Row
12.
(ii). Calculate the Average Sales. Provide the formula as it should appear in formula bar in Excel.
(iii). Calculate the Commission. Provide the formula as it would appear in formula bar in Excel.
(iv). Format the Sheet 2 as follows:
Just follow the format used for the appearance given in the table above, but make all the “Totals” bold, two decimal
places and commas.
(v). Rename the Sheet 2 as Req B.
C. Using Sheet 3 and from the data given in the table below: (10 points)
A B C D E F
1 ABC Company Sales Performance Report
2
3 Salesman Qtr1 Qtr2 Qtr3 Qtr4 Total
4 Albert 148 156 171 140 615
5 Carl 122 131 153 118 524
6 Cornell 211 243 246 250 950
7 Edwin 129 150 92 218 589
8 Francis 311 270 247 322 1,150
Instructions:
(i) Create a Pie Chart to show the distribution of the total amount amongst the various salesmen.
(ii) Rename the Sheet 3 as Req C.
(iii) Upload your outputs to Google Classroom using “Midterm Hands-On Examination_Last name, First
name_Section_MS EXCEL” as file name.
III. MICROSOFT POWERPOINT (30 points)

Instructions:
Slide #1
After you select PowerPoint, you will be presented with your first PPT Slide.
Click in the “Click to add title” section and type using your keyboard keys “Microsoft”
Click in the “Click to add subtitle” section and type using your keyboard keys the following:
A Corporate Research Project
Presented by (key in your name)
Slide #2
Click in the “Click to add title” section and type using your keyboard keys “Introduction”
Click in the “Click to add text” section and key in the following:
Description of Business
History
Major Competitors
Slide #3
Click in the “Click to add title” section and type using your keyboard keys “Top Corporate Management”
Click in the “Click to add text” section and key in the following:
William H. Gates, III
Chairman of the Board
Richard F. Rashid
Senior Vice President, Research
Steve A. Ballmer
President and Chief Executive Office
John Connors
Senior Vice President and Chief Financial Officer
Slide #4
In “Click to add title” section and type using your keyboard keys “Microsoft Culture”
In “Click to add text” section and type using your keyboard keys the following:
Innovative
Creative
Intense
Non-Traditional
Competitive
Slide #5
In “Click to add title” section key in “Revenues and Net Income History”
In “Click to add text” section and enter the following data inside a table.
2016 2017 2018

Net Revenues $22,956 $25,296 $28,365
Net Income 9,421 7,346 7,829
Slide #6
In “Click to add title” section, key in “Segment Revenue for 2018” and align center
In “Click to add text” section key in the following:
Desktop and Enterprise Software and Services $23,786
Consumer Software and Services 3,531
Consumer Commerce and Investments 245
Other 537
Reconciling Amounts 266
Total Revenue $28,365
Slide #7
In “Click to add title” section key in “Microsoft and the Accounting Equation – 2018”
In the “Click to add text” box key in the following:
Assets = Liabilities + Stockholders’ Equity

$67,646 $15,466 $52,180
Slide #8
In “Click to add title” section, key in “Common Stock Growth Potential”
In the “Click to add text” section key in the following bullets:
Growth is strong
Company is aggressively expanding
Revenue is expanding
New products are being developed
Slide #9
In “Click to add title” section, key in “Outlook for the Future”
In the “Click to add text” section key in the following:
Legal Issues and Uncertainties
Security
Rapid Technological Change
Uncertain Market Conditions
Customer Acceptance
Market Saturation
Research and Development
Modifying Background and Transition
Click “Slide Sorter View” Button at bottom right of your screen and select all slides.
From Design Tab, select any theme as your background and apply it to all slides.
From Transition Tab, select “Cover” as your transition and apply it to all slides.
From the Ribbon inside Transition tab, click “On Mouse Click” under the command of Advance Slide.
Upload your outputs to Google Classroom using “Midterm Hands-On Examination_Last name, First
name_Section_MS PPT” as file name.
END OF HANDS-ON EXAM
Prepared by:
LESLIE T. CALCETAS
IDA KRISTINA D. RAMOS

Instructors
Date Signed: October 13, 2020
Reviewed by:
DR. JENNIFER M. PEREZ, CPA

Department Chair- Accountancy and Management Accounting
Date Signed:
Approved by:
DR. IRENE H. MARALIT

Associate Dean, CABEIHM
Date Signed:

IT 101 Midterm Exam Part 2 Hands On

Uploaded by

Copyright:

Available Formats

IT 101 Midterm Exam Part 2 Hands On

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

IT 101 Midterm Exam Part 2 Hands On

Uploaded by

Copyright:

Available Formats

Republic of the Philippines

BATANGAS STATE UNIVERSITY

Name: __ Score:

PART II: HANDS-ON EXAMINATION FOR LABORATORY PART (90 points)

I. MICROSOFT WORD (30 points)

(iii). Use the official logo of BatStateU for company logo

(iv). Format the business letter as follows:

II. MICROSOFT EXCEL (30 points)

III. MICROSOFT POWERPOINT (30 points)

2016 2017 2018

Total Revenue $28,365

Assets = Liabilities + Stockholders’ Equity

END OF HANDS-ON EXAM

IDA KRISTINA D. RAMOS

DR. JENNIFER M. PEREZ, CPA

DR. IRENE H. MARALIT

You might also like