Class 9 Viva Questions 9B mideterm

Karma is creating a spreadsheet to track his expenses. He wants to ensure that the numbers representing money are easily distinguishable. Which formatting option would be most appropriate for his expense amounts?

• Changing the text alignment to center

• Applying a bold font style

• Changing the cell background color to green

• Inserting a new column

Sangay is listing the names of students in a class. Which data type is most suitable for entering student names in Excel?

• Number

• Date

• Text

• Boolean

Pema wants to combine several cells to create a single, larger title for her spreadsheet. Which Excel feature should she use?

• Splitting cells

• Applying borders

• Merging cells

• Inserting rows

A teacher wants to calculate the average score of students in a particular subject. Which function would be most efficient to use in Excel?

• `SUM()`

• `COUNT()`

• `AVERAGE()`

• `MAX()`

Dechen has a list of numbers in cells A1 to A10. She wants to add all these numbers together. Which formula should she use?

• `=ADD(A1:A10)`

• `=TOTAL(A1:A10)`

• `=SUM(A1:A10)`

• `=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10`

Jigme needs to create a spreadsheet that can be easily shared and collaborated on with his classmates online. Which platform would be the best choice for this purpose?

• Microsoft Word

• Adobe Photoshop

• Google Sheets

• Notepad

Suppose you have a formula `=A1+B1` in cell C1. If you drag this formula down to C2, it automatically changes to `=A2+B2`. This is an example of what type of cell referencing?

• Absolute referencing

• Relative referencing

• Mixed referencing

• Fixed referencing

Which of the following best defines a computer network?

• A single computer connected to the internet.

• A collection of independent computers and devices connected together to share resources.

• A program used for sending emails.

• A device that displays web pages.

When your internet connection is not working, the first step you should usually take to troubleshoot the problem is:

• Reinstalling your operating system.

• Checking the physical cable connection to your computer and router.

• Buying a new computer.

• Deleting all your files.

A networking device that connects multiple computers and other network devices, and sends data packets to their intended destinations based on IP addresses, is called a:

• Modem

• Switch

• Router

• Hub