Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 10 Suppose cell A14 contains the string Jeff Highlander, PhD and cell B17 contains the formula =search (PHD, A14). What value will be displayed
3 10 Suppose cell A14 contains the string "Jeff Highlander, PhD" and cell B17 contains the formula "=search ("PHD", A14)". What value will be displayed in cell B17? 18 O #VALUE! O position 18 O #ERROR! 4 10 Suppose cell A12 contains a string representing a ticker symbol and the corresponding price (e.g. FB $74.31, AAPL $134.67). What is the correct formula to extract the price of the stock. Note that the number representing the price could be any number of digits. Check all correct answers. =MID(A1,FIND" "A1),LEN(A1) =RIGHT(A1,LEN(A1)-FIND" "A1)) =RIGHT(A1,6) =MID(A1,3,LEN(A1))
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started