Module 2 Productivity Tools Flashcards
What program is used to create spreadsheets which can later be used to analyze statistical tool?
A. MS Excel
B. MS Word
C. MS Publisher
D. MS OneNote
A. MS Excel
What MS Excel function adds a range of cells?
A. ADD
B. PLUS
C. SUM
D. TOTAL
C. SUM
Which of the following is NOT an animation type?
A. Entrance B. Exit C. Emphasis D. Encore
D. Encore
In MS Word, what menu is “Mail Merge” found?
A. Insert B. Format C. Design D. Mailings
D. Mailings
are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more
Productivity Tools
is a word processing feature that allows you to easily create multiple letters, labels, envelopes, nametags, or catalogue documents to group of people as stored in a list in a database or spreadsheet.
Mail Merge
Three Components of the Mail Merge?
- Main document – the letter which contain the email information for each
of the merged document that can be letter, stationary or template. It also
contains the field names which contains the instructions for carrying out
the merge. - Data source – it is also called data file which comprises the information
to be merged into a document such as the list of names and addresses
to be used in a mail merge. This must be connected to the data source
before it can use the information in it. - Merge document – this is also a word processing document that is the
generated output after executing the merge process.
the letter which contain the email information for each of the merged document that can be letter, stationary or template. It also contains the field names which contains the instructions for carrying out the merge.
Main document
– it is also called data file which comprises the information to be merged into a document such as the list of names and addresses to be used in a mail merge. This must be connected to the data source before it can use the information in it.
Data source
this is also a word processing document that is the generated output after executing the merge process.
Merge document
is the process of making the illusion of motion and the illusion of change by means of the rapid succession of sequential images that minimally differ from each other.
Animation
Microsoft PowerPoint provides several animation styles in different categories,
namely?
Entrance, Emphasis, Exit and Motion Paths
which is frequently stated as “links” is a text or image on the screen that you can click on to jump to another file or within the existing file.
hyperlink
When you hover your pointer over a hyperlink, either it is text or an image, the arrow
changes into a small pointing hand, called?
hyperlink cursor
can be used to select cells
Thick cross
can be used to copy and fill other cells
Thin cross
These are cell references that do not change when copied or filled.
Absolute Reference
These are predefined formula that performs calculations using specific values in a particular order.
Functions
What type of Excel function searches for a specific value in your data using the
spreadsheet columns and a unique identifier within those columns?
A. VLOOKUP
B. IF Function
C. COUNTIF
D. Absolute Reference
VLOOKUP
What two Microsoft applications are used to create a mail merge?
A. Word & PowerPoint C. Word & Excel
B. PowerPoint & Excel D. Word & Publisher
C. Word & Excel
What are hyperlinks in PowerPoint?
A. A tool that you use to navigate from one slide to another.
B. A tool that you use to play in PowerPoint.
C. A tool that you use to save a file and slide.
D. A tool that you point to another image in the PowerPoint.
A. A tool that you use to navigate from one slide to another.
What do you call the software that people use to create and produce
professional quality documents, presentations, databases, charts, and graphs?
A. Production Tools
B. Productivity Tools
C. Professional Tools
D. Advanced Application Tools
B. Productivity Tools
