End Of Term - Year 9
.
Questions and Answers
- 1.
How many sheets in the file?
- A.
5
- B.
3
- C.
4
- D.
1
Correct Answer
A. 5Explanation
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
Correct Answer
10Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.Rate this question:
- 3.
What is the font size used ?
- A.
11
- B.
24
- C.
12
- D.
8
Correct Answer
A. 11Explanation
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
Correct Answer
A. 4Explanation
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
Correct Answer
A. Test 4Explanation
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
Correct Answer
A. 27Explanation
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
Correct Answer
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
Correct Answer
A. Test4Explanation
The name of the spreadsheet file is "Test4".Rate this question:
-
- 9.
What is the result of this formula:=(B2+A4)*C4
Correct Answer
60Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.Rate this question:
- 10.
What is the result of this formula:=(A2*B3)-C4
Correct Answer
0Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.Rate this question:
- 11.
What is the result of this formula:=B5/A3*B3
Correct Answer
10Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.Rate this question:
- 12.
Excel files are called Worksheet.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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
Correct Answer
B. FalseExplanation
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
Correct Answer
B. FalseExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
A. TrueExplanation
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
Correct Answer
B. FalseExplanation
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)
Correct Answer
PrayExplanation
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)
Correct Answer
False, FALSE, falseExplanation
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)
Correct Answer
4Explanation
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)
Correct Answer
islamExplanation
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)
Correct Answer
2Explanation
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)
Correct Answer
TRUE, True, trueExplanation
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)
Correct Answer
PRAYExplanation
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.
What is the result of the following function:=UPPER(C2)
Correct Answer
WHY - 26.
What is the result of this formula:=A5 * B5 * C4
Correct Answer
240Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.Rate this question:
- 27.
What is the result of the following function:=PROPER(C3)
Correct Answer
IslamExplanation
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 )
Correct Answer
5Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.Rate this question:
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 25, 2016Quiz Created by
Aic
Back to top