THE PUNJAB ACADEMY Total Marks: 100
Final Examination Test of OFFICE AUTOMATION-2023 Passing Marks: 60
Teacher Name: Sir Saud Ahmed
Section-A (Question/Answers) 20 Marks
Q1: What is Microsoft Office? Enlist any 5 of its products.
Q2: In which areas MS office can be used for? Elaborate in your own words.
Q3: Explain MS Excel in your own words?
Section-B (FILL IN THE BLANKS) 10 Marks
1. MS Word is also known as_____________software.
2. We can create slides in MS_____________.
3. Combination of Rows and Columns are used MS _____________.
4. Formulas are specially used in MS _____________.
5. We can create documents like letters and applications easily in _____________.
Section-C (CHOOSE THE CORRECT ANSWER) 20 Marks
1. MS Excel is also known as_____________.
a. Spreadsheet software b. Word Processing software c. Presentation software
2. MS PowerPoint is also known as_____________.
a. Spreadsheet software b. Database software c. Presentation software
3. _____________ TAB is used for sending data from one computer to another online.
a. Mailings b. Page Layout c. Review
4. MS Powerpoint is also known as_____________.
a. Spreadsheet software b. Database software c. Presentation software
5. Shortcut Key to Format painter is_____________.
a. CTRL+C b. CTRL+SHIFT+C c. CTRL+ALT+C
6. In Page Layout TABwe can work on _____________.
a. Mailing b. Page Orientation c. Review
7. We can add images from _____________ Tab.
a. Home b. Insert c. References
8. Home Tab in MS Word is used for editing _____________.
a. Cells b. Slides c. Text
9. Indent can be used with help of _____________ button.
a. Tab b. Enter c. CTRL
10. SUM formula is used to_____________.
a. Add two cells b. Divide two cells c. Multiply two cells
Section-D (TRUE/FALSE) 20 Marks
1. Formulas are used in MS Word. (T/F)
2. We can add music and videos in MS PowerPoint.
3. Row formula is used to return the value of reference of the row.
4. Count formula is used to count the text in the selected array.
5. Ribbons are the options of Tabs.
6. We cannot add images in MS Word.
7. MS Access is a Database software.
8. we can protect our document through password encryption
9. CTRL+B is used to Italicize the text.
10. CTRL+U is used to underline the selected text.