1. Which of the following operators can you use in an EXCEL formula to help you calculate the 5th root of a number? @ $ 2. Which of these will calculate the number of atoms of hydrogen in 143 grams of methane? The molar mass of methane is in cell A3. O =(143/$A$3)*4*6.022e23 O=6.033e23/100*4*$A$3 O=143/$A$3*4*6.022e23 O =(143/$A$3)/4*6.022e23 O=143 6.022e23/4*$A$3 is a series of two or more adjacent cells in a column or row or rectangular group of cells. O SECTION O LIST O AREA ORANGE 3. A(n) O FORMULA 4. Cell C4 contains the formula B1 + B2. What formula will see if you copy the formula and paste it into cell J9? O = H5 + H6 O $16+ $17 O = G6 + G7 OB1 + B2 O = 16 + 17 5. When you copy a formula that contains an absolute reference to a new location, the reference O does not change O is updated automatically Obecomes bold O has a dotted outline in its cell
1. Which of the following operators can you use in an EXCEL formula to help you calculate the 5th root of a number? @ $ 2. Which of these will calculate the number of atoms of hydrogen in 143 grams of methane? The molar mass of methane is in cell A3. O =(143/$A$3)*4*6.022e23 O=6.033e23/100*4*$A$3 O=143/$A$3*4*6.022e23 O =(143/$A$3)/4*6.022e23 O=143 6.022e23/4*$A$3 is a series of two or more adjacent cells in a column or row or rectangular group of cells. O SECTION O LIST O AREA ORANGE 3. A(n) O FORMULA 4. Cell C4 contains the formula B1 + B2. What formula will see if you copy the formula and paste it into cell J9? O = H5 + H6 O $16+ $17 O = G6 + G7 OB1 + B2 O = 16 + 17 5. When you copy a formula that contains an absolute reference to a new location, the reference O does not change O is updated automatically Obecomes bold O has a dotted outline in its cell
Chemistry
10th Edition
ISBN:9781305957404
Author:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Chapter1: Chemical Foundations
Section: Chapter Questions
Problem 1RQ: Define and explain the differences between the following terms. a. law and theory b. theory and...
Related questions
Question
Chemistry
Excel applications in chemistry
![1. Which of the following operators can you use in an EXCEL formula to help you calculate the 5th root of a number?
O $
2. Which of these will calculate the number of atoms of hydrogen in 143 grams of methane? The molar mass of methane is in cell A3.
O =(143/$A$3)*4*6.022e23
O =6.033e23/100*4*$A$3
O =143/$A$3*4*6.022e23
O =(143/$A$3)/4*6.022e23
O =143 6.022e23/4* $A$3
is a series of two or more adjacent cells in a column or row or rectangular group of cells.
O SECTION
O LIST
O AREA
ORANGE
3. A(n)
O FORMULA
4. Cell C4 contains the formula B1 + B2. What formula will see if you copy the formula and paste it into cell J9?
OH5 + H6
O $16+ $17
O = G6 + G7
O B1 + B2
O = 16 + 17
5. When you copy a formula that contains an absolute reference to a new location, the reference
O does not change
O is updated automatically
Obecomes bold
O has a dotted outline in its cell](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff1c0660a-360c-401e-9f22-7ef858e9494d%2Fdbc7c8f0-f932-4612-8b6a-376735ea2b53%2F3p43o6a_processed.png&w=3840&q=75)
Transcribed Image Text:1. Which of the following operators can you use in an EXCEL formula to help you calculate the 5th root of a number?
O $
2. Which of these will calculate the number of atoms of hydrogen in 143 grams of methane? The molar mass of methane is in cell A3.
O =(143/$A$3)*4*6.022e23
O =6.033e23/100*4*$A$3
O =143/$A$3*4*6.022e23
O =(143/$A$3)/4*6.022e23
O =143 6.022e23/4* $A$3
is a series of two or more adjacent cells in a column or row or rectangular group of cells.
O SECTION
O LIST
O AREA
ORANGE
3. A(n)
O FORMULA
4. Cell C4 contains the formula B1 + B2. What formula will see if you copy the formula and paste it into cell J9?
OH5 + H6
O $16+ $17
O = G6 + G7
O B1 + B2
O = 16 + 17
5. When you copy a formula that contains an absolute reference to a new location, the reference
O does not change
O is updated automatically
Obecomes bold
O has a dotted outline in its cell
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, chemistry and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Chemistry](https://www.bartleby.com/isbn_cover_images/9781305957404/9781305957404_smallCoverImage.gif)
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
![Chemistry](https://www.bartleby.com/isbn_cover_images/9781259911156/9781259911156_smallCoverImage.gif)
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
![Principles of Instrumental Analysis](https://www.bartleby.com/isbn_cover_images/9781305577213/9781305577213_smallCoverImage.gif)
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
![Chemistry](https://www.bartleby.com/isbn_cover_images/9781305957404/9781305957404_smallCoverImage.gif)
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
![Chemistry](https://www.bartleby.com/isbn_cover_images/9781259911156/9781259911156_smallCoverImage.gif)
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
![Principles of Instrumental Analysis](https://www.bartleby.com/isbn_cover_images/9781305577213/9781305577213_smallCoverImage.gif)
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
![Organic Chemistry](https://www.bartleby.com/isbn_cover_images/9780078021558/9780078021558_smallCoverImage.gif)
Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education
![Chemistry: Principles and Reactions](https://www.bartleby.com/isbn_cover_images/9781305079373/9781305079373_smallCoverImage.gif)
Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning
![Elementary Principles of Chemical Processes, Bind…](https://www.bartleby.com/isbn_cover_images/9781118431221/9781118431221_smallCoverImage.gif)
Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY