Scribd
Upload
20 views5 pages

Microsoft Office Specialist Exam Guide

This document provides 30 tasks to practice various Microsoft Excel functions and formatting options using data about Olympic 100 meter gold medalists: 1) Insert a column and add headers labeling the years and countries of medalists. 2) Apply styles, formats, and conditional formatting to present the data clearly. 3) Create tables, charts, and formulas to calculate statistics like average times and counts of medals by country. 4) Add worksheets, link data, and modify properties to organize the Olympic data across multiple sheets.

Uploaded by

rohitboy123
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
20 views5 pages

Microsoft Office Specialist Exam Guide

This document provides 30 tasks to practice various Microsoft Excel functions and formatting options using data about Olympic 100 meter gold medalists: 1) Insert a column and add headers labeling the years and countries of medalists. 2) Apply styles, formats, and conditional formatting to present the data clearly. 3) Create tables, charts, and formulas to calculate statistics like average times and counts of medals by country. 4) Add worksheets, link data, and modify properties to organize the Olympic data across multiple sheets.

Uploaded by

rohitboy123
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

896Questions for the Microsoft Office Specialist

Examination
The First Sheet:
1)Insert a Column:Directly to the left of the column B.
2)Add the header and the year of the Olympic games
Cell B2 .Text"Year"

Cell Range B3:B34

.Text

"1896 1900.2020"
3)Modify Text. Cell A1 .Text "Olympic 100 Meters Gold
Medalists"
4)Apply a cell style

Cell range A2:F2

.Style 40%-

Accent5
5)Modify the number format to display two digits
following

the

decimal.

Cell

Range

F3:F34

Decimal Places:2
6)modify the cell alignment settings. Cell Range
A3:A34 .Horizontal:Right(Indent) Indent:1
7)Create a new named Range Cell Range E3:E34,
Name:"Code"
8)Add conditional formatting Cell Range F3:F34
Format Style:Icon Sets
Red Flag

Icon Style:3 Flags

.Value>=11 Type:Number

Flag: Value>=10 Type:Number


.Value<10 Type:Number
9)Configure page layout options.
A2:C34

Yellow

Green Flag
Cell

Range

Set Print Area. Enable the Gridlines

Print Option
10)
Hide Rows : Rows 8,14,15,33 and 34

11)

Insert a Picture:To the right of the data

.File

Source [Link](Insert your own image, as


the starter image is available only during
exams)
12)
Crop the Picture:[Link] .Crop to shape
Snip Diagonal Corner Rectangle

The Second Sheet:


13)

Calculate the number of gold medals for each

country

Cell Range C2:C19

COUNTIF

.Range:Code

.Use Function

Criteria:

Column

Values
14)
Create and rename a table. Cell Range
A1:C19 .Table Name : "CountryMedals"
15)
Modify the table style: Cell Range A1:C19
.Table Style Medium 9 .Enable the First
Column Style
16)
Apply a sort and a filter to the table

.Cell

Range A1:C19. Sort: Column # Gold Medals


Order Largest to Smallest. Column Country
Order A to Z. Filter: Hide countries with no
gold medals
17)
Create the Chart to the right of the data.
(Chart

3-D

Pie).

Exclude

all

filtered

Rows.

Horizontal Axis Labels "Country" column in the

table. Series 1: "# Gold Medals" Column in the


table.
18)
Apply a style to the chart. Chart: Style 7
19)
Rename the title of the chart. Chart Text"100
Metres Gold Medals".
20)
Find the average value of all Olympic gold
medal times. Use Function AVERAGE .Number
1:times of all medal winners on "Olympic 100
Metres" worksheet. Use absolute reference
21)
Find the fastest Olympic gold medal time. Cell
F3. Use Function MIN. Number 1:times of all gold
medal

winners

on

"Olympic

100

Metres"

worksheet.
22)
Find the slowest Olympic gold medal time. Cell
F4. Use Function MAX. Number 1:times of all gold
medal

winners

on

"Olympic

100

Metres"

worksheet.
23)
Find the average of all Olympic gold medal
times by USA runners. Cell F5. Use Function
AVERAGEIF

.Range:Code

Criteria:"USA"

Average_range : times of all gold medal winners on


"Olympic 100 Metres".
24)
Insert the name and country of the runner with
the

fastest

time.

Cell

G3

Use

Function

CONCATENATE. Text1: Name of gold medalist in


2012 London Olympics. Text2:"=". Text3: Country
code of gold medalist in 2012 London.

25)

Insert family name of runner with slowest

time. Cell G4. Use function RIGHT. Text: family


name

of

runner

with

slowest

Olympic

time.

After

other

Num_chars: 5

Third Sheet:
26)

Add

Worksheet.

[Link] "Top 25 100 Metres".


27)
Insert data from a text file. Cell A1. File Source:
Top [Link]. Tab-delimited
28)
Create a hyperlink to another worksheet in Cell
D11..

Cell

Reference:

Olympic 100 Meters


29)
Change the color

A3

Sheet

theme

reference:

of

Olympic

[Link] to Slipstream
30)
Modify the document properties of Olympic
[Link] Subject = "100 Metres"

You might also like