[Clerk Accounts Dec, 2021]

1. Which of the following is not a term used in Spreadsheet?





Answer & Solution

Answer:

Browser

Solution:

A browser is not related to spreadsheets. Terms like Cell, Formula, and Character are commonly used in spreadsheets such as Microsoft Excel or Google Sheets. A cell is the basic unit, formulas are used for calculations, and characters are the text or symbols within the cells.

[Clerk Accounts Dec, 2021]

2. Which of the following is main function of CPU in computer system?





Answer & Solution

Answer:

Processing data

Solution:

The CPU (Central Processing Unit) is the brain of a computer system, responsible for executing instructions and processing data. While storing and transferring data are also important, these are managed by other components like memory and I/O devices.

[Clerk Accounts Dec, 2021]

3. Which of the following combination of keys is used to close the MS Excel?





Answer & Solution

Answer:

Alt  +F4

Solution:

In Microsoft Excel, the shortcut Alt+F4 is used to close the application. This key combination works universally across most Windows applications to close the current window.

[Clerk Accounts Dec, 2021]

4. The websites, used to find some information about topic, are called





Answer & Solution

Answer:

Search Engine

Solution:

A search engine is a website used to find information on a specific topic. Examples include Google, Bing, and Yahoo. They index webpages and provide relevant results based on the user's query.

[Clerk Accounts Dec, 2021]

5. Which of the following MS Excel functions is used to count the number of cells based on condition?





Answer & Solution

Answer:

Countif

Solution:

In MS Excel, the COUNTIF function is used to count the number of cells that meet a specific condition. The syntax is COUNTIF(range, criteria), where the range specifies the cells to evaluate, and the criteria define the condition to check.