Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Remedial INF Sem 1

Total questions: 109

Worksheet time: 1hrs 2mins

Name
Class
Date
1.

What is the term for a spreadsheet application?

a)

Word processor

b)

Spreadsheet

c)

Presentation

d)

Image processor

2.

What is the name of the spreadsheet application created by Kingsoft?

a)

WPS Spreadsheet

b)

WPS Slide

c)

WPS Presentation

d)

WPS Writer

3.

What icon does Anshor need to run the Microsoft spreadsheet application?

a)

C

b)

D

4.

What is the term for the work area in Microsoft Word and Excel?

a)

Slide

b)

Page

c)

Background

d)

Sheet

5.

What is the file extension for documents created by Microsoft Excel 2007?

a)

Pptx

b)

Docx

c)

Xlsx

d)

Ai

6.

What are the correct steps to save a document in Excel 2007?

a)

1-2-4-3-5

b)

1-2-5-4-3

c)

3-5-2-4-1

d)

3-5-4-2-1

7.

What is the function of the command icon in Microsoft Excel?

a)

Print file

b)

Save new file

c)

Open saved file

d)

Save file to a new location

8.

What is the label A in the image referred to?

a)

Tab bar

b)

Menu bar

c)

Title bar

d)

Toolbar

9.

What is the function of the label D in the image?

a)

Format cell

b)

Page setup

c)

Insert formula

d)

Merge and center

10.

What is the label F in the image?

a)

Status bar

b)

Formula bar

c)

Toolbar

d)

Worksheet

11.

What will be displayed when clicking on the appropriate icon?

a)

C

b)

D

12.

What is the term for the horizontal cell column named with letters?

a)

Column

b)

Row

c)

Range

d)

Sheet

13.

What part of the screen shows the name of the active cell?

a)

Address bar

b)

Formula bar

c)

Cell

d)

Control bar

14.

What is the term for a group of adjacent selected cells?

a)

Range

b)

Data

c)

Rank

d)

Column

15.

How is the Merge & Center command executed?

a)

C

b)

D

16.

What symbol starts a function or formula in Microsoft Excel?

a)

#

b)

>

c)

<>

d)

=

17.

What type of reference address changes according to its position when copied to another cell?

4 lines
18.

What symbol is used to start a function or formula in Microsoft Excel?

a)

C. >

b)

D. =

19.

What type of reference address changes according to its position when copied to another cell?

a)

Absolute

b)

C. Relative

c)

Semi Absolute

d)

D. Semi

20.

Which function is used to calculate the sum of numeric data?

a)

Average

b)

C. Max

c)

Min

d)

D. Sum

21.

Which function is used to determine the rank of a value in a set of data?

a)

Count

b)

C. Large

c)

Small

d)

D. Rank

22.

Which function is used to find the largest value in a set of numeric data?

a)

Sum

b)

C. Min

c)

Max

d)

D. Average

23.

What is the correct way to write the MAX function to find the maximum value from L2 to L7?

a)

=MAX(L2;L7)

b)

C. =MAX(L2:L7)

c)

=MAX{L2-L7}

d)

D. =MAX(L2,L7)

24.

Which function is used to calculate the average of numeric data?

a)

Sum

b)

C. Max

c)

Min

d)

D. Average

25.

What is the result of the mathematical expression 45 × 70?

a)

45 ++ 70

b)

C. =45 × 70

c)

= 45 * 70

d)

D. = 90 * 35

26.

What type of data is represented by 89 + 78?

a)

Alphanumeric

b)

C. Numeric

c)

Formula

d)

D. Number

27.

Which of the following is a logical function?

a)

SUM

b)

C. IF

c)

ROUND

d)

D. COUNT

28.

How is the mathematical symbol ≠ written in Excel?

a)

≠

b)

C. >>

c)

<>

d)

D. |=

29.

What is the correct formula to write in cell D24?

a)

=average(D24)

b)

=Average(C5:C9)

c)

=average(D18:D22)

d)

=average(D18-D22)

30.

What is the range of data used in the function in cell E25?

a)

C12 s.d F22

b)

C. E5 s.d E9

c)

C5 s.d F9

d)

D. E18 s.d E22

31.

What formula is used in cell F26?

a)

=max(F18-F22)

b)

C. =min(F18-F22)

c)

=min(F18:F22)

d)

D. =max(F18:F22)

32.

What is the correct function in cell F28?

a)

Min

b)

C. Max

c)

Large

d)

D. Small

33.

Which formula is incorrect for cell G18?

a)

=SUM(G18)

b)

=89+87+85+92

c)

=SUM(C18:F18)

d)

=SUM(C18;D18;E18;F18)

34.

What is the correct formula for cell I21?

a)

=rank(H7;C7:F7;0)

b)

=rank(H7;F5:F9;0)

c)

=rank(H21;$G$18:$H$19;0)

d)

=rank(H21;$H$18:$H$19;0)

35.

Which logical function displays a message after comparing conditions, such as subject scores with KKM?

a)

Log

b)

C. If

c)

Count

d)

D. Sum

36.

What is the correct formula to display the completion status based on cell E2, where the score is considered complete if greater than or equal to KKM?

a)

if(d2>=c2,"tuntas","tidak tuntas")

b)

=if(d2;$c$2:d$2;0)

c)

=if(d2>=c2,tuntas,tidak tuntas)

d)

=if(d2>=c2,"tuntas","tidak tuntas")

37.

What is the correct formula for cell D9 if the student with the lowest average score is 76?

a)

=if(D8>78,"Naik Kelas","Mengulang")

b)

=if(D8>=76,"Naik Kelas","Mengulang")

c)

=if(78>D8,"Naik Kelas","Mengulang")

d)

=if(D9>76,"Naik Kelas","Mengulang")

38.

Spreadsheet applications are usually used for ...

a)

Data processing in the form of numbers

b)

Creating letters or writing documents

c)

Editing images or photos

d)

Creating presentation slides

39.

The spreadsheet application created by Google and can be accessed via the internet is

a)

Google Document

b)

Google Excel

c)

Google Sheet

d)

Google Slide

40.

If Anshor wants to run the spreadsheet application created by Microsoft, he needs to select the icon ...

a)

C.

b)

D.

41.

The working field in Microsoft Word is called a page, while in Microsoft Excel it is called ...

a)

Slide

b)

Sheet

c)

Background

d)

Page

42.

The document file type produced by Microsoft Excel 2007 is a file that has the extension ...

a)

Xlsx

b)

Docx

c)

Pptx

d)

jpg

43.

Observe the following steps to work:

a)

Click the Open button

b)

Select drive/storage location

c)

Click Office Button

d)

Type the file name

e)

Click the Open Icon

44.

The correct steps to open an Excel 2007 document file are ...

a)

1-2-4-3-5

b)

1-2-5-4-3

c)

3-5-2-4-1

d)

3-5-4-2-1

45.

In addition to using the icon, the save command can also be done by pressing the ... key on the keyboard

a)

Ctrl + I

b)

Shift + S

c)

Alt + F + S

d)

Alt + F + P

46.

When saving a file that has been saved before, the Save As command will ...

a)

Save the file to a flash drive

b)

Save the file without changing the name

c)

Save and immediately close the Excel application

d)

Save the file with a new name and/or storage location

47.

For questions 9 to 12, observe the image.

4 lines
48.

The image labeled A is ...

a)

Tab bar

b)

Menu bar

c)

Title bar

d)

Toolbar

49.

The image labeled B is ...

a)

Status bar

b)

Formula bar

c)

Toolbar

d)

Ribbon

50.

The function of the part labeled D is ...

a)

To enter formulas or text into the active cell

b)

To know the position of the active cell

c)

To format the contents of the cell

d)

To add a new sheet in the file

51.

The command group is indicated by the sign ...

a)

F

b)

E

c)

C

d)

A

52.

The notation of cell address AB34 means ...

a)

The cell is located at row AB and column 34

b)

The cell is the sum of cell AB and cell 34

c)

The cell is located at column AB and row 34

d)

The cell is the final result

53.

The correct range notation from the image beside is ...

a)

A15-D19

b)

15A-19D

c)

A15/D19

d)

A15:D19

54.

The notation of a function or formula in Microsoft Excel must start with the sign ...

a)

#

b)

>

c)

$

d)

=

55.

The absolute reference notation for cell A5 is ...

(a)  

56.

What is g?

a)

A15-D19

b)

15A-19D

c)

A15/D19

d)

A15:D19

57.

A function or formula in Microsoft Excel must start with which sign?

a)

>

b)

$

c)

=

58.

The absolute reference for cell A5 is?

a)

$A5

b)

$A$5

c)

A$5

d)

A5

59.

Which function is used to calculate the sum of numeric data?

a)

Average

b)

Max

c)

Sum

d)

Min

60.

Which function is used to find the largest value in a set of numeric data?

a)

Sum

b)

Min

c)

Max

d)

Average

61.

Which function is used to rank a value in a specific data set?

a)

Count

b)

Large

c)

Rank

d)

Small

62.

The correct MAX function to find the maximum value from L2 to L7 is?

a)

=MAX(L2;L7)

b)

=MAX{L2-L7}

c)

=MAX(L2:L7)

d)

=MAX(L2,L7)

63.

Which function is used to calculate the average of numeric data?

a)

Sum

b)

Max

c)

Min

d)

Average

64.

=89 + 78 is a type of data in Excel that is?

a)

Alphanumeric/text

b)

Numeric/number

c)

Formula/formula

d)

Number

65.

In Excel, the mathematical symbol ≠ is written as?

a)

≠

b)

>>

c)

<>

d)

|=

66.

The correct formula to display the status of completion in cell E2, where the score is considered complete if greater than or equal to KKM, is?

a)

if(d2>=c2,"tuntas","tidak tuntas")

b)

=if(d2;$c$2:d$2;0)

c)

=if(d2>=c2,tuntas,tidak tuntas)

d)

=if(d2>=c2,"tuntas","tidak tuntas")

67.

The correct formula in cell D9 that displays the status of passing class if the average score is at least 80 is?

a)

=if("naik kelas","mengulang")

b)

=if(d8>=80,"naik kelas","mengulang")

c)

=if(d9>78,"naik kelas","mengulang")

d)

=if(80>d8,"naik kelas","mengulang")

68.

Spreadsheet applications are usually used for ...

a)

Processing data in the form of numbers

b)

Creating letters or writing documents

c)

Creating slide presentations

d)

Editing images or photos

69.

The spreadsheet application created by Kingsoft is ...

a)

Openoffice Calc

b)

WPS Spreadsheet

c)

Google Sheet

d)

Visicalc

70.

If Anshor wants to run the spreadsheet application created by Microsoft, he needs to select the icon ...

a)

C.

b)

D.

71.

The working area in Microsoft Word is called a page, while in Microsoft Excel it is called ...

a)

Slide

b)

Sheet

c)

Background

d)

Page

72.

The file type generated by Microsoft Excel 2007 is a file with the extension ...

a)

Xlsx

b)

Docx

c)

Pptx

d)

jpg

73.

The correct steps to open an Excel 2007 document are ...

a)

1-2-4-3-5

b)

3-5-2-4-1

c)

1-2-5-4-3

d)

3-5-4-2-1

74.

The command icon in Microsoft Excel below is used to ...

a)

Print a file

b)

Create a new file

c)

Open a saved file

d)

Save a file to a new location

75.

The image labeled A is ...

a)

Tab bar

b)

Menu bar

c)

Title bar

d)

Toolbar

76.

The image labeled B is ...

a)

Status bar

b)

Formula bar

c)

Toolbar

d)

Ribbon

77.

The image labeled F is ...

a)

Status bar

b)

Formula bar

c)

Toolbar

d)

Worksheet

78.

The vertical column of cells is called ...

a)

Column

b)

Row

c)

Sheet

d)

Range

79.

A cell located at row 23 and column AB is written as ...

a)

23AB

b)

2A3B

c)

AB23

d)

BA23

80.

A collection of several cell addresses is called ...

a)

Range

b)

Data

c)

Rank

d)

Column

81.

The type of reference address that changes according to its position when copy-pasted to another cell is called ...

a)

Absolute

b)

Relative

c)

Semi Absolute

d)

Semi

82.

A function or formula in Microsoft Excel begins with the sign ...

a)

#

b)

>

c)

<>

d)

=

83.

The expression in Excel formula for a mathematical equation 45 × 702 ÷ 5 = ...

a)

(45x702)/5 =

b)

=(45*70^2)/5

c)

=(45x702)/5

d)

(45*70^2)/5=

84.

The function used to calculate the sum of numeric data is ...

a)

Average

b)

Max

c)

Min

d)

Sum

85.

The function used to rank a value in a certain data set is ...

a)

Count

b)

Large

c)

Small

d)

Rank

86.

The function used to calculate the largest value in a set of data is ...

4 lines
87.

The function used to rank a value in a certain data set is...

a)

Count

b)

Large

c)

Small

d)

Rank

88.

The function used to calculate the largest value in a set of numeric data is...

a)

Average

b)

Min

c)

Sum

d)

Max

89.

The correct syntax for the MAX function to find the maximum value from L2 to L7 is...

a)

=MAX(L2;L7)

b)

=MAX{L2-L7}

c)

=MAX(L2:L7)

d)

=MAX(L2,L7)

90.

The function used to calculate the smallest numeric data is...

a)

Sum

b)

Max

c)

Average

d)

Min

91.

The function used to calculate the average of numeric data is...

a)

Sum

b)

Max

c)

Min

d)

Average

92.

The mathematical symbol for greater than or equal to is written in Excel as...

a)

≠

b)

<>

c)

>=

d)

|=

93.

The correct function for cell C10 is...

a)

AVERAGE

b)

RANK

c)

SUM

d)

MAX

94.

The correct formula for cell D11 is...

a)

=Average(C5:C9)

b)

=average(D5:D9)

c)

=average(D11)

d)

=average(D10)

95.

The data range used in the function in cell E12 is...

a)

C12 s.d F12

b)

E5 s.d E9

c)

C5 s.d F9

d)

E12

96.

The formula used in cell F13 is...

a)

=max(F5-F9)

b)

=min(F5-F9)

c)

=max(F5:F9)

d)

=min(F5-F9)

97.

The function used in cell C14 is...

a)

MAX

b)

MIN

c)

SMALL

d)

LARGE

98.

The correct formula for cell F15 is...

a)

=min(F5-F9;4)

b)

=small(F5-F9)

c)

=large(F5-F9;4)

d)

=small(F5-F9;4)

99.

Which of the following is not a correct formula for cell G5?

a)

=96+90+100+92

b)

=SUM(C5;D5;E5;F5)

c)

=SUM(G5)

d)

=SUM(C5:F5)

100.

The correct formula for cell H6 is...

a)

=average(C6-F6)

b)

average(C6:F6)

c)

=average(C6:F6)

d)

sum(C6:F6)/4

101.

The data range used in the formula I5 is...

a)

C5 sd F5

b)

F5 sd F9

c)

H5 s.d H9

d)

C5 s.d F9

102.

The correct formula for cell I7 is...

a)

=rank(H7;C7:F7;0)

b)

=rank(H7;F5:F9;0)

c)

=rank(H7;$H$5:$H$9;0)

d)

=rank(H7;G5:G9;0)

103.

The correct formula to display the completion status like in cell E2, where the score is considered complete if greater than or equal to KKM, is...

a)

IF(D2>=C2,"tuntas","tidak tuntas")

b)

=IF(D2>=C2,"tuntas","tidak tuntas")

c)

=IF(D2>=C2,tuntas,tidak tuntas)

d)

=if(D2;$C$2:d$2;0)

104.

The correct formula in cell D9 that displays the status of passing the class if the average score is at least 80 is...

a)

=if("naik kelas","mengulang")

b)

=if(d8>=80,"naik kelas","mengulang")

c)

=if(d9>78,"naik kelas","mengulang")

d)

=if(80>d8,"naik kelas","mengulang")

105.

A cell located at row 23 and column AB is written as...

a)

23AB

b)

2A3B

c)

AB23

d)

BA23

106.

The image labeled B is...

a)

Status bar

b)

Formula bar

c)

Toolbar

d)

Ribbon

107.

The function used to calculate the smallest numeric data is...

a)

Sum

b)

Max

c)

Min

d)

Average

108.

A range is marked with the symbol...

a)

:

b)

;

c)

#

d)

@

109.

The ready-to-use formula in Microsoft Excel for automatic addition is called...

a)

Formula

b)

Logic

c)

Mathematics

d)

AutoSum

Similar Resources on Wayground

thái bảo

113 questions

thái bảo

quiz

Worksheet

•

1st - 12th Grade

Comp Tech Final Exam Study Guide

105 questions

Comp Tech Final Exam Study Guide

quiz

Worksheet

•

8th Grade

Một số câu hỏi ôn tập môn Tin học 1

108 questions

Một số câu hỏi ôn tập môn Tin học 1

quiz

Worksheet

•

8th Grade

Β Γυμνασίου Δίκτυα

107 questions

Β Γυμνασίου Δίκτυα

quiz

Worksheet

•

8th Grade