Microsoft Excel Exercise Questions 2

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

212

Subject

Biology

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by KidCaribouPerson358

Microsoft Excel Exercise Questions 2 Respond to the following based on your reading. 1. If a cell displaying #DIV/0! contains the formula =C2/D9, what must be the value of cell D9? 2. If a cell displaying 6 contains the formula =D3*2, what is displayed when the value in cell D3 is changed to 10? 3. If you want to copy the formula in cell J3 to cells J4 and J5, which method is fastest? 4. How will the cell reference $G$14 be treated when you copy the formula to a cell in the next row? 5. Write a formula that uses a function to determine the total value of cells C4 through C17. 6. Which formula can you use to determine how many cells in a range have values? 7. List three examples of when you would sort data. 8. What's a relative reference? Questions Answers: 1. Cell D9 must contain a 0. 2. When you change the value in cell D3 to 10, the display in the cell changes to 20. 3. You can drag the Fill Handle to quickly copy a formula to adjacent cells. 4. The cell reference won't change because the dollar signs indicate an absolute cell reference. 5. =SUM(C4:C17) 6. You use the COUNT function to determine how many cells in a range have values.

7. You might sort data to arrange names in alphabetical order, to arrange times in chronological order, or to arrange test grades in order from highest to lowest. 8. A relative reference is a cell or a range reference that will change when a formula is moved or copied from one cell to another.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

1E642F47-A5B8-4DF5-A1CA-A928726AE753.jpeg

Summary of Protein Synthesis.pdf

Genetics and genomics.edited.docx

23.jpeg

Biol1102-A_Assign5_Indiv(Health_Env).docx

02_04_membrane_transport.docx

3. (75) Unit 6.pdf

_07._cancer_ws.docx

Screenshot 2023-11-04 at 2.03.46 PM.png

Documento electrónico.docx

Tyrosine lab.edited.docx

bio150f.docx

Recommended textbooks for you

Human Heredity: Principles and Issues (MindTap Co...

Biology

ISBN:9781305251052

Author:Michael Cummings

Publisher:Cengage Learning

Biology: The Dynamic Science (MindTap Course List)

Biology

ISBN:9781305389892

Author:Peter J. Russell, Paul E. Hertz, Beverly McMillan

Publisher:Cengage Learning

Biology (MindTap Course List)

Biology

ISBN:9781337392938

Author:Eldra Solomon, Charles Martin, Diana W. Martin, Linda R. Berg

Publisher:Cengage Learning

Biology: The Unity and Diversity of Life (MindTap...

Biology

ISBN:9781305073951

Author:Cecie Starr, Ralph Taggart, Christine Evers, Lisa Starr

Publisher:Cengage Learning

Biomedical Instrumentation Systems

Chemistry

ISBN:9781133478294

Author:Chatterjee

Publisher:Cengage

Principles Of Pharmacology Med Assist

Biology

ISBN:9781337512442

Author:RICE

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

Human Heredity: Principles and Issues (MindTap Co...
Biology
ISBN:9781305251052
Author:Michael Cummings
Publisher:Cengage Learning
Biology: The Dynamic Science (MindTap Course List)
Biology
ISBN:9781305389892
Author:Peter J. Russell, Paul E. Hertz, Beverly McMillan
Publisher:Cengage Learning
Biology (MindTap Course List)
Biology
ISBN:9781337392938
Author:Eldra Solomon, Charles Martin, Diana W. Martin, Linda R. Berg
Publisher:Cengage Learning
Biology: The Unity and Diversity of Life (MindTap...
Biology
ISBN:9781305073951
Author:Cecie Starr, Ralph Taggart, Christine Evers, Lisa Starr
Publisher:Cengage Learning
Biomedical Instrumentation Systems
Chemistry
ISBN:9781133478294
Author:Chatterjee
Publisher:Cengage
Principles Of Pharmacology Med Assist
Biology
ISBN:9781337512442
Author:RICE
Publisher:Cengage