WorksheetsMS OFFICE COMMON TOOLS
Total questions: 30
Worksheet time: 15mins
. True or False: Within Microsoft Word 2013, it is possible to create bar graphs, pie charts, and line graphs.
TRUE
FALSE
True or False: The Mail Merge feature can be used to address the same letter to several different people.
True
False
A feature in MS Word that allows you to create a document and merge them with another document or data file.
Thesaurus
Mail merge
Format
insert
Word processor developed by Microsoft. It was first released on ________________. It is also known as MS Word.
October 25, 1985
October 23, 1985
October 25, 1983
October 23,1983
A default feature of MS Word that provides synonyms for a word in a document.
Dictionary
WEBSTER
wiki
THESAURUS
If I want to add clipart and smartart in my word document, what tab on the Ribbon would I select?
Review
Insert
References
Page layout
A shortcut key to Save a document.
Ctrl+S
Ctrl+C
Ctrl+V
Ctrl+E
What part of ms word is highlighted
Document information
Quick Access toolbar
Title Bar
Ribbon tabs
As a set of effects which can be applied to text or graphics within a slide.
Design
Transition
Animation
Slide Show
Are motion effects that when in Slide Show view add movement to your slides as you advance from one slide to another.
Transition
Animation
Slide Show
Design
A feature in office tools that uses hypertext transfer protocol and allows you to jump from one location to another.
Hyperlink
Smart Art
Clip Art
Chart
What animation effect was displayed above?
Entrance Effect
Exit Effect
Emphasis Effect
Motion Path
True or False: You can only apply one animation to an object.
True
False
simplified layout of the page so you can quickly key, edit, and format the text.
Slide sorter view
Normal View
The spreadsheet program allows users to organize data in rows and columns and perform calculations on the data.
True
False
The box at the top of each column containing a letter.
Cell
Column headings
Row headings
Working sheet
The selected cell from a worksheet.
Active Sheet
Active Cell
Working Sheet
Working Cell
Horizontal line of entries in a table.
Row
Column
Cell
vertical line of entries in a table
Row
Column
Cell
All formulas in Excel must begin with a/an ________________ sign.
#
>
^
=
What is "P" in PEMDAS as the order of operations in spreadsheet program?
Proxy
Parentheses
Permission
Permanent
What formula is use to get the total amount
=(x*y)
=x*y
=(x+y)
=x+y
What animation effect was displayed above?
Entrance Effect
Emphasis Effect
Exit Effect
Motion Path
What animation effect was displayed above?
Entrance Effect
Emphasis Effect
Exit Effect
Motion Path
What animation effect was displayed above?
Entrance Effect
Emphasis Effect
Exit Effect
Motion Path
If the result of a formula is too large to be displayed in a cell, it may appear as ____________ signs
###########
************
"""""""""""""""
$$$$$$$$$$$$$
Which of these formulas will add three cells and then divide the sum by 4?
=A1+B1+C1/4
=(A1+B1+C1/4)
=(A1+B1+C1)/4
Predefined formulas and are already available in Excel
Functions
Formula Bar
Auto sum
Cell reference
What part of the excel is being highlighted
Quick Access Tool Bar
Formula Bar
Title Bar
Ribbon
Rebecca wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
=Sum(x,y)
=x+y
=(x*y)
=x*y
