Reviewer Flashcards
1
Q
Offline software used to create, edit, and manage documents.
A
Word Processing Software
2
Q
Who developed Microsoft Word?
When?
A
Charles Simonyi & Richard Brodie in 1983.
3
Q
What was the first name given to Microsoft Word?
A
Multi-tool
4
Q
What are the main parts of MS Word?
Seven Main Parts of MS Words
A
- Title Bar
- Menu Bar
- Standard Toolbar
- Ruler
- Scroll Bar
- Status Bar
- View Buttons
5
Q
display the name of the Document
Seven Main Parts of MS Words
A
Title Bar
6
Q
used to manage the document
Seven Main Parts of MS Words
A
Menu bar
7
Q
contains the shortcut buttons
Seven Main Parts of MS Words
A
Standard Toolbar
8
Q
set margins, indents and tabs
What are the main parts of MS Word?
A
Ruler
9
Q
used to view the entire parts of the documents
Seven Main Parts of MS Words
A
Scroll Bar
10
Q
display the working mode buttons
Seven Main Parts of MS Words
A
Status Bar
11
Q
used to change the layout view of the documents
Seven Main Parts of MS Words
A
View Buttons
12
Q
Automatic addition of names and address information from a database, mainly for advertising.
A
Mail Merge
13
Q
What are the uses of Mail Merge?
A
- Enable bulk messages
- Sending messages to multiple recipients
- Create multiple documents at once
- Easy dissemination of information
- Efficiently send advertising materials.
14
Q
What are the components of Mail Merge?
A
- Form Document
- List or Data File
15
Q
Main body of the
message
Two Components of Mail Merge
A
Form Document
16
Q
contains the information of each clients
Two Components of Mail Merge
A
List or Data File
17
Q
What are external materials in MS Word?
6 External Materials in MS Word
A
- Pictures
- Clip Art
- Shapes
- Smart Art
- Charts and Graphs
- Screenshot
18
Q
digital materials for additional visuals
6 External Materials in MS Word
A
Pictures
19
Q
icons and other elements
6 External Materials in MS Word
A
Clip Art
20
Q
different shapes
6 External Materials in MS Word
A
Shapes
21
Q
to creates flow chart and other processes
6 External Materials in MS Word
A
Smart Art
22
Q
data, characteristics and trends as well as statistics
6 External Materials in MS Word
A
Charts and Graphs
23
Q
taking images on screen
6 External Materials in MS Word
A
Screenshot
24
Q
What are the types of image placement in MS Word?
7 Types of Image Placement in MS Word
A
- In-line with text
- Square
- Tight
- Through
- Top & Bottom
- Behind Text
- In Front of the text
25
follow the direction of the text
| 7 Types of Image Placement in MS Word
In-line with text
26
create a square pattern on the text
| 7 Types of Image Placement in MS Word
Square
27
default image placement
| 7 Types of Image Placement in MS Word
Tight
28
image will not affect the text
| 7 Types of Image Placement in MS Word
Through
29
text will be shown on top and bottom
| 7 Types of Image Placement in MS Word
Top & Bottom
30
you can arrange images anywhere on the text without distortion
| 7 Types of Image Placement in MS Word
Behind Text
31
images will be
seen in front of the texts
| 7 Types of Image Placement in MS Word
In Front of the Text
32
A productivity application used for calculation and organizing data using tables and functions.
Spreadsheet Software (Microsoft Excel)
33
Who started Microsoft Excel, when?and what is its first software name?
**Dan Bricklin in 1978** with the first software named **VISICALC**.
34
kumain ka na ba?
1 - Hindi
5 - Oo
35
Inom ka muna water
💧 - 5
36
Developed by **Mitch Kapor** and added **5 Columns** and **20 rows**
Lotus 123
37
Adopted by Microsoft Corporation and released their own version of VISICALC and Lotus 123
Multi-Plan
38
What are the main parts of Excel?
| 8 Parts of Excel
- Cell
- Range
- Column Heading
- Row Numbers
- Formula Bar
- Name Box
- Sheet Tab
- Vertical and Horizontal Scroll Bar
39
Single box on the worksheet
| 8 Parts of Excel
Cell
40
Contains 2 or more cells
| 8 Parts of Excel
Range
41
the vertical area of the worksheet that contains letters
| 8 Parts of Excel
Column Heading
42
these are the horizontal grid of the worksheet started from no. 1 onwards.
| 8 Parts of Excel
Row Numbers
43
This shows the inputted formula
on the cell
| 8 Parts of Excel
Formula Bar
44
displays the name of the cell
| 8 Parts of Excel
Name Box
45
individual sheets of the worksheet
| 8 Parts of Excel
Sheet Tab
46
display the entire worksheet
| 8 Parts of Excel
Vertical and Horizontal Scroll Bar
47
What are some Excel functions?
| 10 Excel Functions
1. Math Operations
2. Sum
3. Average
4. Countif
5. Sumif
6. Averageif
7. If function
8. Conditional Formatting
9. Data Validation
10. Vlook-up.
48
(Addition, subtraction, multiplication, & division)
| 10 Excel Functions
Math Operations
49
compute for the total values of a
range
| 10 Excel Functions
Sum
50
give the average of a range
| 10 Excel Functions
Average
51
function that is used to count values of a range with criteria and condition
| 10 Excel Functions
Countif
52
used to get the overall total from a range using a condition
| 10 Excel Functions
Sumif
53
getting the average of a values from a range using certain condition or criteria
| 10 Excel Functions
Averageif
54
a logical test that display certain condition or criteria
| 10 Excel Functions
If function
55
used to put color markings on the cell or range
using rules and conditions
| 10 Excel Functions
Conditional Formatting
56
function that is used to create dropdown
| 10 Excel Functions
Data Validation
57
used to retrieve a value from a column number
| 10 Excel Functions
V-lookup
58
Software used to facilitate visual demonstration with slides containing text, images, audio, and video.
Presentation Software (Microsoft Powerpoint)
59
Who developed PRESENTER? When?
**Dennis Austin** and **Robert Gaskins** in **1987**.
60
PRESENTER was adopted by Microsoft (calling it PowerPoint 3.0) and released their version in the year ____?
1992
61
What are techniques for creating effective presentations?
| 8 Techniques for Effective Presenations
1. Minimize
2. Clarity
3. Simplicity
4. Follow 6x7 Rules
5. Visuals
6. Consistency
7. Contrast
8. Audience.
62
avoid too much words on the presentation and it needs to be summarized and used only keywords
| 8 Techniques for Effective Presenations
Minimize
63
provide simple words that is easy to understood and make sure that the font size is readable
| 8 Techniques for Effective Presenations
Clarity
64
used simple font style and designs to highlight its contents rather than the elements
| 8 Techniques for Effective Presenations
Simplicity
65
each slide should contain 6 lines, and each line should have at most 7 words
| 8 Techniques for Effective Presenations
Follow 6x7 Rules
66
graphics should be appropriate to the audience and use only simple visuals
| 8 Techniques for Effective Presenations
Visuals
67
design, font style, and other elements should be consistent to all slides.
| 8 Techniques for Effective Presenations
Consistency
68
observe light text to dark
background and vice versa
| 8 Techniques for Effective Presenations
Contrast
69
we need to consider the audience in creating the presentation always
| 8 Techniques for Effective Presenations
Audience
70
A link from a hypertext file to another location or file, activated by clicking on a highlighted word or image.
Hyperlink
71
What are the types of hyperlinks?
| 2 Types of Hyperlinks
1. Anchor Link
2. In-line link.
72
link to the same document
| 2 Types of Hyperlinks
Anchor Link
73
link to a remote file, or
other documents and websites.
| 2 Types of Hyperlinks
In-line link
74
Communication that uses graphics and visual elements to provide information.
Visual Communication
75
a digital space that users and netizens exchange information through the use of various online platforms.
Online Environment
76
a graphical representation of ideas, context and information using visuals, icons, text & other elements
Infographics
77
What are the elements of infographics?
| 3 Elements of Infographics
1. Visual Elements
2. Content Elements
3. Knowledge Elements.
78
contains graphics, icons, and other graphical references
| 3 Elements of Infographics
Visual Elements
79
time frames, data, statistics, and sources
| 3 Elements of Infographics
Content Elements
80
consists of facts and objectives of the context
| 3 Elements of Infographics
Knowledge Elements
81
What are the types of infographics?
| 4 Types of Infographics
1. Cause and Effect
2. Chronological/Directional
3. Quantitative
4. Product.
82
promotes products and services
| 4 Types of Infographics
Product
83
84
involves statistics, quantity, trends and percentage
| 4 Types of Infographics
Quantitative
85
shows causes and effects of a certain topic
| 4 Types of Infographics
Cause and Effect
86
steps, process and procedures
| 4 Types of Infographics
Chronological/Directional
87
What are online image formats?
| 3 online image formats
1. JPEG/JPG
2. GIF
3. PNG.
88
JPEG -
| 3 online image formats
Joint Photographic Expert Group
89
GIF -
| 3 online image formats
Graphics Interchange Format
90
PNG -
| 3 online image formats
Portable Network Graphics
91
What are the basic principles of graphics and layout?
1. Balance 2. Emphasis 3. Movement 4. Pattern, repetition, and rhythm 5. Proportion 6. Variety 7. Contrast.
92
What should a formula in Excel start with?
An equal sign (=).
93
What was the first operating system that used Microsoft Word?
The UNIX Operating System.
94
What special functions in Excel identify even and odd numbers?
ISEVEN & ISODD.
