ADRE 2.
0 MOCK SKILL TEST
Full Marks: 25
Time: 45 minutes
• HS LEVEL
• DEGREE WITH COMPUTER
• DEGREE WITHOUT COMPUTER
MOCK 2
Instructions:
1. Set a timer for 45 minutes
2. Use an extra keyboard and mouse during the test
3. Keep mobile aside for the whole duration of the test
4. Save the files in a separate folder on Desktop and “mock
print” the documents.
P.T.O
MOCK 2
(MS Word: 10 marks, MS Excel: 7 marks, MS PowerPoint: 8 marks)
1. Create a document with the name “ADRE SKILL TEST 2” and
write the text in it and perform the following tasks:
MS WORD: A MODERN DAY BOON
Microsoft word is a widely used word processing software developed
by Microsoft. It allows users to create, edit, format, print documents
for various purposes, such as school assignments, business reports,
and professional letters. One of its key features is its ability to change
font styles, sizes and colours making documents visually more
appealing. Users can also align texts to the left, right, centre
or make them bold, italics or underlined formatting to
highlight important content. Additionally, word provides tools for
checking spelling and grammar, which helps users create error-free
documents. Another useful feature is to use tables, charts, symbols
and hyperlinks to make documents more interactive, users can also
apply bullet points and numbered lists to organize information
effectively. Microsoft word supports different file formats, including
.docx and pdf, allowing users to share their work easily. The
software also includes a print preview option to check the document
layout before printing.
I. Reproduce the whole document in “Times New
Roman” font.
II. The heading should be as-it-is (same) as shown in
the question with font size 14 point.
III. Underline the first 3 lines and change the font colour
to “yellow’.
IV. The margin in page layout should be “narrow”.
V. Highlight the last two lines in “green”.
VI. Text alignment should be in “Justify”.
P.T.O
2. The given worksheet contains the month-wise sales report for
shoe a company. Reproduce the document in MS EXCEL and
perform the following tasks:
MONTH SALES (Shoe SALES (Shoe Total Sales in
A) in Rs. B) in Rs. Rs.
5,000 3,000 ?
January
6,200 4,100 ?
February
4,500 5,200 ?
March
7,300 5,100 ?
April
6,400 5,900 ?
May
I. Use formula in Total Sales column to Calculate the total
sales for each month.
II. Apply formatting: BOLD, ARIAL BLACK as font.
III. Insert a column chart to visually represent the sales of
Shoe A and Shoe B for all the months.
IV. Print the entire worksheet and set the option to “fit to
scale” the entire sheet in scaling option.
P.T.O
3. Prepare a presentation in MS POWERPOINT as directed below:
Prepare 4 slides in total. The first slide should be “Title Only”
slide with the heading “TYPES OF MODERN-DAY
COMPUTERS” and the font style should be “Tahoma” with
font size 50 point.
In the second slide set the slide layout to “Title and Content”.
In the title write “Types of computers on the basis of size”;
bold & underlined. In the content section use numbering and
write “LAPTOP”, “DESKTOP”, “PALMTOP”, “MAINFRAME” all
the font being in “TIMES NEW ROMAN” with font size 44 pt
for Title and 28 pt for content. Use font colour “RED” in this
slide.
In the third slide, a blank slide is desired and add a
“TRIANGLE SHAPE” and shape fill with YELLOW COLOUR.
Inside the shape write “ABACUS”
In the fourth slide set the slide layout to “TITLE ONLY” and
write “THANK YOU” with font size 54 pt and font colour BLUE
50% ACCENT.
