Rabu, 23 Maret 2011

MIDDLE TEST SEMESTER II 2010/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 and it's function !
3. Please, specify the number of columns and rows in :
a.Microsoft Excel 2007 !
b.Microsoft Excel 2003 !
4. Whether it's 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 it's value is more than 76, then "SUCCESS".
Please, write a formula that should be used !

ANSWERS :
1. 1. a. MICROSOFT WORD 2007
Function:
As we know, MS WORD document used to help manufacture the form of reports or papers. However, we sometimes forget to utilize the various facilities available in MS WORD, but with the advantage of these facilities to help accelerate document creation. Therefore, this paper aims to remind again (especially for me personally) the various facilities available in MS WORD.

1. Typeface

In order for the document produced is not too much experience editing in the problem of "font", you should first specify the default font to be used. (Menu Home + Fonts)

2. Making Numbering

Typically, the creation of a document refers to certain rules in making the document (eg Chapter I Introduction, Chapter II Review of Literature). Therefore, it must be defined in advance about numbering in accordance with the rules of making the document.

3. Preparation Outline

Get used to working with the document view form outline. (Menu View + Document + Outline Views.) This will allow us to make important points that will be outlined in the document. Making the document in outline form, at least up to level 3. There are times when moving from level 1 to level 2 we are required to change the list level (Multiple List Menu home + + Change List Level)

4. Use Section Break

Usually there is a difference in a document type of page numbering for each section (for example: the cover page is usually no page numbers, Preface & Table of Contents & List of Tables are numbered page type "i, ii, iii, ...", Parts I and so are numbered type "1,2,3 ...") Therefore, for every turn of a page type is given a break section. (Menu Page Layout + Break + Next Page).
5. Numbering Pages

As mentioned in point 4, then the page numbering will use the facilities section break. Each section is numbered like the pages that you want (menu insert + + Format Page Number Page Number Page numbering + + start at ... then select the page number where the bottom or top of page) special cover page, usually there are no page numbers, headers therefore / footer of his need to edit (Menu + insert header / footer + edit the header / footer + Design + select different first page)

6. Making List of Tables

Table / Figure / Chart created cultivated given the caption consisting of the chapter title and number of images. (Menu References + Insert Caption ... on option select the desired label, remove the check mark on the label exclude from caption). For making a list of tables / images / chart then select the menu references + insert a table of figures), the list of tables can appear automatically. If there is any change of position on the page table / images / chart, then right-clicked a list of live table select update field.

7. Making Table of Contents

Making table of contents automatically is by select references + table of contents. If there are changes in the layout page will list the contents stay in the update (as well as update the list of tables)

8. Editing the Document Map

In order for editing to be done can be done quickly, it can utilize the facility document folder (Menu View + document folder). With this facility, transfer the page to be edited to go faster)



b. MICROSOFT EXCEL 2007
Function:

Microsoft Excel is a key program that comes with Microsoft Office suite. But what is really used for? It may surprise you to know that many of the tasks of everyday life, both personal and business, can be simplified by using Excel. Articles can be created, the database can be saved, and simple math courses can be completed only with a few keystrokes.

1. Calculator

Microsoft Excel is the only program in Office that allows users to automatically calculate the numbers. You can add, multiply, divide and reduced using a simple formula. Simply select a cell and type an equal sign ("="). Enter a math problem, say for example, "10 20" or "15 * 15" ("*" is the operator for the sign of multiplication in Excel). If you have a set of numbers contained in an Excel spreadsheet, select all cells, and look at the bottom of the dashboard right of the window to see the number.

2. Automatic Updating

Rather than repeatedly typing in numbers, enter information about your cells to work with to get updates total. For example, if there are two cells, A1 and B1, creating a formula to automatically reduce the B1 from A1 by typing "= B1-A1" into the new cell (as C1). Every time the A1 or B1 changes, the figure in C1 will be updated. This is very useful for spreadsheets, accounting and tax.

3. Database
In addition to being advanced calculators, Excel also functions as a database. You can save a list of information in this program, just as you would in Microsoft Access. Numerical data can be added and manipulated in an Excel database.
4. Statistical Report

Many users rely on Excel as a way to track statistics. Because the program can display the figures as percentages and perform automatic calculations, performing statistical reporting tasks very intuitive. You can import data from other databases (like the list in Word or Access), and create a formula that will display the statistics are clear, easily understandable format.

5. Charts and Graphs

Microsoft Excel serves as a maker of tables and graphs. Using the information collected and compiled into Excel, you can create a visual graph of the data, then copy and paste the chart into another program, or produce a report that is more colorful.


c. MICROSOFT POWER POINT 2007
Function:
1) Microsoft Power Point is an application program that serves to make presentations in the form of slides
2) To run the Wizard in organizing information and for designing the display / presentation
3) To help organize the presentation of information and help with the overall appearance


d. MICROSOFT PUBLISHER 2007
Function: Microsoft publisher 2007 has a function that is used for Desktop publishing


e. MICROSOFT ACCESS 2007
Function : Microsoft Access is used mostly by businesses small and medium enterprises, in an even smaller organizations may also be used by large companies, and also the programmer 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). Nevertheless, the use of Access is less advisable, given the existing Microsoft SQL Server that has a higher ability. Some professional application developers use Microsoft Access to develop applications quickly (used as a Rapid Application Development / RAD tool), especially for the manufacture of prototypes for a larger program and a stand-alone applications for the salesman. Microsoft Access not so good if accessed through the network so that applications that are used by many users tend to use a database management system solutions that are client / server. Nevertheless, the display face Access (forms, reports, queries, and Visual Basic code) it has to be used to handle the actual data base is processed by other database management systems, like Microsoft Jet Database Engine (which by default used by Microsoft Access ), Microsoft SQL Server, Oracle Database, and several other products that support ODBC.

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. Whether it's function in Ms Excel 2007
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")