Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 23rd International Conference Dexa 2012 Vienna Austria September 2012 Proceedings Part 1 Lncs 7446

Authors: Stephen W. Liddle ,Klaus-Dieter Schewe ,A Min Tjoa ,Xiaofang Zhou

2012th Edition

3642325998, 978-3642325991

More Books

Students also viewed these Databases questions