問題一覧
1
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
2
It refers to the software that people use to CREATE AND PRODUCE DOCUMENTS, presentations, databases, charts, and graphs.
Productivity Tools
3
Mail Merged involved the following documents:
Main document Mailing list Merged document
4
– can be webpage, email address, or other LOCATION THEY ARE LINKING.
The Address
5
Common Error Values That You Can Encounter from Faulty Formulas:
#DIV/0! ##### #NAME? #N/A #NULL! #REF! #NUM! #VALUE!
6
In text hyperlinks are often —2
color blue and underlined.
7
Electronic spreadsheet replaces the traditional financial modeling tools, the —
accountant’s columnar pad, pencil and calculator.
8
Although, — is a Free and Open Source software, most software available in actual workplace are made from .
LibreOffice Microsoft
9
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!
10
– this document contains TEXT AND GRAPHICS. Example body of the letter.
Main document
11
A formula in Microsoft Excel always begins with an —
equal sign (=).
12
is a simulation of movement created by displaying a series of pictures, or frames.
Animation
13
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!
14
– is an equation that performs operation on worksheet data.
Formula
15
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.
16
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?
17
It contains NAMES AND ADDRESS of the recipients.
Mailing list
18
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:
19
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!
20
– can be picture or shape.
The Display
21
You can use — to create envelopes or address labels, as well as form letters.
Mail Merge
22
- this document the COMBINATION of the MAIN DOCUMENT
Merged document
23
refers to a collection of text and numbers laid out in a rectangular grid.
Electronic spreadsheet
24
It is a Word’s way of generating MASS MAILINGS.
Mail Merge
25
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
26
appears when the column is NOT WIDE ENOUGH to display the content and/or dates and times are negative numbers.
#####
27
on computers is one of the chief ingredients of multimedia presentations.
Animation
28
According to —, — is probably the most useful general-purpose software for the microcomputer user.
emerald.com, electronic spreadsheet
29
Common productivity tools
Microsoft word Microsoft excel Microsoft PowerPoint LibreOffice
30
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!
31
A — or simply a link, is a reference data that the reader can directly follow either by clicking or tapping.
hyperlink
32
– this is your data source that is used to POPULATE INFORMATION In the letter.
Mailing list
33
Almost all SPREADSHEETS are now packaged in COMBINATION with other APPLICATIONS, such as —
database system and graphic capabilities.
34
A great FREE ALTERNATIVE spreadsheet program is —2 spreadsheet program.
LibreOffice Calc, and OpenOffice
35
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!
36
Hyperlinks have basic parts:
Address Display
37
are found in nearly all Web pages, allowing users to click their way from one page to another.
Hyperlinks
38
It involves COMBINING A LIST OF NAMES and addresses TO INDIVIDUALLY ADDRESS to each person / receiver on the list.
Mail Merge
39
It is an application program commonly used for budgeting, inventory management, decision making, forecasting and other finance-related tasks.
Electronic spreadsheet
40
run the scope from simple through complex, but all ease the tasks associated with EDITING DOCUMENTS (deleting, inserting, rewording, and so on).
Word processors
41
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)
42
##### The solution is to increase the
column width.
43
#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.
44
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