MIDDLE TEST EVEN SEMESTER
Please, answer the following question, short and right ! Please , use Full English Version !
QUESTION
1. Please . specify all members of Microsoft office 2007 !
2. Please . specify all members of pull down menu in Ms Excel 2007
3. Please . specify the number of columns and row in :
* Microsoft excel 2007 !
* Microsoft excel 2003 !
4. Whether its function in Ms Excel 2007
* a.Format cells ?
* b.Sum ?
* c.Count number ?
* d.Max ?
* e.Min ?
* f.Count if ?
* 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 tahan 76, then “SUCCESS”. Please , write a formula that should be used !
ANSWER
1. Ms. Excel 2007, Ms. Word 2007, Ms. Power Point 2007, Ms. Publisher 2007, Ms. Outlook 2007, and Ms. Access 2007.
2. Home:
* Clipboard
* Font
* Alignment
* Number
* 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 cells or do formatting cells.
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 minimun 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 vertical.
h. Hlookup: To read the table with horizontal.
i. Mid: To find middle number in the range.
j. Round 0, Round 1, Round 2: To round the numbers with decimal number who wanted.
5. =IF(cell<76;"FAIL";"SUCCESS") By : ich in ich-error.blogspot.com
Lihat Daftar Isi !
