3/25/24, 8:42 PM ICT

ICT
* Indicates required question

1. Email *

2. What is your name?

3. 1. Which of the following defines a spreadsheet? *

Mark only one oval.

A piece of information arranged in an orderly manner

A piece of information arranged in a tabular form using rows and column

The addition or subtraction of numbers in a table

None of the options

4. 2. Which of the following best defines a cell? *

Mark only one oval.

The name of a spreadsheet

A box grid in a spreadsheet named by its row and column

The name of a row

The name of column

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 1/17
3/25/24, 8:42 PM ICT

5. 3. Which of the following determines the name of a cell? *

Mark only one oval.

The location of a row

The location of a column

The location of the row and column the cell is located

The size of the spreadsheet

6. 4. In the image below, what is the name of the cell in which "distance(m)" is *
written?

Mark only one oval.

D3

C2

B2

E3

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 2/17
3/25/24, 8:42 PM ICT

7. 5. Which of the following gives the cell A5 color green? *

Mark only one oval.

Fill color

Bottom Border

Font color

Font Size

8. 6. Which of the following is incorrect about spreadsheets? *

Mark only one oval.

Spreadsheets have the Ability to perform calculations quickly

Spreadsheets can be used to arrange data in an orderly manner

Spreadsheets are used to display images

Spreadsheets are made up of rows and columns

9. 7. Which of the following helps in identifying cells? *

Mark only one oval.

Colors of cells

Font Size

Bottom Border

Rows and Columns

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 3/17
3/25/24, 8:42 PM ICT

10. 8. Which of the following formulas provides the answer for the cell D5? *

Mark only one oval.

SUM(E5+F5+G5)

=ADD(E5+F5+G5)

=SUM(E5+F5+G5)

ADD(E5+F5+G5)

11. 9. Which of the following formulas will be used to calculate cell F6? *

Mark only one oval.

ADD(12*4)

=SUM(12*4)

=B6*C6

=ADD(B6*C6)

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 4/17
3/25/24, 8:42 PM ICT

12. 10. Which of the following occurs when a row heading is clicked on? *

Mark only one oval.

The cell becomes highlighted

The row becomes highlighted

The column becomes highlighted

The entire spreadsheet is highlighted

13. 11. Which of the following is not a use of spreadsheets? *

Mark only one oval.

Number Calculations

Creating Graphs

League Tables

None of the options

14. 12. Which of the following can be used to order data? *

Mark only one oval.

Sort tool

Fill Color tool

Font Size tool

Font Color tool

15. 13. What does it mean to format a spreadsheet? *

Mark only one oval.

To delete the spreadsheet

To edit and make changes to the spreadsheet

To create the spreadsheet

To rename a spreadsheet

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 5/17
3/25/24, 8:42 PM ICT

16. 14. Which of the following menus contain the column Graph/Chart? *

Mark only one oval.

Home Menu

Page Layout Menu

Insert Menu

File Menu

17. 15. Which of the following formula is used to calculate the total number of *
matches played?

Mark only one oval.

=SUM(Won+Drawn+Lost)

=ADD(Won+Drawn+Lost)

ADD(Won+Drawn+Lost)

SUM(Won+Drawn+Lost)

18. 16.What is the function of the formula =SUM(E5+F5+G5)? *

Mark only one oval.

It adds the cells E5,F5 AND G5

It adds only E5 and G5

It creates a new cell

It sums up the total data in a spreadsheet

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 6/17
3/25/24, 8:42 PM ICT

19. Use the diagram below to answer questions 17-20 *

17. What is the name of the cell below the number "4" in the spreadsheet below?

Mark only one oval.

D1

C3

C2

B2

20. 18. What is the name of the cell next to the word "orange" in the spreadsheet *
below?

Mark only one oval.

A3

A5

B4

B3

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 7/17
3/25/24, 8:42 PM ICT

21. 19. Name the cell that has the word pear written in it. *

Mark only one oval.

F6

F5

E5

F4

22. 20. Name the cell that has the number "5" written in it. *

Mark only one oval.

C5

B5

D5

C4

23. 21. In which of the following can the spreadsheet formats "font color" and "font *
size" be found?

Mark only one oval.

Home menu

Insert menu

Page Layout menu

Formula menu

24. 22. Which of the following options highlights the entire row or column? *

Mark only one oval.

Clicking on the row or column

Clicking on the row or column heading

Clicking between the rows or columns

Clicking and dragging between the rows and column

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 8/17
3/25/24, 8:42 PM ICT

25. 23. Which of the following is done to adjust the height and width in *
spreadsheets?

Mark only one oval.

Clicking on the row or column

Clicking on the row or column heading

Clicking between the rows or columns

Clicking and dragging between the rows and column

26. 24. What is the name of the space where =SUM(B5+C5) is written? *

Mark only one oval.

A cell

A column

A row

The formula bar

27. 25. In making reference to a cell, which of the following is needed? *

Mark only one oval.

The row and column in which the cell is located

Only the row the cell is located

Only the column the cell is located

None of the options

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 9/17
3/25/24, 8:42 PM ICT

28. 26. List one formatting options that improves the appearance of a spreadsheet. *

29. 27. List one formatting options that improves the appearance of a spreadsheet. *

30. 28. List one formatting options that improves the appearance of a spreadsheet. *

31. 29. List one formatting options that improves the appearance of a spreadsheet. *

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 10/17
3/25/24, 8:42 PM ICT

32. 30. List one formatting options that improves the appearance of a spreadsheet. *

33. 31. List any arithmetic operation that can carried out in spreadsheets. *

34. 32. List any arithmetic operation that can carried out in spreadsheets. *

35. 33. List any arithmetic operation that can carried out in spreadsheets. *

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 11/17
3/25/24, 8:42 PM ICT

36. 34. List any arithmetic operation that can carried out in spreadsheets. *

37. 35. List any arithmetic operation that can carried out in spreadsheets. *

38. 36. Which of the following options combines two cells to make one cell as the *
cell with the text "Option A" in the image below?

Mark only one oval.

Wrap text

Merge and center

Bold

Italic

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 12/17
3/25/24, 8:42 PM ICT

39. 37. Which of the following is faster to use while making same changes to *
multiple cells?

Mark only one oval.

Editing each cell one after the other

Highlighting the cells and making the change

Highlighting the rows and making the change

Highlighting the columns and making the change

40. 38. Bold and Italic are examples of which of the following? *

Mark only one oval.

Font size

Font style

Cell color

Border color

41. 39. Write out any app that can be used to create and format spreadsheets. *

42. 40. Write out any app that can be used to create and format spreadsheets. *

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 13/17
3/25/24, 8:42 PM ICT

43. 41. Which of the following formatting options makes the size of the text bigger as *
seen in the image below?

Mark only one oval.

Font Style

Cell Color

Border

Font size

44. 42. Which of the following will allow you change the font style of the entire *
spreadsheet?

Mark only one oval.

Highlight all the columns and make the change in the font menu

Highlight all the rows and make the change in the font menu

Highlight all the cells and make the change in the font menu

None of the options

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 14/17
3/25/24, 8:42 PM ICT

45. 43. Which of the following statements is incorrect? *

Mark only one oval.

Excel is a spreadsheet application

A cell is made up of rows and borders

Spreadsheets can be used to sort out a large amount of data

Formulas can be used in spreadsheet calculations

46. 44. Which of the following is not a use of formulas in spreadsheets? *

Mark only one oval.

They make our work faster

They make our work more easier to access

They solve specific problems

They cannot be replicated in cells and columns

47. 45. List any alignment option. *

48. 46. List any alignment option. *

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 15/17
3/25/24, 8:42 PM ICT

49. 47. List any alignment option. *

50. 48. List any Number operation function. *

51. 49. List any Number operation function. *

52. 50. Which of the following options cannot be used to complete formulas in a set *
of cells next to each other?

Mark only one oval.

Copy

Paste

Fill Down

Border

This content is neither created nor endorsed by Google.

Forms

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 16/17
3/25/24, 8:42 PM ICT

https://docs.google.com/forms/d/1rb8nxKZtuBOmxU5WsMWGi4ulU7fnJ_a8JQbszWYX_eg/edit#settings 17/17