Soal M.excel

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