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 47 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
Great answer, keep it coming :)

bitingbit

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

« previous next »
 

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Types of cell adhesion molecules (CAMs) Types of cell adhesion molecules (CAMs)
Structure of a typical plant cell Structure of a typical plant cell
yeast cell signaling yeast cell signaling
biology 30 cell biology 30 cell
The role of antigen-presenting cell (APC). The role of antigen-presenting cell (APC).
Control of the cell cycle by cyclin-dependent kinases, and the checkpoints at which they operate Control of the cell cycle by cyclin-dependent kinases, and the checkpoints at which they operate
Video: Brain Anatomy Animation (Part 2 of 2)

For a complete list of videos, visit our video library