Lesson : ICT
Class/Program : XI IPA 3
Semester : 2 (Even)


Please, answer the following question, short and right! Please, use Full English Version!

QUESTION :

1. Please, specify all the members of Microsoft Office 2007 and each function!

2. Please, specify all the members of Pull Down Menu in Ms Excel 2007 and each function!

3. Please, specify all the number of columns and rows in and each function :

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, tyhen "SUCCESS".

Please, write a formula that should be used !


Notice !

Strictly forbidden to operate a Laptop, Notebook, Netbook, and similar !!!

*************



ANSWERS:


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 editing experience in the problem of "font", Should you first specify the default font to be Used. (Menu Home + Fonts)

2. Making Numbering

Typically, the creation of a document refers to perform 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 earnest allow us to make some earnest That Important points outlined in the document. Making the document in outline form, at least up to level 3. There are times Pls 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 from use the facilities section break. EACH section is numbered like the pages That You Want (insert menu + + Format Page Number Page Number Page numbering + + start at ... then select the page number Nowhere the bottom or top of page) special cover page, usually there are no page numbers, therefore headers / footers 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 cans Appear automatically. If there is any change of position on the page table / images / chart, then right-clicked a list of live update table select field.

7. Making a Table of Contents

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

8. Editing the Document Map

In order for editing to be done be done Quickly cans, cans it 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 That program comes with Microsoft Office suite. But what is really Used for? May it surprise you to know That many of the tasks of Everyday Life, both personal and business, can be simplified by using Excel. Articles cans be created, the database cans be saved, and simple math courses cans be completed only with A Few keystrokes.

1. Calculator

Microsoft Excel is the only program in the 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 figures in C1 will from 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 ins Microsoft Access. Numerical data cans 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 cans 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 earnest 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 cans 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:


e. Microsoft Access 2007

2. Home:
CIT-TASK-SMA-XI-S2
* Clipboard
* Fonts
* Alignment
* Numbers
* 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 the formatting cells or cells do.
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 the minimum 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 the vertical.
h. HLOOKUP: To read the table with the horizontal.
i. Mid: To find the middle number in the range.
j. Round 0, Round 1, Round 2: To round the numbers with decimal numbers WHO wanted.

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






A. BENEFITS OF MICROSOFT POWER POINT
1) Microsoft Power Point is an application program that serves to create presentation slides in bnetuk
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
B. STATE AND FUNCTIONS OF THE MENU
• FILE
1.New
Function → to make a new presentation files

2.Open
Function → to open the document that have been saved
3.Close
Function → to close the file
4.Save
Function → to store files on floppy disks
5.Save as
→ function to save files
6.Save as Web Page
Function → to find the file
7.Web Page Preview
Functions →
8.Page Setup
Function → to change the page size on a slide, print direction (orientation)
9.Print Preview
Function → to display the printout on the screen
10.Print
→ function to print the slides to the printer

• EDIT
1.Undo New Slide
Functions → To cancel a previous command
2.Repeat Send To Mail
Function → to repeat postal delivery
3.Recipient (as attachment)
→ function as a receiver attachment / extra
4.Delete Slide
Function → to mengahpus slide
5.Find
Function → to find a text
6.Replace
Function → to find and replace text

• VIEW
1.Normal
Functions → change the slides in normal circumstances
2.Slide Sorter
Function → to change the slides in a slide sorter
3.Slide Event Show
Function → to display a full screen slide show
4.Master
Functions →
5.Black and White
Functions → presentation that prints black and white layout
6.Toolbars
Function → to help in the form of image
7.Header and Footer
Function → to remove page numbers
8.Zoom
Function → to change the screen size.

• INSERT
1.New Slide
Function → to add a new slide
2.Duplicate Slide
Functions → duplicate an object
3.Slide Number
Function → to insert the serial number
4.Date and Time
Function → to insert data and time on the slide
5. Symbol
Function → to display the symbol on the slide
6.Slides From Files
Functions → slides from file
From 7.Slides, Outline
Functions → slides from
8.Picture
Function → to display and select images
9.Text Box
Function → to make a box and writing
10.Movies and Sounds
Function → to remove the film and sound on the slide
11.Chart
Function → to make a graph
12.Table
→ function to create tables
13.Object
Function → to insert an object of the program
14.Hyperlink
Function → to link data from other programs

• FORMAT
1.Font
→ function as special printing effects
2.Bullets and Numbering
Function → to make a list and numbered bersimbol
3.Aligment
Function → to make paragraphs
4.Change Case
Function → to change the form letter
5.Replace Fonts
Functions →
6.Slide Layout
Functions →
7.Slide Color Scheme
Functions → determine the colors on a slide
8.Background
Function → to change the slide background
9.Apply Design
Function → to design a slide

• TOOL
1.Spelling
Function → to check spelling
2.Language
Function → to select the language
3.Autocorrect
Function → to check back

• Slides SHOW
Show 1.View
Function → to display the display
2.Custom Animation
Functions → provide animation effects
3.Animation Preview
Function → to display the animation on screen
4.Slide Transition
Function → to give certain effects when there is movement from one slide to another slide.

• WINDOW
1.New Window
Function → to open a new window
2.Next Page
Function → to another object

• HELP
1.Ms. Power Point Help
Function → to display the help of Power Point
2.What 's This?
Function → to display help on the designated object.

C. STATE AND FUNCTION TOOL
Toolbars Standard:

1.New: to create a new presentation files
2.Open: to open files
3.Save: to save the file
4.E-Mail: to send data via E-Mail
5.Search: to search for text / file
6.Print: to print the presentation file
7.Print Preview: to display the results to the screen
8.Spelling: to set the spelling of English text
9.Cut: to move data from one cell to another cell
10.Copy: to copy data
11.Paste: to display the data that has been copied
12.Format Painter: to return to its original format
13.Undo: to cancel previous orders
14.Redo: cancel the Undo command
15.Insert Chart: to insert / create a chart
16.Insert Table: to insert / create a table
17.Tables & Borders: to display the toolbars tables & Borders
18.Insert Hyperlink: to link the data with other programs
19.Expand All: displays all the text below
20.Show Formating: to display the form pemformatannya
21.Show/Hide Grid: show / hide grid lines
22.Color / Grayscale: change the color display
23.Zoom: to change the size of the slide show
24.Microsoft Power Point Help: to seek the help command

Formatting toolbars:
1.Font: to choose the form of letters
2.Font Size: to change the font size
3.Bold: to make text bold
4.Italic: to make the text italics
5.Underline: to make underlined text
6.Shadow: to give shadow text
7.Align Left: to create a flat text left
8.Center: to make the text in the middle
9.Align Right: to make the text flush right
10.Numbering: to display the numbers in the text
11.Bullets: to display the bullet marks on the text
12.Increase Font Size: to enlarge the font size
13.Decrease Font Size: to derease the font size
14.Decrease indent: to move the left indent to the left
15.Increase indent: to move the left indent to the right
16.Font Color: to change the text color
17.Slide design: to change the design of a slide
18.New Slide: to create a new slide