# End Of Term - Year 9

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Aic
A
Aic
Community Contributor
Quizzes Created: 5 | Total Attempts: 780
Questions: 28 | Attempts: 111  Settings  .

• 1.

### How many sheets in the file?

• A.

5

• B.

3

• C.

4

• D.

1

A. 5
Explanation
The correct answer is 5 because the question is asking for the number of sheets in the file. Out of the given options, 5 is the only number that represents the quantity of sheets in the file.

Rate this question:

• 2.

### What is the result of this formula:=C2+B5+A2

10
Explanation

Rate this question:

• 3.

### What is the font size used ?

• A.

11

• B.

24

• C.

12

• D.

8

A. 11
Explanation
look carefully at the image attached before answering .

Rate this question:

• 4.

### How many rows are filled with data?

• A.

4

• B.

3

• C.

7

• D.

1

A. 4
Explanation
There are four rows filled with data.

Rate this question:

• 5.

### Which sheet is the active sheet?

• A.

Test 4

• B.

Test4

• C.

Final

• D.

Contacts

A. Test 4
Explanation
The active sheet is "Test 4" because it is the first sheet listed in the options provided.

Rate this question:

• 6.

### Cell C3 contain a formula that add B3, B4 and B5, what value will be there if B4 changed from 2 to 12?

• A.

27

• B.

17

• C.

12

• D.

22

A. 27
Explanation
If B4 is changed from 2 to 12, the formula in cell C3 will add B3 (which is not specified) with the new value of B4 (12) and B5 (which is not specified). Therefore, the value in cell C3 will be 27.

Rate this question:

• 7.

### What is the function used in cell C4 ?

• A.

LOWER(A3)

• B.

LOWER(B3)

• C.

Rajab

• D.

=rajab

A. LOWER(A3)
Explanation
The function used in cell C4 is LOWER(A3). This function converts the text in cell A3 to lowercase letters.

Rate this question:

• 8.

### What is the name of this spreadsheet file?

• A.

Test4

• B.

Test 4

• C.

Excel

• D.

Contacts

A. Test4
Explanation
The name of the spreadsheet file is "Test4".

Rate this question:

• 9.

### What is the result of this formula:=(B2+A4)*C4

60
Explanation

Rate this question:

• 10.

### What is the result of this formula:=(A2*B3)-C4

0
Explanation

Rate this question:

• 11.

### What is the result of this formula:=B5/A3*B3

10
Explanation

Rate this question:

• 12.

### Excel files are called Worksheet.

• A.

True

• B.

False

B. False
Explanation
Excel files are not called Worksheet. Excel files are called workbooks, which can contain one or more worksheets. Each worksheet within an Excel workbook is a separate tab where data can be entered and manipulated. Therefore, the correct answer is False.

Rate this question:

• 13.

### The number of worksheet allowed in Excel file is 3 sheets only

• A.

True

• B.

False

B. False
Explanation
The given statement is false. In Excel, a workbook can have more than 3 worksheets. By default, a new workbook is created with 3 worksheets, but you can easily add more sheets by clicking on the "+" button next to the existing sheets or by using the "Insert" option in the menu. Therefore, the correct answer is False.

Rate this question:

• 14.

### Sheet’s name must be unique and at least 5 character long.

• A.

True

• B.

False

B. False
Explanation
The statement is false because the sheet's name does not have to be unique. Multiple sheets in a spreadsheet can have the same name. Additionally, the statement is false because the sheet's name does not have to be at least 5 characters long. It can be shorter than 5 characters if desired.

Rate this question:

• 15.

### A pre-defined formula in Excel is called a function

• A.

True

• B.

False

A. True
Explanation
A pre-defined formula in Excel is called a function because functions in Excel are built-in formulas that perform specific calculations or tasks. They are designed to simplify complex calculations and automate repetitive tasks. By using functions, users can easily perform calculations, manipulate data, and analyze information in Excel. Therefore, the statement "A pre-defined formula in Excel is called a function" is true.

Rate this question:

• 16.

### AND function will return TRUE if all condition are met, otherwise it returns FALSE

• A.

True

• B.

False

A. True
Explanation
The AND function is a logical function that returns TRUE only if all the conditions given to it are true. In this case, the explanation states that the AND function will return TRUE if all conditions are met, and FALSE otherwise. Since the answer is "True," it aligns with the explanation provided.

Rate this question:

• 17.

### A formula must begin with a plus sign.

• A.

True

• B.

False

B. False
Explanation
A formula does not necessarily have to begin with a plus sign. The plus sign is used to indicate that a cell should be added to the formula, but it is not a requirement for all formulas. Therefore, the given statement is false.

Rate this question:

• 18.

### What is the result of the following function:=PROPER(C4)

Pray
Explanation
The result of the function =PROPER(C4) is "Pray". This function capitalizes the first letter of each word in the text in cell C4. Therefore, when the function is applied to the word "pray", it capitalizes the letter "p" to "P", resulting in "Pray".

Rate this question:

• 19.

### What is the result of the following function:=EXACT(B2,D5)

False, FALSE, false
Explanation
The EXACT function in Excel compares two text strings and returns TRUE if they are exactly the same, and FALSE otherwise. In this case, the function is comparing the text string in cell B2 with the text string in cell D5. Since the text strings "False" and "FALSE" are not exactly the same (due to the difference in case), the result of the function is FALSE.

Rate this question:

• 20.

### What is the result of the following function:=MAX(A1:A5)

4
Explanation
The result of the function MAX(A1:A5) is 4. This function calculates the maximum value from the range A1 to A5, and in this case, the maximum value is 4.

Rate this question:

• 21.

### What is the result of the following function:=LOWER(C3)

islam
Explanation
The result of the function LOWER(C3) is "islam". The LOWER function is used to convert all uppercase letters in a text string to lowercase. In this case, the text string in cell C3 is "islam" and since it is already in lowercase, the function does not make any changes and returns the same string as the result.

Rate this question:

• 22.

### What is the result of the following function:=MIN(A1:A5)

2
Explanation
The result of the function MIN(A1:A5) is 2. This function calculates the minimum value in the range A1 to A5, and in this case, the minimum value is 2.

Rate this question:

• 23.

### What is the result of the following function:=EXACT(C2,D4)

TRUE, True, true
Explanation
The EXACT function in Excel is used to compare two text strings and determine if they are exactly the same. In this case, the function is comparing the text in cell C2 with the text in cell D4. Since the text in both cells is "TRUE" (with different capitalization), the function will return TRUE for all the comparisons. Therefore, the result of the function is TRUE, True, true.

Rate this question:

• 24.

### What is the result of the following function:=UPPER(C4)

PRAY
Explanation
The result of the function UPPER(C4) is "PRAY". The UPPER function is used to convert all the characters in a text string to uppercase. In this case, the text string "PRAY" is already in uppercase, so the function does not change anything and returns the same string.

Rate this question:

• 25.

WHY
• 26.

### What is the result of this formula:=A5 * B5 * C4

240
Explanation

Rate this question:

• 27.

### What is the result of the following function:=PROPER(C3)

Islam
Explanation
The result of the given function is "Islam". The PROPER function in Excel capitalizes the first letter of each word in a text string, and converts all other letters to lowercase. In this case, the text string "Islam" is already in the correct format, with the first letter capitalized and the rest in lowercase. Therefore, applying the PROPER function does not change the text string, and the result remains as "Islam".

Rate this question:

• 28.

### How many cells are used for the title ? (Enter a number only )

5
Explanation Back to top