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 50 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
Gracias!

alvinum

  • Member
  • Posts: 317
Reply 3 on: Yesterday
Excellent

« previous next »
 

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?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

A micrograph of the cell coat or glycocalyx of an animal cell. A micrograph of the cell coat or glycocalyx of an animal cell.
Examples of cell types derived from ectoderm, mesoderm, and endoderm. Examples of cell types derived from ectoderm, mesoderm, and endoderm.
cell labeled cell labeled
animal cell biology animal cell biology
Adult neurogenesis. The top panel shows new cells in the dentate gyrus of the hippocampus—the cell ... Adult neurogenesis. The top panel shows new cells in the dentate gyrus of the hippocampus—the cell ...
A dendritic cell preparing to engulf spores of a fungus, Aspergillus fumigatus. A dendritic cell preparing to engulf spores of a fungus, Aspergillus fumigatus.
Video: Bipolar Disorder

For a complete list of videos, visit our video library