Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Office Semester Review

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

A students wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select the Sparkline type of choice from the Sparklines group and then select OK.

a)

true

b)

false

2.

What should you add to describe the data in a chart?

a)

A legend

b)

A title

c)

A chart style

d)

An animation

3.

To quickly change the shading, borders, and font colors of a table, which of the following should be done?

a)

Apply a Table Style.

b)

Apply Theme Effects.

c)

Apply Text Effects.

d)

Insert a Watermark.

4.

Kyle needs the same text to appear at the top of each page in a document. Which of the following is the best method to achieve this?

a)

Edit the document header.

b)

Manually enter the desired text at the top of each page.

c)

Modify the Document Properties.

d)

Add a comment at the top of each page.

5.

If you want to change the color of the border around a shape, which of the following do you change?

a)

Outline

b)

Fill

c)

Texture

d)

Color

6.

To start entering text on a new page, do which of the following?

a)

Insert a page break.

b)

Insert a line break.

c)

Insert a continuous section break.

d)

Insert a column break.

7.

Which of the following Print settings prints each slide at the top of the paper with blank lines below the slide?

a)

Full Page Slides

b)

Notes Pages

c)

Outline

d)

Handouts

8.

Which of the following functions would you use to calculate the arithmetic mean of a price list?

a)

MAX

b)

COUNT

c)

SUM

d)

AVERAGE

9.

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

a)

Change All

b)

Change

c)

Ignore Once

d)

Ignore All

10.

Which preset text effect do you apply when you want the text to have a border color?

a)

Outline

b)

Shadow

c)

Reflection

d)

Glow

11.

Where can you see a preview of how your worksheet will look when printed, including headers?

a)

Print tab in Backstage view

b)

Page Break preview

c)

Normal view

d)

File preview

12.

Imani needs to duplicate a picture in her document. She should do which of the following?

a)

Copy and paste the picture.

b)

Rotate the picture.

c)

Change the picture.

d)

Reset the picture.

13.

Jeremiah has inserted a table and needs to fill it with data. After entering a value, he should do which of the following to advance the curser to the next cell in the table?

a)

Press TAB.

b)

Press ENTER.

c)

Press ESC.

d)

Press INSERT.

14.

Joanne needs each page in her document to be numbered. She should do which of the following?

a)

Manually enter the page number at the bottom of each page.

b)

Use the Insert Footnote button.

c)

Use the Cross-reference button.

d)

Use the Page Number button.

15.

Which of the following layouts is best for the slide that contains the title of the presentation?

a)

Title and Content

b)

Title Slide

c)

Text and Content

d)

Blank

16.

To calculate the number of words in a document, do which of the following?

a)

Click the Word Count button.

b)

Click the Thesaurus button.

c)

Click the Translate button.

d)

Click the Check Accessibility button.

17.

To copy a cell's formatting to another cell, which of the following can you use?

a)

Format Cells dialog box

b)

Format Painter

c)

Quick Analysis Tool

d)

Format as Table

18.

Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?

a)

Pie

b)

Bar

c)

Line

d)

Column

19.

Alyssa needs a paragraph to have a dotted border. She should do which of the following?

a)

Insert appropriate SmartArt.

b)

Insert a table.

c)

Apply a paragraph border and change the line style of the border.

d)

Insert appropriate WordArt.

20.

To change the shading of a cell in a table, which of the following should be done first?

a)

Select the table.

b)

Select the desired column.

c)

Select the desired row.

d)

Select the desired cell.

21.

When you drag a photo on a slide, what appears to help you position it?

a)

Gridlines

b)

Smart Guides

c)

Arrows

d)

Rulers

22.

Which of the following commands found on the Align menu evenly space objects horizontally or vertically relative to each other or the slide?

a)

Distribute

b)

Arrange

c)

Space

d)

Align

23.

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

a)

Currency

b)

Accounting

c)

Percentage

d)

General

24.

To correct an error in a comment, do which of the following?

a)

Resolve the comment.

b)

Delete the comment.

c)

Reply to the comment.

d)

Edit the comment.

25.

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

a)

CTRL

b)

ALT

c)

SHIFT

d)

ESC

26.

To indent the first line of every paragraph in a document, do which of the following?

a)

Create a right tab stop.

b)

Create a left tab stop.

c)

Create a hanging indent.

d)

Create a first line indent.

27.

If you want to show data organized into rows and columns, which of the following objects is a good choice?

a)

Table

b)

SmartArt

c)

Chart

d)

Grid

28.

Aamir is preparing a research paper. He needs to insert a parenthetical reference that gives credit to the source

of a quotation. What is the best way for him to achieve this?

a)

Enter the parenthetical reference manually.

b)

Insert a footnote with the source information.

c)

Insert an endnote with the source information.

d)

Insert a citation.

29.

If you want to add a note to a slide to remind you to mention a fact that is related to the slide, where do you place the note?

a)

Reading pane

b)

Normal pane

c)

Notes pane

d)

Thumbnails pane

30.

What feature inserts a function that totals the cells above or to the left of the selected cell?

a)

AutoSum button

b)

absolute reference

c)

reference operator

d)

mode indicator

31.

Which of the following views does not let you change the order of slides in a presentation?

a)

Normal

b)

Outline

c)

Slide Show

d)

Slide Sorter

32.

To see a thumbnail list of pages in a document, do which of the following?

a)

Click the Arrange All button.

b)

Click the Side to Side button.

c)

Open the Navigation pane and select Headings.

d)

Open the Navigation pane and select Pages.

33.

When you select a cell range, the cells must be adjacent to each other.

a)

true

b)

false

34.

If you don't like the speed of a transition that you applied, you cannot change it.

a)

true

b)

false

35.

When you recolor a picture, you use the Paintbrush tool to add color to parts of the picture.

a)

true

b)

false

36.

To quickly change the colors, fonts, and effects in a document, change the document style.

a)

true

b)

false

37.

You cannot change a shape to a different shape.

a)

true

b)

false

38.

Press ALT+P to print a document.

a)

true

b)

false

39.

A citation is a parenthetical reference in the document text that gives credit to the source for a quotation or other information used in a document.

a)

true

b)

false

40.

If you want to move a sentence from one paragraph to another paragraph, you can use the Copy and Paste commands.

a)

true

b)

false

41.

To provide emphasis to text, you can apply bold.

a)

true

b)

false

42.

To add a shadow to a shape, apply a shape outline.

a)

true

b)

false

43.

When you enter a value in a worksheet cell, it is automatically left-aligned.

a)

true

b)

false

44.

Alan is working on a draft document. He wants the document to have more white space. He can do this by changing the line spacing.

a)

true

b)

false

45.

To change the color of a shape, you change the shape fill.

a)

true

b)

false

46.

Decreasing a cell's indent moves its contents to the right one space.

a)

true

b)

false

47.

Raj needs to rearrange the slides in his presentation. Which of the following views would be the best one to use?

a)

Reading

b)

Notes Page

c)

Slide Show

d)

Slide Sorter

48.

Laila needs to change the formatting of a table. To do so, which of the following does she need to do first?

a)

Select a row in the table.

b)

Select the table.

c)

Select a column in the table.

49.

Where can you see a brief description of a selected function?

a)

Formula bar

b)

Insert Function dialog box

c)

Insert dialog box

d)

Insert tab

50.

If you need to present numerical data on a slide, which of the following can you insert to show the data as a graphic?

a)

Table

b)

SmartArt

c)

Chart

d)

Grid