MODULE 4 Flashcards by angie lina

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

Productivity Tools

How well did you know this?

Not at all

Perfectly

True or False

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

True

How well did you know this?

Not at all

Perfectly

Why should you learn productivity tool?

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?

Not at all

Perfectly

Common productivity Tools?

Microsoft word
Microsoft excel
Microsoft PowerPoint
LibreOffice

How well did you know this?

Not at all

Perfectly

True or False

LibreOffice is a Free and Open-Source software

True

How well did you know this?

Not at all

Perfectly

True or False

Most software available in actual workplace are made form Microsoft

True

How well did you know this?

Not at all

Perfectly

What is the Use Case of this Tools/Techniques?

Mail merge and label generation

Mass email or printed letters

How well did you know this?

Not at all

Perfectly

What is the Use Case of this Tools/Techniques?

-Costum animation and timing

Enhance viewer experience

How well did you know this?

Not at all

Perfectly

What is the Use Case of this Tools/Techniques?

Hyperlinking in presentation

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

How well did you know this?

Not at all

Perfectly

What is the Use Case of this Tools/Techniques?

-Integrating images and external materials in word processor

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

How well did you know this?

Not at all

Perfectly

Embedded files and data

Seamlessly integrates related files

How well did you know this?

Not at all

Perfectly

Advanced and complex formulas and computation

Simplifies and automated common tasks

How well did you know this?

Not at all

Perfectly

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.

Mail Merge

How well did you know this?

Not at all

Perfectly

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

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

How well did you know this?

Not at all

Perfectly

Mail Merged involved the following documents;

• Main document
• Mailing list
• Merged document

How well did you know this?

Not at all

Perfectly

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

Main document

How well did you know this?

Not at all

Perfectly

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

Mailing list

How well did you know this?

Not at all

Perfectly

this document the combination of the main document

Merged document

How well did you know this?

Not at all

Perfectly

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.

Custom Animation

How well did you know this?

Not at all

Perfectly

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

Custom Animation

How well did you know this?

Not at all

Perfectly

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

Preview Results

How well did you know this?

Not at all

Perfectly

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

d. =1a+b2

How well did you know this?

Not at all

Perfectly

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

DIV/0

How well did you know this?

Not at all

Perfectly

Which of the following arithmetic operators is use for exponentiation?

How well did you know this?

Not at all

Perfectly

software that are commonly used for presentation that contains animation?

PowerPoint

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

**#REF!**

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

**#Value!**

set of effects that can be found in PowerPoint apps?

Costum animation

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

COUNT

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

True

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

False

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

False

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

False

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

True

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

True

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

False

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

False

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

False

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

True

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

Hyperlink

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

Hyperlink

often color blue and underlined.

Hyperlink

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.

Hyperlink

Basic parts of hyperlinks?

The address The display

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

The Address

Can be picture or shape

The display

• https://www.microsoft.com

- address

• microsoft

- display text

• https://www.microsoft.com

- address at the same time display text

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 _____________ ____________.

**Integrating Images** and **Integrate Images**

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.

Integrating Images

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

Integrating Images

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

**emerald.com**

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

Electronic Spreadsheet

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

Electronic Spreadsheet

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

Electronic Spreadsheet

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

Electronic Spreadsheet

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

Electronic Spreadsheet

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.

Electronic Spreadsheet

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

Formula

Common Error Values That You Can Encounter from Faulty? Formulas

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

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

**#DIV/0!**

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

**#####**

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.

#NAME?

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

#N/A

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

#N/A

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,

#N/A

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

#N/A

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

#N/A

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

Show Calculation Steps

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

#NULL!

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.

#NUM!

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.

#REF!

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.

.#VALUE!

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

#VALUE!

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

=A12

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

=10 +3^2

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

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

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

=50% * 20

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

-(F3 * J25)

**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.

=6 * (G5-P7)

**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

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