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 90 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
YES! Correct, THANKS for helping me on my review

upturnedfurball

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

« previous next »
 

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Schematic of typical animal cell depicting the various organelles and structures. Schematic of typical animal cell depicting the various organelles and structures.
Diagram of a cell nucleus Diagram of a cell nucleus
Animal Cell Diagram To Label Animal Cell Diagram To Label
Activity of a Hippocampal Place Cell Activity of a Hippocampal Place Cell
(b) Scanning electron microscopy showing a phagocytic cell in the process of phagocytizing bacteria. ... (b) Scanning electron microscopy showing a phagocytic cell in the process of phagocytizing bacteria. ...
Becker's World of the Cell Becker's World of the Cell
Video: Darwin's Observation (Fossils, Galapagos Islands & Africa ) and Natural Selection (Adaptive Traits)

For a complete list of videos, visit our video library