MS Excel interactive worksheet - Free Printable

Let's solve the problems step by step and explain each answer.

---

Q1: Choose the correct answer

#### 1. What is the intersection of a column and a row on a worksheet called?
- Options:
- a) Column
- b) Value
- c) Address
- d) Cell

Explanation:
In Excel, the intersection of a column (e.g., A, B, C) and a row (e.g., 1, 2, 3) is called a cell. For example, the cell at the intersection of column A and row 1 is labeled as `A1`.

Correct Answer:
d) Cell

---

#### 2. Which function does Excel tell how many total entries are there for one person/thing?
- Options:
- a) NUM
- b) COUNT
- c) SUM
- d) AVERAGE

Explanation:
The `COUNT` function in Excel is used to count the number of cells that contain numerical values. It helps determine how many entries are present in a given range.

Correct Answer:
b) COUNT

---

#### 3. Calculations and preparation of tables and graphs can be done using:
- Options:
- a) Excel
- b) PowerPoint
- c) Adobe Photoshop
- d) Notepad

Explanation:
Excel is specifically designed for calculations, data analysis, and creating tables and graphs. PowerPoint is for presentations, Adobe Photoshop is for image editing, and Notepad is a basic text editor.

Correct Answer:
a) Excel

---

#### 4. Functions in MS Excel must begin with ___
- Options:
- a) An () sign
- b) An Equal Sign
- c) A Plus Sign
- d) A > Sign

Explanation:
In Excel, all functions must start with an equal sign (`=`). This tells Excel that the cell contains a formula or function.

Correct Answer:
b) An Equal Sign

---

#### 5. Which function does Excel check whether a condition is true or not?
- Options:
- a) SUM
- b) COUNT
- c) IF
- d) AVERAGE

Explanation:
The `IF` function in Excel is used to perform logical tests. It checks whether a condition is true or false and returns different results based on the outcome.

Correct Answer:
c) IF

---

#### 6. In Excel, Columns are labeled as ___
- Options:
- a) A, B, C, etc.
- b) 1, 2, 3, etc.
- c) $A$1, $A$2, etc.
- d) A1, A2, etc.

Explanation:
In Excel, columns are labeled alphabetically (A, B, C, etc.), while rows are labeled numerically (1, 2, 3, etc.). The combination of a column letter and a row number forms a cell address (e.g., A1).

Correct Answer:
a) A, B, C, etc.

---

#### 7. The Greater Than Sign (>) is an example of ___ operator.
- Options:
- a) Arithmetic
- b) Logical
- c) Conditional
- d) Greater

Explanation:
The Greater Than Sign (`>`) is a logical operator because it is used to compare two values and determine whether one is greater than the other. Logical operators include `>`, `<`, `=`, `>=`, `<=`, and `<>`.

Correct Answer:
b) Logical

---

#### 8. The ___ feature of MS Excel quickly completes a series of data.
- Options:
- a) AutoFill
- b) Copy
- c) Paste
- d) Format Painter

Explanation:
The AutoFill feature in Excel allows users to quickly fill a series of data (e.g., numbers, dates, or patterns) by dragging the fill handle. This saves time and reduces manual entry.

Correct Answer:
a) AutoFill

---

Final Answers:

1. d) Cell
2. b) COUNT
3. a) Excel
4. b) An Equal Sign
5. c) IF
6. a) A, B, C, etc.
7. b) Logical
8. a) AutoFill

---

Boxed Final Answer:

\[
\boxed{
\text{1. d) Cell, 2. b) COUNT, 3. a) Excel, 4. b) An Equal Sign, 5. c) IF, 6. a) A, B, C, etc., 7. b) Logical, 8. a) AutoFill}
}
\]