This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Anita is working on an Excel spreadsheet with the fraction 2/3 entered in Cell B6 and 1 4/5 entered ... (Read 44 times)

ss2343

  • Hero Member
  • *****
  • Posts: 548
on: Jun 24, 2018
Anita is working on an Excel spreadsheet with the fraction 2/3 entered in Cell B6 and 1 4/5 entered in Cell B7. Using the pointing method, how would Anita enter the difference of 1 4/5 and 2/3 in Cell B8?

Question 2

Excel sometimes mistakes numbers entered as fractions as dates. How could this problem be prevented?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

juliaf

  • Sr. Member
  • ****
  • Posts: 344
Reply #1 on: Jun 24, 2018
Answer to Question 1

Anita would do the following:
key =, then point to B7 and click with her mouse, key -, then point to B6 and click with her mouse, then press enter.

Answer to Question 2

Use the format cells dialog box to format the cells where fractions will be entered as fractions before entering any numbers.


ss2343

  • Member
  • Posts: 548
Reply 2 on: Jun 24, 2018
Wow, this really help

deja

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

animal cell animal cell
Cell Cell
the four stages of the cell cycle the four stages of the cell cycle
animal cell animal cell
Working and Living and Playing in the City Dump of Phnom Penh, Cambodia Working and Living and Playing in the City Dump of Phnom Penh, Cambodia
The nucleus of animal cell: a rat liver nucleus The nucleus of animal cell: a rat liver nucleus
Video: Structure of a Ribosome

For a complete list of videos, visit our video library