1.
How many sheets in the file?
Correct Answer
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.
2.
What is the result of this formula:=C2+B5+A2
Correct Answer
10
Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.
3.
What is the font size used ?
Correct Answer
A. 11
Explanation
look carefully at the image attached before answering .
4.
How many rows are filled with data?
Correct Answer
A. 4
Explanation
There are four rows filled with data.
5.
Which sheet is the active sheet?
Correct Answer
A. Test 4
Explanation
The active sheet is "Test 4" because it is the first sheet listed in the options provided.
6.
Cell C3 contain a formula that add B3, B4 and B5, what value will be there if B4 changed from 2 to 12?
Correct Answer
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.
7.
What is the function used in cell C4 ?
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.
8.
What is the name of this spreadsheet file?
Correct Answer
A. Test4
Explanation
The name of the spreadsheet file is "Test4".
9.
What is the result of this formula:=(B2+A4)*C4
Correct Answer
60
Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.
10.
What is the result of this formula:=(A2*B3)-C4
Correct Answer
0
Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.
11.
What is the result of this formula:=B5/A3*B3
Correct Answer
10
Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.
12.
Excel files are called Worksheet.
Correct Answer
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.
13.
The number of worksheet allowed in Excel file is 3 sheets only
Correct Answer
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.
14.
Sheet’s name must be unique and at least 5 character long.
Correct Answer
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.
15.
A pre-defined formula in Excel is called a function
Correct Answer
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.
16.
AND function will return TRUE if all condition are met, otherwise it returns FALSE
Correct Answer
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.
17.
A formula must begin with a plus sign.
Correct Answer
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.
18.
What is the result of the following function:=PROPER(C4)
Correct Answer
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".
19.
What is the result of the following function:=EXACT(B2,D5)
Correct Answer
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.
20.
What is the result of the following function:=MAX(A1:A5)
Correct Answer
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.
21.
What is the result of the following function:=LOWER(C3)
Correct Answer
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.
22.
What is the result of the following function:=MIN(A1:A5)
Correct Answer
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.
23.
What is the result of the following function:=EXACT(C2,D4)
Correct Answer
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.
24.
What is the result of the following function:=UPPER(C4)
Correct Answer
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.
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
240
Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.
27.
What is the result of the following function:=PROPER(C3)
Correct Answer
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".
28.
How many cells are used for the title ? (Enter a number only )
Correct Answer
5
Explanation
Use the data provided in the table , Enter the correct answer, adding a space will result in your answer being wrong.