Formula Validation and Error Handling in Excel
Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10
Answer: =SUM( AI: A5)/(10-10)
Explanation
=SUM(A1:A5)/(10-10) is not calculated in excel because 10-10 is zero so something divided by zero is not defined in the excel function.
***
ND18-1-2023
****
RY17-012-23
This question appeared in
Past Papers (3 times)
IBA STS Past Papers, Syllabus, Jobs (1 times)
Office Assistant Past Papers, Syllabus, Jobs (1 times)
STS Past Papers (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- Calculate the gross profit/loss if sales Rs. 60000, cost of sales Rs. 50000, opening stock Rs. 10000; purchases Rs. 40000; wages Rs. 20000, and office rent Rs. 10000.
- Which of the following formulas is NOT correctly entered in Excel? A) =C1+15 B) =SUM(A1:A5) C) =A1*B1 D) C1+15
- Which symbol is used to execute formulas in MS Excel?
- In MS Excel, You can copy data or formulas _____?
- which of these keys are used in ms excel to copy formulas from the above cell?
- Which area in an excel window allows entering values and formulas?
- Rose Company reported net income of $24,000, net sales of $400,000, and average assets of $600,000. Calculate the profit margin ratio.
- A retailer bought a product from the producer for Rs. 300 and paid a sales tax of 15% and sold the product to customers for Rs. 410. Calculate the profit
- In Excel, if you want to calculate the sum of cells ranging from C1 to C12, then which of the following formula you will use?
- Which short cut key is used to calculate the range of cell in MS excel
