Page 213 - DCAP101_BASIC_COMPUTER_SKILLS

Basic Computer Skills

Notes 10.10 Keywords

Documents: A document is a work of non-fiction writing intended to store and communicate
information, thus acting as a recording. Documents are often the focus and concern of
business administration and government administration. The word is also used as a verb as
“documenting” describes the process of making a document.
Excel Worksheets: The worksheets are used for numerous tasks such as to collect and analyze
information, including records, notes, activity budgets, professional organization information,
data, financial reports, nutritional diaries, and legislative voting records.
Format Cell: When you enter data into a cell in Excel, it is handled differently depending
on what type of formatting you have assigned to the cell. For example, if you choose
Currency formatting, Excel will automatically convert 3 into $3.00; if you choose Date
formatting, Excel would convert 3/1 to March 1, 2002; and if you choose Percent formatting,
Excel would change 0.3 to 30%.

Office Assistant: The Office Assistant was a Microsoft Office feature to assist users by way
of an interactive animated character, which interfaced with the Office help content. It used
technology initially from Microsoft Bob and later Microsoft Agent, offering advice based
on Bayesian algorithms. In Microsoft Office for Windows, it was included in versions 97
to 2003.

1. Make a table and find the average of mark column.
2. Make the table and use the Trigonometric function.

10.11 Self-Assessment Questions

1. All formula in Excel start with
(a) % (b) +
(c) = (d) –
2. You can use a function to combine text from two cells into one cell. But you can use
an operator to do the same thing. Which operator is that?
(a) & (ampersand) (b) = (equal sign)
(c) (space) (d) All of these
3. Two common wildcard characters that Excel recognizes are
(a) * and ? (b) < and >
(c) ^ and / (d) . + and –
4. The divide symbol is
(a) /. (b) D

(c) \. (d) )
5. The multiplication arithmetic operator is represented by which of the following
symbols?
(a) ^. (b) *.
(c) /. (d) X

206 LOVELY PROFESSIONAL UNIVERSITY