QUESTION!!
1. Please, specify all the members of microsoft office 2007!
2. Please, specify all the members of pull down menu in Ms. Excel 2007!
3. Please, specify the number of columns 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. 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") QUESTION!!
1. Please, specify all the members of microsoft office 2007!
2. Please, specify all the members of pull down menu in Ms. Excel 2007!
3. Please, specify the number of columns 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. 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")
Rabu, 13 April 2011
MIDDLE TEST SEMESTER II 2010/2011
Diposting oleh rony hari susanto di 17.22 0 komentar
Label: CIT-TASK-SMA-XI-MIDDLETEST2
Langganan:
Postingan (Atom)