Latest:
LinkedIn Microsoft Excel Certification 

Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can you accomplish this?

Editorial Staff
  • Click the Decrease Decimal button once.
  • Click the Decrease Decimal button twice.
  • Use the ROUND() function.
  • In the Cells group on the Home tab, click Format > Format Cells. Then click the Alignment tab and select Right Indent.

The correct answer is:

  • Click the Decrease Decimal button twice.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

You want to define a reusable process to reshape data (removing blank rows, merging columns, etc.). What toold can you use to accomplush this?

Editorial Staff 0

Which function is best used to look up and retrieve data from a specific row in a table?

Editorial Staff 0

You have a column of dog breeds that are in all capital letters. What function would you use to convert those dog breeds so that only the first letter of each word is capitalized?

Editorial Staff 0