Microsoft Office (Om Edutech Staff Performance Test)

2.

What symbol comes before the formula bar?

The AutoSum E
The equal sign
The function key
None Of These

Correct Answer

A. The equal sign

Explanation

The equal sign comes before the formula bar. In Excel, the equal sign is used to indicate that the following characters should be treated as a formula. When you enter a formula into a cell, you start by typing an equal sign followed by the formula itself. The equal sign is a key component in creating formulas and performing calculations in Excel.

Rate this question:

3.

Auto Correct Is Located On ?

Format Menu
Table Menu
Insert Menu
Tools Menu

Correct Answer

A. Tools Menu

Explanation

The auto correct feature is located in the Tools menu. This menu typically contains various options and tools to customize and enhance the functionality of the software. Auto correct is a feature that automatically corrects common spelling and typing errors as you type, making it easier and more efficient to create documents without having to manually correct mistakes.

Rate this question:

4.

To identify the range of cells from A1 to Z100, type which of the following?

A1: Z100
A1; Z100
A1 - Z100 D)

Correct Answer

A. A1: Z100

Explanation

To identify the range of cells from A1 to Z100, you need to use the format A1:Z100. This format specifies the starting cell (A1) and the ending cell (Z100) separated by a colon (:). This will select all the cells within the specified range.

Rate this question:

5.

Without using your mouse or the arrow keys, how can you quickly go to the first cell (A1) in the spreadsheet?

Use the keys: [Ctrl] and [Home]
You can't move to A1 without a mouse
Use the keys: [Alt] and [Tab]
Use the keys: [Ctrl] and [Esc]

Correct Answer

A. Use the keys: [Ctrl] and [Home]

Explanation

To quickly go to the first cell (A1) in the spreadsheet without using the mouse or arrow keys, you can use the keys [Ctrl] and [Home]. Pressing these keys together will immediately take you to the first cell of the spreadsheet.

Rate this question:

6.

Which of the following describe the term software.

A) System program only
B) Application program only
C) both I and II
D) None of the above

Correct Answer

A. C) both I and II

Explanation

The correct answer is c) both I and II. This means that the term software can refer to both system programs and application programs. System programs are responsible for managing and controlling the computer hardware, while application programs are designed to perform specific tasks or functions for the user. Therefore, the term software encompasses both types of programs.

Rate this question:

7.

Which of the following is a type of system software used on microcomputer?

MS-DOS
PC-DOS
Unix
All of the above

Correct Answer

A. All of the above

Explanation

All of the options listed (MS-DOS, PC-DOS, and Unix) are types of system software used on microcomputers. MS-DOS and PC-DOS are operating systems developed by Microsoft for IBM-compatible computers, while Unix is a widely used operating system for microcomputers. Therefore, the correct answer is "All of the above."

Rate this question:

8.

Modern computer operate on ?

Information
Harddisk
Data
Cd Rom

Correct Answer(s)

A. Information
A. Data

Explanation

Modern computers operate on information and data. Information refers to the processed and organized data that is meaningful and useful to the user. It is the result of data being analyzed, sorted, and presented in a meaningful way. On the other hand, data refers to raw facts, figures, and statistics that are inputted into the computer. The computer processes and manipulates this data to generate information that can be used for various purposes. Therefore, both information and data are essential for the operation of modern computers.

Rate this question:

9.

Computer memory consists of ……………… microchips.

RAM
ROM
PROM
All

Correct Answer

A. All

Explanation

Computer memory consists of various types of microchips, including RAM, ROM, and PROM. RAM (Random Access Memory) is a type of volatile memory that stores data temporarily while the computer is running. ROM (Read-Only Memory) is a type of non-volatile memory that stores permanent instructions and data that cannot be modified. PROM (Programmable Read-Only Memory) is a type of memory that can be programmed once and retains its data even when the power is turned off. Therefore, the correct answer is "All" because computer memory consists of all these types of microchips.

Rate this question:

10.

One megabyte is equivalent to

1000 Bytes
2 Raise To Power 20 bytes
2 Raise To Power 30 Bytes
1024 Bytes

Correct Answer

A. 2 Raise To Power 20 bytes

Explanation

One megabyte is equivalent to 2 raised to the power of 20 bytes. This is because in the binary system, each bit can have two possible values (0 or 1). Therefore, when we raise 2 to the power of 20, we get the total number of possible combinations of 0s and 1s in a 20-bit sequence, which is equal to one megabyte.

Rate this question:

11.

Full Form Of Virus?

Vital information resource under seize
Vital Information resources under software
Virtual Information resource under seek
None Of These

Correct Answer

A. Vital information resource under seize

Explanation

The correct answer is "Vital information resource under seize." This is the full form of the term "virus." It refers to a malicious program or code that can infect and damage computer systems, similar to how a biological virus can infect and harm living organisms. The term "vital information resource under seize" emphasizes the potential harm and disruption that a computer virus can cause to important information and resources.

Rate this question:

12.

The binary code for (21.25) is ?

10101.010
10100.100
10100.001
None Of These

Correct Answer

A. 10101.010

Explanation

The binary code for (21.25) is 10101.010.

Rate this question:

13.

Management is essential in every

Organized group effort
Business
Government
Industry

Correct Answer

A. Organized group effort

Explanation

Management is essential in every organized group effort, whether it is in a business, government, or industry. In any organized group, there needs to be a system in place to plan, coordinate, and control the activities of the group to achieve common goals. Management ensures that resources are allocated effectively, tasks are assigned, and progress is monitored. It helps in maintaining order, resolving conflicts, and driving the group towards success. Therefore, management is necessary in any organized group effort, regardless of whether it is in a business, government, or industry.

Rate this question:

14.

Once you are in Print Preview, how do you return to your spreadsheet?

Click File, Close
Click the Close button at the top of the screen
You must print in order to return to your spreadsheet.

Correct Answer

A. Click the Close button at the top of the screen

Explanation

To return to the spreadsheet from Print Preview, you can click the Close button at the top of the screen. This button will exit the Print Preview mode and take you back to the spreadsheet view.

Rate this question:

15.

How would you center text in a cell?

Use the Center text button on the Formatting toolbar
Click Format, Cells, Alignment, Middle
Click Format, Cells. Then click the Paragraph tab, and then OK.
We Cannot Do This

Correct Answer

A. Use the Center text button on the Formatting toolbar

Explanation

To center text in a cell, you can use the Center text button on the Formatting toolbar. This button will align the text in the center of the cell both horizontally and vertically.

Rate this question:

Microsoft Office (Om Edutech Staff Performance Test)

Which office application does not have a File, save as command for saving an existing document with a new name?

Quiz Preview

What symbol comes before the formula bar?

Auto Correct Is Located On ?

To identify the range of cells from A1 to Z100, type which of the following?

Without using your mouse or the arrow keys, how can you quickly go to the first cell (A1) in the spreadsheet?

Which of the following describe the term software.

Which of the following is a type of system software used on microcomputer?

Modern computer operate on ?

Computer memory consists of ……………… microchips.

One megabyte is equivalent to

Full Form Of Virus?

The binary code for (21.25) is ?

Management is essential in every

Once you are in Print Preview, how do you return to your spreadsheet?

How would you center text in a cell?