Blogumulus by Roy Tanck and Amanda FazaniDistributed by CahayaBiru.com

MIDDLE TEST SEMESTER 2 2010/2011

Rabu, 13 April 2011

QUESTION!!
1. Please, specify all the members of microsoft office 2007 and it's function !
2. Please, specify all the members of pull down menu in Ms. Excel 2007!
3. Please, specify the number of columns and rows in:
a. Microsoft excel 2007
b. Microsoft excel 2003
4. Whether its function in Ms. Excel 2007?
a. Format Cells
b. Sum
c. Count numbers
d. Max
e. Min
f. Countif
g. Vlookup
h. Hlookup
i. Mid
j. Round 0, round 1, round 2
5. If the value is less than 76 , then "FAIL" and if its value is more than 76, then "SUCCESS".
Please write a formula that should be used!

ANSWER

1. Ms. Excel 2007
function: automatic data processing includes basic calculations, the use of
functions, graphing and data management.

Ms. Word 2007
function: used to create reports, documents in the form of newspapers, mailing
labels, create tables in the document.

Ms. Power Point 2007
function : used to Another presentation processing, text objects, graphics,
video, sound, and other objects are positioned in a few individual
pages called "slide".

Ms. Publisher 2007
function : used for desktop publishing.

Ms. Outlook 2007
function : be used to send and read e-mail, the program also has a calendar
function, work schedules, notes, and journals. When used in
conjunction with Microsoft Exchange Server, Outlook can provide access
to mailboxes, calendars, and schedules together.

Ms. Access 2007
function : to make a homemade system to handle the manufacture and manipulation
of data. Access also can be used as a database for basic Web
applications that are stored on the server running Microsoft Internet
Information Services (IIS) and Microsoft Active Server Pages (ASP).

2. Home:

* Clipboard
* Font
* Alignment
* Number
* Styles
* Cells
* Editing

Insert

* Tables
* Illustrations
* Charts
* Links
* Text

Page Layout

* Themes
* Page Setup
* Scale to Fit
* Sheet Options
* Arrange

Formulas

* Function Library
* Defined Names
* Formula Auditing
* Calculation

Data

* Get External Data
* Connections
* Sort and Filter
* Data Tools
* Outline

Review

* Proofing
* Comments
* Changes

View

* Workbook Views
* Show/Hide
* Zoom
* Window
* Macros

3. a. Ms. Excel 2007
Columns: 16.384
Rows: 1.048.576
b. Ms. Excel 2003
Columns: 256
Rows: 65.536

4. a. Format Cells: To change cells or do formatting cells.
b. Sum: To sum the data in range or list.
c. Count Numbers: To calculate the data in range.
d. Max: To find maximun of data in range or list.
e. Min: To find minimun of data in the range or list.
f. Countif: To calculate the more data in the list or range.
g. Vlookup: To read the table with vertical.
h. Hlookup: To read the table with horizontal.
i. Mid: To find middle number in the range.
j. Round 0, Round 1, Round 2: To round the numbers with decimal number who wanted.

5. =IF(cell<76;"FAIL";"SUCCESS")

 
FaceBlog © Copyright 2009 MemEy_"v-tiMe'Z'' | Blogger XML Coded And Designed by Edo Pranata