M4: Advanced Techniques Using Microsoft Word and Excel

Question 1

Software application that enables a user to save and sort and manage data in an arranged form of rows and columns.

Answer 1

Spreadsheet

Question 2

What is the most commonly used software program?

Answer 2

MS Excel

Question 3

What is the use of spreadsheet?

Answer 3

(1) Determine statistical analysis, (2) Compute student’s grades, (3) Keep track of business accounts and inventories, (4) Manage database

Question 4

Identified with alphabetical headings; Cells going vertical

Answer 4

Columns

Question 5

Identified with numeric headings; Cells going horizontal

Answer 5

Rows

Question 6

Intersection of rows and columns

Answer 6

Cells

Question 7

Cell address; Identifies a specific cell on a worksheet

Answer 7

Cell Reference

Question 8

Identifies the purpose of a cell; Brief title or caption

Answer 8

Text or Labels

Question 9

An expression that calculates the value of a cell; Mathematical Equations

Answer 9

Formula

Question 10

MS Excel uses standard operators for formulas.

Answer 10

Mathematical Operations

Question 11

Predefined formulas that are already available in MS Excel

Answer 11

Functions

Question 12

Adds all the numbers in a range of cells.

Answer 12

Sum

Question 13

Counts the number of cells that contain numbers.

Answer 13

Counts

Question 14

Returns the smallest number in a set of values.

Answer 14

Min

Question 15

Returns the largest value in a set of values.

Answer 15

Max

Question 16

Returns the average (arithmetic mean) of the arguments.

Answer 16

Average

Question 17

Adds the cells specified by a given condition or criteria

Answer 17

SUMIF

Question 18

The range of cells that you want to evaluate based on a given criteria?

Answer 18

Range

Question 19

It determines which cells will be added?

Answer 19

Criteria

Question 20

cells containing numeric values and the cells to add if the condition is met?

Answer 20

Sum_Range

Question 20

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

Answer 20

AVERAGEIF

Question 21

Counts the number of cells within a range that meet a single criterion that you specify.

Answer 21

COUNTIF

Question 22

This function is one of the most popular functions in Excel. It can perform a logical test and returns one value if TRUE, and another value if FALSE..

Answer 22

IF

Question 23

A value or logical expression that can be evaluated as True or False.

Answer 23

Logical Test

Question 24

The value to return if the logical test or logical expression evaluates to TRUE.

Answer 24

Value if True

Question 25

The value to return if the logical test or logical expression evaluates to FALSE

Answer 25

Value if False

Question 26

a complex which people use to perform various functions such as composing and editing formatting and saving and printing.

Answer 26

Microsoft Word

Question 27

Allows u to create documents and combine them with another document or data file.

Answer 27

Mail Merge

Question 28

What are the two components of Mail Merging?

Answer 28

(1) Main Document and (2) Data Source

Question 29

The document that contains the body of the message we want to convey or send.

Answer 29

Main Document

Question 30

It is your Excel® spreadsheet containing the names and addresses you want to merge into a Word® document from the Data Source.

Answer 30

Data Source

Question 31

How to perform mail merge?

Answer 31

(1) Create the Main Document, (2) Create Data Source, (3) Merge Data with Document