Kisi-kisi UKK TIK Kelas X - WordPress.com

KISI-KISI ULANGAN KENAIKAN KELAS X MAPEL T.I.K. TAHUN PELAJARAN 2009 / 2010

1. Toolbar-toolbar Microsoft Excel 2007

2. Operasi penjumlahan, perkalian, pengurangan, pembagian, pangkat ( +, *, -, /, ^ )

3. Fungsi Text ( LEFT, MID, RIGHT ) a) =LEFT(text,num_chars) b) =MID(text,start_num,num_chars) c) =RIGHT(text,num_chars)

4. Fungsi Statistik ( SUM, AVERAGE, MAX, MIN, COUNT ) a) =SUM(number1,number2, ...) b) =AVERAGE(number1,number2,...) c) =MAX(number1,number2,...) d) =MIN(number1,number2,...) e) =COUNT(value1,value2,...)

5. Fungsi IF a) =IF(logical_test,value_if_true,value_if_false)

6. Fungsi Matematika ( SIN, COS, TAN, ABS ) a) =SIN(number) b) =COS(number) c) =TAN(number) d) =ABS(number)

7. Alamat Relatif dan Alamat Absolut ($)

8. Fungsi VLOOKUP dan HLOOKUP a) =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) b) =HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

9. Grafik ( Chart Column, Pie, Line )