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”)
