Please answer the following questions, short and right ! please use Full English Version !
Question !
1. Please, specipy all the member of microsoft office 2007 !
2. Please, specipy all the member of pull down menu in ms Exel 2007 !
3. Please, specipy the member of coloumn and rows in :
a. Microsoft Exel 2007
b. Microsoft Exel 2003
4. whether is function in Ms Exel 2007 ?
a. format cell ?
b. Sum ?
c. Count Numbers ?
d. Max ?
e. Min ?
f. COUNTIF ?
g. VLOOKUP ?
h. HLOOKUP ?
i. MID ?
j. ROUND 0, ROUND 1, ROUND 3 ?
5. If the value is less than 76, then "FAIL" and its Value is ore than 76, then "SUCCES". please,
write formula that should be used !
Answer !
1. member of Microsoft office 2007 :
1. Microsoft Word 2007
2. Microsoft Exel 2007
3. Microsoft Power Point 2007
4. Microsoft Outlook 2007
5. Microsoft Publisher 2007
6. Microsoft Front Page 2007
7. Microsoft Acces 2007
8. Microsoft Info Patch 2007
9. Microsoft Groove 2007
1. Microsoft Word 2007
2. Microsoft Exel 2007
3. Microsoft Power Point 2007
4. Microsoft Outlook 2007
5. Microsoft Publisher 2007
6. Microsoft Front Page 2007
7. Microsoft Acces 2007
8. Microsoft Info Patch 2007
9. Microsoft Groove 2007
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. a. Coloumn : A-XFD
Rows : 1048576
b. Coloumn : 256 (A-IV)
Rows : 65536
b. Coloumn : 256 (A-IV)
Rows : 65536
4. a.Format Cells is a pulldown menu to do or change following cells
b.Sum is to calculate total of selected cells
c.Count Numbers is to sum the data in the list
d.Max is to display the Maximum mark/scored of selected data in the cells
e.Min is to display the Minimum mark/scored of selected data in the cells
f.COUNTIF is to calculate the more data in the list
g.VLOOKUP is to read the text/table vertically way of selected data in the cells
h.HLOOKUP is to read the text/table horizontally way of selected data in the cells
i.MID is to search text from middle and show the value of selected cells
j.ROUND 0, ROUND 1, ROUND 3 is to round the number with decimal numbers who wanted.
5. =IF (range<76,"FAIL",IF(range>76,"SUCCES"))
Eemple :
=IF(A9<76,"FAIL",IF(A9>76,"SUCCES")
0 komentar:
Posting Komentar