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 91 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
:D TYSM

okolip

  • Member
  • Posts: 362
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Comparison of normal-shaped erythro- cytes and the abnormal sickle shape noted in patients with sick Comparison of normal-shaped erythro- cytes and the abnormal sickle shape noted in patients with sick
Cell Structure Cell Structure
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
Locations of major metabolic pathways within a eukaryotic cell Locations of major metabolic pathways within a eukaryotic cell
Modern Cell Theory Modern Cell Theory
A single cell from an early-stage human embryo A single cell from an early-stage human embryo
Video: The Vestibular System

For a complete list of videos, visit our video library