PRODUCTIVITY TOOLS

44問 • 1年前

問題一覧

It refers to the software that people use to CREATE AND PRODUCE DOCUMENTS, presentations, databases, charts, and graphs.

Productivity Tools

Common productivity tools

Microsoft word Microsoft excel Microsoft PowerPoint LibreOffice

Although, — is a Free and Open Source software, most software available in actual workplace are made from .

LibreOffice Microsoft

It is a Word’s way of generating MASS MAILINGS.

Mail Merge

It involves COMBINING A LIST OF NAMES and addresses TO INDIVIDUALLY ADDRESS to each person / receiver on the list.

Mail Merge

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

Mail Merge

Mail Merged involved the following documents:

Main document Mailing list Merged document

– this document contains TEXT AND GRAPHICS. Example body of the letter.

Main document

– this is your data source that is used to POPULATE INFORMATION In the letter.

Mailing list

It contains NAMES AND ADDRESS of the recipients.

Mailing list

- this document the COMBINATION of the MAIN DOCUMENT

Merged document

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

Animation

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

hyperlink

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

Hyperlinks

In text hyperlinks are often —2

color blue and underlined.

When you move the cursor over a hyperlink, whether it is text, button or an image, the arrow cursor should be change to a

small hand pointing to the link.

Hyperlinks have basic parts:

Address Display

– can be webpage, email address, or other LOCATION THEY ARE LINKING.

The Address

– can be picture or shape.

The Display

refers to an APPLICATION program for MANIPULATING TEXT-BASED DOCUMENTS; the electronic equivalent of paper, pen, typewriter, eraser, and most likely, dictionary and thesaurus.

Word processing

run the scope from simple through complex, but all ease the tasks associated with EDITING DOCUMENTS (deleting, inserting, rewording, and so on).

Word processors

According to —, — is probably the most useful general-purpose software for the microcomputer user.

emerald.com, electronic spreadsheet

Almost all SPREADSHEETS are now packaged in COMBINATION with other APPLICATIONS, such as —

database system and graphic capabilities.

refers to a collection of text and numbers laid out in a 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

Electronic spreadsheet replaces the traditional financial modeling tools, the —

accountant’s columnar pad, pencil and calculator.

It a spreadsheet program, data and formulas used to calculate those DATA are entered into — for analysis, tracking, planning, or “what-if” evaluations of the impact of real or proposed changes on an economic strategy.

ledge-like forms (Spreadsheets or Worksheets)

A great FREE ALTERNATIVE spreadsheet program is —2 spreadsheet program.

LibreOffice Calc, and OpenOffice

– is an equation that performs operation on worksheet data.

Formula

A formula in Microsoft Excel always begins with an —

equal sign (=).

Common Error Values That You Can Encounter from Faulty Formulas:

#DIV/0! ##### #NAME? #N/A #NULL! #REF! #NUM! #VALUE!

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

#DIV/0!

#DIV/0! The solution is to make sure that the DIVISOR in the function or formula is — or — or change the cell reference in the formula to another cell that does not contain a

not zero (0) blank zero or a blank value.

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, the VLOOKUP, HLOOKUP, or MATCH worksheet function was used to locate a VALUE IN AN UNSORTED TABLE, an array formula (

#N/A

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 contains the 1—, one or more required arguments were omitted from a built-in or custom worksheet function, a custom worksheet function that you use is not available and a macro that you run enters a function that returns

Array formulas

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!

A formula that performs MULTIPLE CALCULATIONS on one or more sets of values, and then returns either a SINGLE RESULT OR MULTIPLE RESULTS.

array formula:

ALERTNESS

Trix Soriano · 24問 · 2年前

ALERTNESS