Rounding errors can occur
Home | Discussion ForumRounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
Answer : A
Free Online Test
View More Related Question
1) Protection and the Protect Sheet options can be selected from ?
2) Which of the following action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
View Answer
3) When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
View Answer
4) While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
View Answer
5) Which of these will not select all the cells in a document ?
Using the Edit – Select All menu
Pressing Ctrl + A on the keyboard
Clicking three times with the right mouse button in the spreadsheet
None of these
View Answer