Las 4.1-4.2 Flashcards
(114 cards)
1
Q
though a common tool in the workplace, can be quickly
tricky at times especially if you are typing a letter or making simple invitations
A
Word Processors
2
Q
the act of using a computer to create, edit, save andprint documents. In order to perform word processing, specialized software (known as a Word Processor) is needed.
A
Word Processing
3
Q
One example of a ______ is Microsoft Word, but other word processing applications are also widely used.
A
Word Processor
4
Q
Examples of Word Processor
A
Microsoft Word, Word Processor, Open Office Writer, Word Perfect and Google DriveDocument.
5
Q
list of the top examples of how you
could use a word processor.
A
Book
Document
Help Documentation
Journal
Letter
Marketing Plan
Memo
Report
Resume
6
Q
is a word processor developed by Microsoft. It was first released on October 25, 1983. It is also known as MS Word
A
Microsoft Word
7
Q
the date when MS Word was created
A
October 25, 1983
8
Q
Microsoft Word is also known as?
A
MS Word
9
Q
Capable of modifying the margins, size, and layout of a document.
A
Adjust the layout
10
Q
corrects common spelling errors well as capitalization
A
Autocorrect
11
Q
applies formatting to text, e.g. number listing, bullet, hyperlinks.
A
Autoformat
12
Q
More modern word processors help multiple people work on the same document at the same time.
A
Collaboration
13
Q
Once text is entered into a document, it can be copied or cut and pasted in the current document or another document.
A
Copying, Cutting, Pasting
14
Q
Word processors give you the ability to quickly find any word or text in any size of the document
A
Find
15
Q
proofreads documents for grammar, writing styles, sentence structure errors and reading statistics.
A
Grammar Checker
16
Q
Being able to adjust and change text in the header and footer of a document. The headers and footers of a document can be customized to contain page numbers, dates, footnotes, or text for all pages or specific pages of the document.
A
heads and footers
17
Q
Set and format tabs, bullet lists, and number lists.
A
indentation and lists
18
Q
Add tables to a document
A
insert tables
19
Q
Import and format data from CSV, database, or another source.
A
import data
20
Q
– a document that contains the formatting necessary for a specific document type
A
template
21
Q
Changing the font, font size, font color, bold, italicizing, underline, etc.
A
text formatting
22
Q
organize information into rows and columns
A
tables
23
Q
adjusts how the image behaves around other objects or text.
A
text wrap
24
Q
Look up alternatives to a word without leaving the program.
A
Thesaurus
25
Setup macros to perform common tasks.
macros
26
a feature that allows you to create document and merge the them with another document or data file.
mail merge
27
Create mailers or print labels
mailers and labels
28
Insert clip art, charts, images, pictures, and video into a document.
multimedia
29
While working on a document, you can have additional windows with other documents for comparison or move text between documents.
multiple windows
30
You can use the Search and Replace feature to replace any
search and replace
31
Checks for spelling and grammar errors in a document.
spelling and grammar
32
Word processors can detect the edges of a page or container and
automatically wrap the text using word wrap.
word wrap
33
allows you to change document settings, such as the font properties, adding bullets or a numbered list, adjusting styles, and other common features.
Home tab
34
Left, Right, Center and Justify
Line alignment
35
is used to insert different features such as tables, pictures, clip art, shapes, charts, page numbers, word art, headers, and footers into a document.
insert tab
36
refers to the arrangement of text, images, and other objects on a page.
Pages sizes are Short (letter) - .8.5” by 11” ; Long(Folio) – 8.5” by 13”; A4 – 8.27” by 11.69”
page layout
37
Portrait and Landscape
Orientation
38
Image Placements
in line with text, square, tight, through, top and bottom, behind text, in front of text
39
Feature of MS word that allows you to efficiently create documents that have the same general content but may have different recipients or purpose
mail merge
40
3 components of mail merge
main document, data source, merge document
41
ways to mail merge
1. Open MS Word and click the Mailings tab.
2. Click the Start Mail Merge command.
3. Select Step by Step Mail Merge Wizard and a Mail Merge task pane will appear at the right side of the document.
4. Choose the type of document you want to create. If you want to create a letter, select Letter. Six main steps in guiding you to complete a merge
will be displayed at the bottom.
5. Click Next: Starting document to move to Step2 .
6. Select Use the current
document. Click Next: Select recipients to move to Step 3.
7. From the Mail Merge taskpane, select Type a new list, then click Create.
8. The dialog box of New address list appears, displaying fields that Word assumes you need. Select an entry that you don’t need and click the Delete button. Use the Tab key to move form cell to cell.
42
To customize the address list, click ______ button at the bottom of the
window.
Customize Columns
43
Included in the mail merge feature on Microsoft Word is the
Label Generator/Generation
44
These are electronic or digital pictures or photographs you have saved in any local storage device. There are three commonly used types of picture files. You can identify them by the extension on their file names.
Pictures
45
These are electronic or digital pictures or photographs you have saved in any local storage device. There are three commonly used types of picture files. You can identify them by the extension on their file names.
Pictures
46
this is pronounced as “jay-peg” and is the short from for .jpeg or Photographic Experts Group. Like all the rest of the image file extensions, it identifies the kind of data compression process that it uses to make it more compatible and portable through the internet. This type of image file can support 16.7 million colors that is why it is suitable for use when working with full color photographic images.
JPG
47
number of colors in jpg
16.7 million
48
stands for Graphics Interchange Format, a type of image file capable of displaying transparencies. Therefore, it is good for blending with other materials or elements in your document. It is also capable
of displaying simple animation.
GIF
49
this is pronounced as “ping”. It stands for Portable Network Graphics. It was built around the capabilities of .GIF. Its development was basically for the purpose of transporting images on the internet at faster rates. It is also good with transparences but unlike. GIFs, it does not support animation but it can display up to about 16 million colors, so image quality for this image file type is also remarkably improved. It allows the control of the transparency of level and opacity f images.
PNG
50
number of colors in PNG
16 Million
51
Kinds/Types of pictures
JPEG,PNG,GIF
52
This is generally a .GIF type, live art drawings or images used as generic representation for ideas and objects that you might want to integrate in your document. Microsoft Word has a library of clip arts that is built in or can be downloaded and use freely. There are still other clip arts that you can either purchase or freely download and use that come from third-party providers.
Clip Art
53
these are printable objects or materials that you can integrate in your document to enhance its appearance or allow you to have some tools to use for composing and representing ideas or messages. If you are
designing the layout for a poster or other graphic material for advertising, you might find this useful.
Shapes
54
Generally, these are predefined sets of different shapes grouped together to form ideas that are organizational or structural in nature. If you want to graphically represent an organization, process,
relationships, or flow for infographic documents, then you will find this easy and handy to use.
Smart Art
55
Another type of material that you can integrate in your Word document that allows you to represent data characteristics and trends.
This is quite useful when you are preparing reports that correlate and present data in a graphical manner.
Chart
56
Sometimes, creating reports or manuals for training or procedures will required the integration of a more realistic image of what you are discussing on your report or manual. Nothing can get you a more realistic image than a screenshot.
Screenshot
57
refers to the spreadsheet program which is the electronic version of the familiar columnar pad. It is an application that helps the user to create spreadsheets commonly used for budgets, forecasting, and finance-related tasks.
Spreadsheet
58
is a spreadsheet program that allows you to store, organize, and analyze information.
Excel
59
Advanced Spreadsheet Skills Needed in Life
1. Data Entry, Sorting, and Filtering
2. Applying Data Validation
3. Protecting Sheets and Locking Cells
4. Custom Filtering
5. Sort by Column
6. Pivot Tables
7. Macros and Scripts
8. Combine Multiple Functions to Create Formulas
9. Perform Calculations
60
are tools with which you can manipulate, analyze and draw calculations about your worksheet data
formulas
61
One of this program’s most valuable features is its ability to store
math formulas in individual cells
62
simply a mathematical operation you can perform in your worksheet.
a formula
63
The formula produces a
new value from existing value
64
A formula can contain up to ____ characters and must always start with an equal sign (=).
1024
65
A formula can contain up to 1024 characters and must always start with an
equal sign (=)
66
In its basic form, a formula can ________ two numbers, displaying the answering a cell that you choose.
add, subtract, multiply or divide
67
:
reference operator
68
,
argument separator
69
-
negation(-4)
70
%
percentage sign
71
^
exponentiation
72
* and /
multiplication and division
73
&
text concatenation combining two strings)
74
two basic cell reference
relative and absolute
75
Excel changes the cell references in the copies of the formulas to reflect the _____ of the formula from the cell references in the formula.
relative location
76
You use an _______ formula when you want to anchor cell references in a formula.
absolute reference
77
Using the ______ function will allow us to count the number of cells that contains something
=COUNTIF
78
the cells where the counting will take place.
range
79
the label or value that determine if it is to be counted.
criteria
80
the actual range of cells that will be averaged, if omitted, the range will be used instead.
average range
81
Using the ______, we can average a range if the cell beside it equals to “teacher” and/ or “student”.
AVERAGEIF
82
the ____ of cells where you want to look for the criteria.
range
83
a value or label that determines if a cell is part of the range to be averaged.
criteria
84
This is the default setting for images that are inserted or integrated in a document
in line with text
85
This setting allows the image you inserted to be place anywhere within the paragraph with the text going around the image in a square pattern like a frame.
square
86
This is almost the same as the square setting, but here the text “hugs” to the general shape of the image.
tight
87
This setting allows the text on your document to flow even tighter, takingthe contour and shape of the image.
through
88
This setting pushes the text away vertically to the top and / or the bottom of the image so that the image occupies a whole text line on its own.
top and bottom
89
This allows your image to be dragged and place anywhere on your document but all text floating in front it.
behind text
90
This setting allows your image to be placed right on top of the text as if your image was dropped right on it.
in front of text
91
Ctrl + a
select all
92
Ctrl + b
bold
93
Ctrl + c
copy text
94
Ctrl+d
show front dialog box
95
Ctrl+e
align text to center
96
Ctrl+f
display find dialog box
97
Ctrl+g
display go to dialog box
98
Ctrl+h
display replace dialog box
99
Ctrl+i
italize text
100
Ctrl+j
justify text
101
Ctrl l
align text left
102
Ctrl+m
tab
103
Ctrl+n
create new document
104
Ctrl+o
open a document
105
Ctrl+p
display print dialog box
106
Ctrl+r
align text to right
107
Ctrl+s
save document
108
Ctrl+u
underline text
109
Ctrl+v
paste text
110
Ctrl+x
cut a selected text
111
Ctrl+y
redo the last undone action
112
Ctrl+z
undo the last action
113
Advanced Spreadsheet Skills Needed in Life
1. Data Entry, Sorting, and Filtering
2. Applying Data Validation
3. Protecting Sheets and Locking Cells
4. Custom Filtering
5. Sort by Column
6. Pivot Tables
7. Macros and Scripts
8. Combine Multiple Functions to Create Formulas
9. Perform Calculations
114
It is a sequence of values, cell references, names, functions and operators that are contained in a cell.
formula
