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...
icon
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
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
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Stoichiometry
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
Chemistry
Chemistry
ISBN:
9781305957404
Author:
Steven S. Zumdahl, Susan A. Zumdahl, Donald J. DeCoste
Publisher:
Cengage Learning
Chemistry
Chemistry
Chemistry
ISBN:
9781259911156
Author:
Raymond Chang Dr., Jason Overby Professor
Publisher:
McGraw-Hill Education
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Organic Chemistry
Organic Chemistry
Chemistry
ISBN:
9780078021558
Author:
Janice Gorzynski Smith Dr.
Publisher:
McGraw-Hill Education
Chemistry: Principles and Reactions
Chemistry: Principles and Reactions
Chemistry
ISBN:
9781305079373
Author:
William L. Masterton, Cecile N. Hurley
Publisher:
Cengage Learning
Elementary Principles of Chemical Processes, Bind…
Elementary Principles of Chemical Processes, Bind…
Chemistry
ISBN:
9781118431221
Author:
Richard M. Felder, Ronald W. Rousseau, Lisa G. Bullard
Publisher:
WILEY