Middle Test Semester II 2010 /2011

please, answer the following question, short and right ! please use full english version

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

2. Please, specify and function all the members of the pull down menu in ms. excel 2007!

3. Please, specify the number of coloumns and rows in:

a. microsoft excel 2007!

b. microsoft excel 2003!

4. Whether is function in ms excel 2007?

a. format cells?
b. sum?
c. count number?
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. a. Microsoft Word 2007
Create word sheet program for processing words document.
b. Microsoft Powerpoint
2007
Create presentation document to make a document for presentating.

c. Microsoft Excel 2007
Create spread sheet program for processing number.
d. Microsoft Publisher 2007
Create and edit newsletter, brochure, flyer, and banner.
e. Microsoft Outlook 2007
Send and receive e-mail messages.
f. Microsoft Acces 2007
Create database and programs track and manage your information.

2. a. Home
Paste : To paste the contents of the clipboard
Copy : To copying data.
Cut : To cutting data.
Format painter : Copy formating from one place and apply it to another.
Font : Change the font face.
Font size : Change the font size.
Increase font size : Increase the font size.
Decrease font size : Decrease the font size.
Bold : Make the selected text bold.
Italic : Italicize the selected text.
Underline : Underline the selected text.
Bottom border : Apply borders to the currently selected cells.
Fill color : Color the background of selected cells.
Font color : Change the text color.
Top align : Align text to the top of the cells.
Middle align : Align text so that it is centered between the top and bottom of the cells.
Orientation : Rotate text to a diagonal angle or vertical oriantation.
align text left : Align text to the left.
Center : Center text.
Align text right : Align text to the right.
Orientation : Rotate text to diagonalangle or vertical orientation.
Decrease Indent : Decrease the margin between the border and the text in the cell.
Increase Indent : Increase the margin between the border and the text in the cell.
Wrap Text : Make all content visible within a cell by displaying it on multiple lines.
Merge and Center : To joins a selected cells into one larger cells and centers the contents in the new cell.

b. Insert
Insert PivotTable : To summarize data.
Table : Create a table to manage and analyze related data.
Picture : Insert picture from the a file.
Clip Art : Insert clip art to the document, including drawings, movies, songs or stock photography to illustrate a specific consep.
Shapes : Insert ready-made shapes, such as rectangle and circles, arrows, lines, flowchart symbols and callouts.
SmartArt : Insert a SmartArt graphic to visually communicate informations.
Collum : Insert a collum chart.
Line : Insert a line chart.
Pie : Insert a pie chart.
Bar : Insert a bar chart.
Area : Insert an area chart.
Other Chart : Insert a stock, surface, doughnut, bubble, or radar chart.
Hyperlink : Create a link a web page, a picture, an email address, or a program.
Text Box : Insert a text box that can be positioned anywhere on the page.
Header and Footer : Edit the header or footer of the document.
WordArt : Insert decorative in your document.
Signature Line : Insert a signature line that specifies the individual who must sign.
Object : Insert an embedded object.
Symbol : Insert characters that are not on your keyboard, such as copyright
symbols, trademarks symbol, pharagraph marks and unicode characters.

c. Page Layout
Themes : Change the overall design of the entire document, including colors, font,
and effects.
Themes Colors : Change the colors for the current themes.
Themes Font : Change Changes font for the current themes.
Themes Effect : Change the effect for the current themes.
Margins
d. Formulas
e. Data
f. Review
g. View

3. a. Ms. Excel 2007
Coloumns : 16384 (A-XED)
Rows : 1048576
b. Ms. Excel 2003
Coloumns : 256 (A-Iv)
Rows : 65536

4. a. Format Cells : To format the contents of selected cells.
b. SUM : Adds all the numbers in a range of cells.
c. Count Numbers : To count many of data.
d. MAX : Returns the largest value in a set of values.
e. MIN : Returns the smallest number in a set of values.
f. Countif : Counts the number of cells within a range that meet the given criteria.
g. VLOOKUP : Searches for a value in the first column of a table array and returns a
value in the same row from another column in the table array.
h. HLOOKUP : Use to read the table horizontal.
i. MID : To search the text in cell from middle.
j. ROUND 0, ROUND 1, ROUND 2 : To make no fraction in data.

5. For example the cell is :
=IF(Data range<76,"FAIL",IF(X1>76,"SUCCESS",))