MIDDLE TEST SEMESTER TWO 2010/2011

Rabu, 23 Maret 2011

MIDDLE TEST SEMESTER TWO 2010/2011

QUESTION:
1. Please specify and function all the members of Microsoft Office 2007
2. Please specify and function all the members of Pull Down Menu in Ms.Excel 2007
3. Please specify the number of coloums 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. Specify of Ms. Office 2007 is:
 Ms. Excel 2007 is a spreat sheet program for processing numbers.
 Ms. Word is a word sheet program for processing word document.
 Ms. Power Point 2007 use to presentating document or to make a document for presentating.
 Ms. Publisher 2007 use to make brochure,poster,and banner.
 Ms. Access Office 2007 use to processing database
 Ms. Office Outlook 2007 use to send and receive e-mail
2. Specify of Menu Pull Down is:
a. Home:
i. Clipboard:
 Paste:( put the copy of text which copy)
 Cut: (for cut the selected text)
 Copy: ( for copy selected text)
 Format painter
ii. Font:
 Font: for chnge the font
 Font colour: for change the colour font
 Fill colour:give colour to the selected text
 Bottom border
 Underline: to give underline to the selected text
 Italic:to make the font italic
 Bold:the font bold
 Increase font size:to increase the size of font
 Decrease font size: to decrease the size of font

iii. Aligenment :
 Top align
 Middle align
 Bottom align
 Orientation
 Align text left
 Center
 Align text right
 Decrease indent
 Increase indent
 Wrap text
 Merge and center
iv. Number:
 Number format
 Accounting number format
 Percent style
 Comma style
 Increase decimal
 Decrease decimal
v. Styles:
 Conditional formatting
 Format as table
 Cell styles
vi. Cells:
 Insert cell
 Delete cell
 Format cell
vii. Editing:
 Sum
 Fill
 Clear
 Sort and filter
 Find and select
3. Specify number of coloums and rows
a. Ms. Excel 2007:
 Coloums:A-XFD
 Rows:1048576
b. Ms. Excel 2003:
 Coloums:256 (A-IV)
 Rows:65536
4. Whether function in Ms. Excel 207
a. Format cells: Used for format cells
b. Sum: For count the total data
c. Count numbers: to count the data
d. Max : to determine the higher value or maximal value
e. Min : to determine the short value or minimal value
f. COUNTIF : to count the same data in order the criteria
g. VLOOKUP: used for read the table which arrange in vertical
h. HLOOKUP: used for read the table which arrange in horizontal
i. MID: for search text in cells from center
j. ROUND 0, ROUND 1, ROUND 2: To make no ntion in data
5. =IF(data range≤76,”FAIL”,”SUCCESS”) or
=IF(data range>76,”SUCCESS”)