Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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 Internals A Deep Dive Into How Distributed Data Systems Work

Authors: Alex Petrov

1st Edition

1492040347, 978-1492040347

More Books

Students also viewed these Databases questions