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 117 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
Wow, this really help

bassamabas

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

« previous next »
 

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

Cell Cake Cell Cake
Cancer cell. Cancer cell.
Steps in the humoral and cell-mediated immune response Steps in the humoral and cell-mediated immune response
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
Phases of the Cell Cycle Phases of the Cell Cycle
CRISPR T-Cell Editing CRISPR T-Cell Editing
Video: Mitosis step-by-step

For a complete list of videos, visit our video library