MODULE 4 Flashcards

1
Q

It refers to the software that people use to create and produce documents, presentation,databases, charts, and graphs

A

Productivity Tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False

Productivity Tools helps you to create professional quality documents, presentation, graphics, and more

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Why should you learn productivity tool?

A

While there are a wide range of benefits of using productivity Tools, it just makes essential, everyday we use computer to do different task for more efficient

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Common productivity Tools?

A
  1. Microsoft word
  2. Microsoft excel
  3. Microsoft PowerPoint
  4. LibreOffice
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

True or False

LibreOffice is a Free and Open-Source software

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

True or False

Most software available in actual workplace are made form Microsoft

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the Use Case of this Tools/Techniques?

  • Mail merge and label generation
A

Mass email or printed letters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the Use Case of this Tools/Techniques?

-Costum animation and timing

A

Enhance viewer experience

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the Use Case of this Tools/Techniques?

  • Hyperlinking in presentation
A

-Optimizes use of related content and references. Applies to Word/Write document too.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the Use Case of this Tools/Techniques?

-Integrating images and external materials in word processor

A

Enriches textual content. Also useful in presentation slides and sometimes in spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Embedded files and data

A

Seamlessly integrates related files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Advanced and complex formulas and computation

A

Simplifies and automated common tasks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

It is a Word’s way of generating mass mailings. It involves combining a list of names and addresses to individually address to each person / receiver on the list.

A

Mail Merge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

You can use Mail Merge to create _________ or ___________ __________ , as well as form _________ .

A

You can use Mail Merge to create envelopes or address labels, as well as form letters.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Mail Merged involved the following documents;

A

• Main document
• Mailing list
• Merged document

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

this document contains text and graphics. Example body of
the letter.

A

Main document

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

this is your data source that is used to populate information in the letter. It contains names and address of the recipients.

A

Mailing list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

this document the combination of the main document

A

Merged document

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

a simulation of movement created by displaying a series of pictures, or frames. Animation on computers is one of the chief ingredients of multimedia presentations.

A

Custom Animation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

software applications that enable you to create animations that you can display on a computer monitor.

A

Custom Animation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What button allows you to see the result of your mail merge even before you print or send it out?

A

Preview Results

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

The following are formulas that MS-Excel can understand, EXCEPT.
A. =Sum(a1+a2)
b. =a1+b2
C. =average(a1+a2)
d. =1a+b2

A

d. =1a+b2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

This error value refers to a cell that contains 0 value or blanks.

A

DIV/0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Which of the following arithmetic operators is use for exponentiation?

A

^

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

software that are commonly used for presentation that contains animation?

A

PowerPoint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Which of the following errors will appear if Excel encounters invalid cell reference.

A

#REF!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Which of the following errors will appear if Excel encounters invalid cell has inappropriate value was given for the lookup value argument.

A

#Value!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

set of effects that can be found in PowerPoint apps?

A

Costum animation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

A function used to count the number of cells that contains something if the criteria are met.

A

COUNT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

True or False
LibreOffice is a free and open source software.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

True or False
Main document is a data source that is used to populate information in the letter.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

True or False
The default orientation of the document is a Landscape.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

True or False
You can change the color of display text in a hyperlink.

A

False

34
Q

True or False
Formula is an equation that performs operation on worksheet data.

A

True

35
Q

True or False
The hyperlink can be a website address at the same time display text.

A

True

36
Q

True or False
The default number of worksheets in an excel is 3.

A

False

37
Q

True or False
Times New Roman is the default font style in Microsoft Office 2016.

A

False

38
Q

True or False
The data source in a mail merge is your mailing document.

A

False

39
Q

True or False
The mouse pointer becomes different shapes depending on the task you are performing.

A

True

40
Q

A simply a link, is a reference data that the reader can directly follow either by clicking or tapping.

A

Hyperlink

41
Q

found in nearly all Web pages, allowing users to click their way from one page to another.

A

Hyperlink

42
Q

often color blue and underlined.

A

Hyperlink

43
Q

When you move the cursor over a _________, whether it is text, button or an image, the arrow cursor should be change to a small hand pointing to the link.

A

Hyperlink

44
Q

Basic parts of hyperlinks?

A

The address
The display

45
Q

can be webpage, email address, or other location they are
linking.

A

The Address

46
Q

Can be picture or shape

A

The display

47
Q

• https://www.microsoft.com

A
  • address
48
Q

• microsoft

A
  • display text
49
Q

• https://www.microsoft.com

A
  • address at the same time display text
50
Q

In Microsoft word processing you can do a lot of things to make your documents look good and presentable. One of its function is to _____________ ____________.

A

Integrating Images and Integrate Images

51
Q

Word processing refers to an application program for manipulating text-based documents; the electronic
equivalent of paper, pen, typewriter, eraser, and most likely, dictionary and thesaurus.

A

Integrating Images

52
Q

Word processors run the scope from simple through complex, but all ease the tasks associated with editing documents (deleting, inserting, rewording, and so on).

A

Integrating Images

53
Q

According to _____________ electronic
spreadsheet is probably the most useful general-purpose software for the microcomputer user.

A

emerald.com

54
Q

According to emerald.com electronic
spreadsheet is probably the most useful general-purpose software for the microcomputer user.

A

Electronic Spreadsheet

55
Q

Almost all spreadsheets are now packaged in combination with other applications, such as database system and graphic capabilities.

A

Electronic Spreadsheet

56
Q

refers to a collection of text and numbers laid out in a Photo Credit: https://bit.ly/36Gzsdv rectangular grid.

A

Electronic Spreadsheet

57
Q

It is an application program commonly used for budgeting, inventory management, decision making, forecasting and other finance-related tasks.

A

Electronic Spreadsheet

58
Q

It replaces the traditional financial modeling tools, the accountant’s columnar pad, pencil and calculator.

A

Electronic Spreadsheet

59
Q

It a spreadsheet program, data and formulas used to calculate those data are entered into ledge-like forms (Spreadsheets or Worksheets) for analysis, tracking, planning, or “what-if” evaluations of the impact of real or proposed changes on an economic strategy.A great free alternative spreadsheet program is LibreOffice Calc, and OpenOffice spreadsheet program.

A

Electronic Spreadsheet

60
Q

an equation that performs operation on worksheet data. A formula in Microsoft Excel always begins with an equal sign (=).

A

Formula

61
Q

Common Error Values That You Can Encounter from Faulty? Formulas

A

#DIV/0!
#####
#NAME?
#N/A

62
Q

appears when entering a formula that performs explicit division by zero (0), using a reference to a blank cell or to a cell that contains zero as the divisor in a formula or function that performs division or running a macro that uses a function or a formula that returns the #DIV/0! error. The solution is to make sure that the divisor in the function or formula is not zero (0) or blank or change the cell reference in the formula to another cell that does not contain a zero or blank value

A

#DIV/0!

63
Q

appears when the column is not wide enough to display the content and/or dates and times are negative numbers. the solution is to increase the column width

A

#####

64
Q

Appears when the formula refers to a range name that doesn’t exist in the worksheet. This error value appears when you type the wrong range name or fail to enclose in quotation marks some text used in the formula, causing Excel to think that the text refers to a range name.

A

NAME?

65
Q

appears when an inappropriate value was given for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function

A

N/A

66
Q

Appears when the VLOOKUP, HLOOKUP, or MATCH worksheet function was used to locate a value in an unsorted table,

A

N/A

67
Q

Appears when an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) is using an argument that is not the same number of rows or columns as the range that containsthe array formula,

A

N/A

68
Q

Appears when one or more required arguments were omitted from a built-in or custom worksheet function

A

N/A

69
Q

a custom worksheet function that you use is not available and a macro that you run enters a function that returns _________.

A

N/A

70
Q

_______ _________ _________ if it appears, and then click the resolution that is appropriate for your data.

A

Show Calculation Steps

71
Q

Appears most often when you insert a space (where you should have used a comma to separate cell references used as arguments for functions.

A

NULL!

72
Q

Appears when Excel encounters a problem with a number in the formula, such as the wrong type of argument in an Excel function or a calculation that produces a number too large or too small to be represented in the worksheet.

A

NUM!

73
Q

Appears when Excel encounters an invalid cell reference, such as when you delete a cell referred to in a formula or paste cells over the cells referred to in a formula.

A

REF!

74
Q

Appears when you use the wrong type of argument or operator in a function, or when you call for a mathematical operation that refers to cells that contain text entries.

A

.#VALUE!

75
Q

For example, the formula =A1+B1, where A1 contains the string “Hello” and B1 contains the number 3, returns the ___________ error.

A

VALUE!

76
Q

GIVE THE EXCEL FORMULAS
Assigns the vale in cell A2 to the active cell

A

=A12

77
Q

GIVE THE EXCEL FORMULAS
Assigns the sum of 10 + 9(or 19) to the active cell.

A

=10 +3^2

78
Q

GIVE THE EXCEL FORMULAS
Assigns three times the contents of cell D5 to the active cell.

A

=3D5 or D53 or
=(3*D5)

79
Q

GIVE THE EXCEL FORMULAS
Assigns the product of 0.50 times 20 (or 10) to the active cell.

A

=50% * 20

80
Q

GIVE THE EXCEL FORMULAS
Assigns the negative value of the product of the values contained in cells F3 and J25 to the active cell.

A

-(F3 * J25)

81
Q

GIVE THE EXCEL FORMULAS
Assigns the product of 6 times the difference between the values contained in cells G5 and P7 to the active cell.

A

=6 * (G5-P7)

82
Q

GIVE THE EXCEL FORMULAS
Completes the following operations, from left to right:
exponentiation (A3^F3), then division (B4/D8 –E3 *M10) + (A3 ^F3). If cells A3=2, F3=4, E3=6, B4=3, M10=4, and D8=3, then Excel assigns the active cell the value 18; that is, 3/3 – 6 * 4 + 2 ^ 4 = -7

A

=B4/D8-E3 * M10 +A3
^F3