wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Office 2019 Midterm Review

Total questions: 61

Worksheet time: 32mins

Name
Class
Date
1.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
2.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
3.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
4.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
5.
For which of the following tasks would you use the fill handle?
a)
to apply shading 
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
6.
Rows are which of the following:
a)
vertical
b)
horizontal
7.
Columns are vertical.
a)
True
b)
False
8.
What does every formula or function start with?
a)
!
b)
@
c)
#
d)
=
9.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
10.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
11.
What is the Order of Operations?
a)
PEDMAS
b)
PSMADE
c)
PMSADE
d)
PEMDAS
12.
What does this symbol do:
/
a)
Multiply
b)
Add
c)
Divide
d)
Minus
13.
What does this symbol do:
*
a)
Multiply
b)
Add
c)
Divide
d)
Minus
14.
The quickest way to find a total in Excel is by using __________.
a)
AutoTotal
b)
AutoSum
c)
AutoAdd
d)
AutoPlus
15.
Which feature would allow you to change the formatting of any cells that are less than $100.00?
a)
Cell Formatting
b)
Easy Formatting
c)
Auto Formatting
d)
Conditional Formatting
16.
Which option shows the fill handle?
a)
A
b)
B
c)
C
d)
D
17.
_________ allows you to perform calculations on data entered into a spreadsheet?
a)
Formulas
b)
Data
c)
Cell
d)
Cell reference
18.

Which location on the Ribbon contains the commands for adding a table to a presentation?

a)

file

b)

insert

c)

home

d)

design

19.

Which tab on the Ribbon contains the themes gallery?

a)

design

b)

layout

c)

transitions

d)

view

20.

Which of the following contain formatting, positioning & placeholders for all of the content on a slide?

a)

themes

b)

slide layouts

c)

placeholder layouts

d)

content designs

21.

Which of the following views must you be in to insert a placeholder?

a)

normal

b)

slide show

c)

slide master

d)

slide sorter

22.

Which of the following groups on the Home tab contains the commands to change the format of a list from bulleted to numbered?

a)

slides

b)

font

c)

paragraph

d)

editing

23.

Which of the following are effects which occur in a presentation when moving form one slide to another?

a)

animations

b)

slide transitions

c)

exit effect

d)

entrance effect

24.

Which of the following are movements which can be applied to objects in a presentation?

a)

animations

b)

slide transitions

c)

sound

d)

media controls

25.
Which software program is used to create a collection of slides that may contain text, charts, pictures, sound, movies, or multimedia, and is often called a presentation graphics program?
a)
Office
b)
PowerPoint
c)
Word
d)
WordPad
26.

What does the icon from the Insert Ribbon represent?

a)

video

b)

audio

c)

hyperlink

d)

screenshot

27.

What does the icon from the Insert Ribbon represent?

a)

new slide

b)

comment

c)

slide number

d)

smartart

28.

What does the icon from the Insert Ribbon represent?

a)

smartart

b)

object

c)

equation

d)

symbol

29.

Which location on the Ribbon contains the commands for adding a table to a presentation?

a)

file

b)

insert

c)

home

d)

design

30.

Which tab on the Ribbon contains the themes gallery?

a)

design

b)

layout

c)

transitions

d)

view

31.

Which tab on the Ribbon contains the themes gallery?

a)

design

b)

layout

c)

transitions

d)

view

32.
The small diagonal arrow in some command groups’ lower-right corner is a __________. 
a)
drop-down arrow
b)
dialog box launcher
c)
navigation control 
d)
gallery launcher
33.

Which of one is the Microsoft PowerPoint Icon?

a)
b)
c)
d)
34.

It is a Tab in a Ribbon where you can Create a new file, Save a file and Rename a file?

a)

Insert Tab

b)

Home Tab

c)

File Tab

d)

Design Tab

35.

Is located at the top in the center of the PowerPoint window. It also displays the name of the presentation on which you are currently working.

a)

Name Bar

b)

Title Bar

c)

Status Bar

d)

Top Bar

36.

Is the thin strip on the left side of the PowerPoint for Windows interface?

a)

Slide Pane

b)

Slide View

c)

Slide Area

d)

Slide Sorter View

37.

In the Insert Tab you can? (Tick everything that you think you can do)

a)

Add images to your presentation

b)

Insert sound to your presentation

c)

Copy your presentation

d)

Animate your presentation

38.

The window that first opens in PowerPoint has a big working space in the middle, with smaller areas around it is called _______________.

a)

Sorter View

b)

Slide Area

c)

Title Bar

d)

Ribbon

39.

Copy, Cut, & Paste are located on the ___________ Tab

a)

File Tab

b)

Home Tab

c)

View Tab

d)

Insert Tab

40.

Which tab on the Ribbon contains the themes gallery?

a)

Design Tab

b)

Layout Tab

c)

Transition Tab

d)

View Tab

41.
What symbol is used to designate an absolute cell reference?
a)
@
b)
!
c)
#
d)
$
42.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
43.
You want to enter a series of dates down a column. What would be the best tool for the job?
a)
Find and Replace
b)
AutoFill
c)
Spelling Checker
d)
Cut and Paste
44.
What function can be used to find the largest number in a range of numbers?
a)
=AVERAGE
b)
=MIN
c)
=MAX
d)
=SUM
45.
Which of these number formats would you want to apply to a cell showing the total sales for the month?
a)
Currency
b)
Percentage
c)
Date
d)
None of the others
46.
You have decided to center the text within a cell. What have you done?
a)
Merged Cells
b)
Wrapped Text
c)
Changed Alignment
d)
Autofit Content
47.
Which of these statements are true?
a)
You can use borders to create a group of cells or make specific cells stand out.
b)
For cells that contain text, it is better to use a pattern rather than a shade.
c)
The more shades you use on a worksheet, the more attractive it will be.
d)
All of the others.
48.
You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.
a)
True
b)
False
49.
What does it mean to merge cells?
a)
Combine 2 or more cells into a single cell.
b)
Apply a border around a set of cells.
c)
Split a single cell into 2 or more cells.
d)
Center the contents of the cells.
50.
What happens when you hide a column in Microsoft Excel?
a)
The data in the column is deleted.
b)
The column doesn't appear, but the data is still there.
c)
Formulas referencing cells in the column stop working.
d)
None of the others.
51.
Why would you want to change the column width?
a)
To draw attention to the data in those cells.
b)
To make sure the column headings are always visible when scrolling.
c)
To make sure all of the information in the column is visible.
52.
Microsoft Excel can use Headers & Footers, just like Microsoft Word.
a)
True
b)
False
53.

Which of these icons will increase decimal places?

a)

A

b)

B

c)

C

d)

D

54.

What is the function of the mouse pointer in the image?

a)

It allows you to move the contents of the cell

b)

It allows you to select more than one cell

c)

It copies what is in the cell

d)

It allows you to widen the column

55.

What is the function of the mouse pointer in the image?

a)

It allows you to move the contents of the cell

b)

It copies what is in the cell

c)

It allows you to select more than one cell

d)

It allows you to widen the column

56.

What is the function of the mouse pointer in the image?

a)

It allows you to select more than one cell

b)

It copies what is in the cell

c)

It allows you to widen the column

d)

It allows you to move the contents of a cell

57.

What is the function of the mouse pointer in the image?

a)

It allows you to select more than one cell

b)

It copies what is in the cell

c)

It allows you to widen columns

d)

It allows you to move the contents of a cell

58.

On which tab would you find margins and page orientation?

a)

Home

b)

Insert

c)

Page Layout

d)

Data

59.

There is no way to check spelling and grammar in Excel.

a)

True

b)

False

60.

What is the function of the mouse pointer in the image?

a)

It selects the entire column

b)

It selects the entire row

c)

It moves the entire column

d)

it moves the entire row

61.

It is impossible to add borders in Excel.

a)

True

b)

False

Similar Resources on Wayground

HTML Assessment

60 questions

HTML Assessment

quiz

Worksheet

•

9th Grade

CIS Microsoft Excel (Review)

62 questions

CIS Microsoft Excel (Review)

quiz

Worksheet

•

9th Grade - Professio...

Safety and Security - Easy

57 questions

Safety and Security - Easy

quiz

Worksheet

•

7th Grade - University

YR 9 Cultural, Ethical & legal issues in ICT

58 questions

YR 9 Cultural, Ethical & legal issues in ICT

quiz

Worksheet

•

9th Grade

Information Technology - CBSE Subject Code 402

59 questions

Information Technology - CBSE Subject Code 402

quiz

Worksheet

•

9th Grade

Working with Files

59 questions

Working with Files

quiz

Worksheet

•

8th - 12th Grade

E-BOOK

60 questions

E-BOOK

quiz

Worksheet

•

KG - University

Unit 2 Test Review - The Internet

61 questions

Unit 2 Test Review - The Internet

quiz

Worksheet

•

9th - 12th Grade