Question: The Assignment 4 . 2 . xlsm file has periodic table data for chemical elements ( chemists will recognize this but no need to be

The Assignment 4.2.xlsm file has periodic table data for chemical elements (chemists will recognize this but no need to be a chemist!). Element name is in column A, atomic Symbol is in column B, Atomic # is in column C, and Mass is in column D.The goal for this part of the assignment is to output the Element, Atomic #, and Mass in cells G5:G7, respectively, given the Symbol that the user inputs into cell G4. Additionally, you need to have data validation in cell G4 only the Symbols in
column B are acceptable in cell G4.
Why this solution dont work in cell G5 please sent me the correct answer
The Assignment 4.2.xlsm file has periodic table data for chemical elements

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Table of Elements There are 94 chemical elements known to occur naturally on earth. The symbol, name, and atomic mass of all 94 elements are shown in the following table. Symbol Name Atomic Mass...

Q:

Language: Python 3.6.1 Interpreter: Anaconda 3.6.4 --- Program used: PyCharm --- Starter code: Shown below image --- --- elements = [ ('H', 'Hydrogen', 1, 1.008), ('He', 'Helium', 2, 4.003), ('Li',...

Q:

Do the following: Using VS Code, create a new file and save it as chemistry.py In the chemistry.py file, write a function named make _ periodic _ table that takes no parameters and creates and...

Q:

Purpose: To practice creating and using tuples. In this exercise, you will create a program that can display information about the first ten elements in the periodic table. The periodic table of is a...

Q:

In chemistry, a mole is a very large, fixed quantity, specifically 6 0 2 , 2 1 4 , 0 7 6 , 0 0 0 , 0 0 0 , 0 0 0 , 0 0 0 , 0 0 0 ( usually written as 6 . 0 2 2 1 4 0 7 6 \ times 1 0 2 3 ) . The molar...

Q:

Periodic table of elements Objectives Learn how to read from and write to files Practice using data structures Practice top-down program design Practice re-using code Overview For this lab, you will...

Q:

Bookmark Periodic table of elements Objectives Learn how to read from and write to files Practice using data structures Practice top-down program design Practice re-using code Overview For this lab,...

Q:

IE 311 Operations Research I, Summer 2020 Assignment 1 Due on 20 July 2020, Monday, 23:59 (thr KHAS Learn) YOU SHOULD ATTEMPT TO SOLVE ALL QUESTIONS TO RECEIVE A PASS (100%) or IT IS A FAIL (0%),...

Q:

C++ programming chemical compounds. Thank you! Hint: /***************************************** The purpose of this is to provide you with a single function which will convert an integer to a string,...

Q:

need help for Question 1 and 2 of the assignment fir ACCT 221 FORENSIC BUSINESS INVESTIGATION. Pertains to WorldCom scandal. QAssuming WorldCom was a company operating in Australia at the time of the...

Q:

What are the potential tax consequences of selling an old asset in an asset replacement investment decision?

Q:

You are provided with the following information for Lahti Inc. for the month ended June 30, 2014. Lahti uses the periodic method for inventory. Instructions (a) Calculate (i) ending inventory , (ii)...

Q:

A general journal is like a ( n ) : Multiple Choice 0 address book. appointment calendar. diary.

Q:

Attempts Keep the Highest / 1 3. Problem 4.05 (Price-Earnings Ratio) eBook A company has an EPS of $1.80, a book value per share of $19.44, and a market/book ratio of 1.6x. What is its P/E ratio? Do...

Q:

Teamwork. Divide the class into teams of two. Each team member should select a childrens book or an excerpt that can be read to his or her partner in about ten minutes. Each reader should use his or...

Q:

Explain how pitch can be used to show comparisons and contrasts. (Objective 2)

Q:

Discuss the impressions given by a speaker who does each of the following: (Objective 5) a. Rocks back and forth on his or her feet b. Scans the audience by looking above members heads c. Sits on the...