soal ulangantik kelas viii immersi part 2

8/3/2019 Soal UlanganTIK Kelas VIII Immersi Part 2

1/3

EXCEL TEST PART 2

1. Icon which used to open the Microsoft Excelis

a. c.

b. d.

2. Icon which used to insert the row in theworksheet is

a.

c.

b.

d.

3. The function of icon is

a. Delete the rowc. Delete the column

b. Insert the rowd. Insert the column

4. The display beside is used to adjust .a the height of rowb the width of columnc the height of columnd the width of row

5. The combination of icon and isused for

a.Move the document c. copy the document

b. Create the document d. savethe document

6. Procedure to change the name of sheetTIK became TI & K

after we get the dispbeside is choose.a Insertb Deletec Renamed Move or Copy

7. Consider the toolbar below!

Toolbar which used to reverse the last commathat which given is...

a.1 c. 2

b. 4 d. 3

8. The combination of keyboard Alt + I + WMicrosoft Excel is used for

a. Insert the sheets c. Cothe sheets

b. Delete the sheets d. Mothe sheets

9. Consider the display beside. Display in tbox is used for.a Delete the rowb Delete the columnc Insert the columnd Delete the row

10. The function of icon in stantoolbar is

a. Save the document c. Open The docum

b. Print the document d. Close the document

11. Procedure to resize the height of row isa. Format Row c. Format - Ce

b. Edit Row d. Edit - Colum

IMMERSION PROGRAM OF SMP N 1 MAJENANG 2010/2011

1 2 3 4


2/3

EXCEL TEST PART 2

12. In the Microsoft Excel, if we want to use theformula to calculate the mathematics operation,the formula use

a. + c. @c. Making the new documents

b. = d. $

13. The procedure to exit Microsoft Excel is

a.File - Closec. Edit - Close

b. File Exitd. Edit - Exit

14. The function of Format Cell Number -Category Date is

a.Making the display of timec. Making the display of text

b. Making the display of dated. Making the display of

fraction

15. Consider the display beside. In the cell C3is written =A3+B3. If theformula in cell C3 iscopied to cell C4, then we

get the formula in the cellC4 isa =A3+B3b =A4+B4c =A3+B4d =A4+B3

16. The application of formula in number 15 isknown as

a. Absolute Cell c. SemiAbsolute Cell

b. Relative Cell d. semi RelativeCell

17.Given the formula in the cell C1 is =$A$1+B1. Ifthe formula in cell C1 is copied to cell C2, theformula in the cell C2 is written

a. =A1+B2 c. =A1+B1

b. =A2+B2 d. =A2+B1

18. Consider the display beside. In the cell is written =A1*B1, tvalue of cell C3 isa12

b 36c13d -5

19. Consider the display beside. If the poinof mouse is drag to tright and drop, then

a The width column will decreaseb The width column will increase

c The height row will decreased The height row will increase

20. Consider the statement below!1. Click Edit2. Click Row3. Type the Number

4. Click OK5. Click height

The correct procedure to resize the heightrow is...

a. 1, 2 , 3 , 4 and 5 c. 2, 1, 3, 5 and 4

b. 1, 2, 5, 3, and 4 d. 3, 5, 2, 1, and 2

21. Consider the statement below!1. Click Number2. Click Cell3. Click Format4. Click Time5. Click Type and Location6. Click OK

The correct procedure to format time Microsoft Excel is...

a.1, 2 , 3 , 4 and 5 c. 2, 1, 3, 5 and 4

b. 1, 2, 5, 3, and d. 3, 5, 2, 1, and 2



3/3

EXCEL TEST PART 2

22.The formula to count 35 is

a. =3*5 c. =3x5

b.=SQRT(35) d. =3^5

23. The procedure to move data for anotherlocation is

a. Cut - Pastec. Delete - Paste

b. Copy - Paste d. Insert - Paste

24.The sub menu of file which used to save the file

in another name is.a. save

c. page setup

b. save asd. Insert

25. Consider the statement below!1. Click Save In2. Click Save As3. Click Save4. Click Type the name in the dialog File Name5. Click File

The correct procedure to save the file in anothername is...

a. 1, 2 , 3, 4 and 5 c. 5, 2, 1, 4, and 3

b.1, 2, 5, 3, and 4 d. 5, 1, 3, 4, and 2


soal ulangantik kelas viii immersi part 2

Documents