This topic contains a solution. Click here to go to the answer

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

ss2343

  • Hero Member
  • *****
  • Posts: 548
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
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
Gracias!


fatboyy09

  • Member
  • Posts: 358
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

For a complete list of videos, visit our video library