1. Microsoft Excel is an application program
a. Spreadsheet
b. Wordprosesor
c. Presentation
d. Animation
2. Function which is used to calculate the sum of the data points
a. Sum
b. Max
c. Min d. Average
3. Functions are used to compute the largest value of data points
a. Sum
b. Max
c. Min
d. Average4. Function which is used to calculate the value of the smallest number of data
a. Sum
b. Max
c. Min
d. Average
5. Function which is used to calculate the average number of data
a. Sum
b. Max
c. Min
d. Average
6. Function which is used to calculate the data in a certain range
a. Count
b. Large
c. Small
d. Rank
7. Lines are used to display information about the contents of the cell that is active (highlighted) in the worksheet:
a. Formula bar
b. Toolbar
c. Scroll bar
d. Menu bar
8. To end Excel can press the button:
a. Alt + F4
b. Ctrl + F4
c. Alt + F2
d. Ctrl + F2
9. To edit a cell, we can use the button:
a. F1
b. F2
c. F3
d. F4
10. Statistics are not included under this function is
a. If
b. Large
c. Small
d. Rank
11. Function which is used to take the left side of text data as much as a certain character
a. Left
b. Right
c. Mid
d. Value
12. Function is used to retrieve the right of text data as much as a certain character
a. Left
b. Right
c. Mid
d. Value
13. Functions that used to take several characters in the middle of text data
a. Left
b. Right
c. Mid
d. Value
14. Function is used to convert text data into numeric data
a. Left
b. Right
c. Mid
d. Value
15. Strings are not included under this function are:
a. Text
b. Lower
c. Upper
gd. If
16. The so-called logic functions below are
a. If
b. SUMIF
c. Logif
d. Countif
17. VLOOKUP and HLOOKUP function is used to read a:
a. Table
b. Data
c. Graph
d. Formula
18. Command to save the excel worksheet by pressing
a. Ctrl S
b. Ctrl N
c. Ctrl V
d. Ctrl A
19. To set the row height table using the command
a. format, wide, height
b. formatting, row, height
c. format, coloum, autoselection
d. formatting, row, autoselection
20. To set the table column using the command
a. format, column, width
b. formatting, row, Heigh
c. format, coloum, autoselection
d. formatting, row, autoselection
Home
muhammadiyah education awards 2013
smp tik
soal uas tik
TIK
Wardah Biotik. Biologi. SMP Kelas 7. Latihan Soal
Exercise 2 To Final Test for Grade 7