Which what if analysis is the best option for complex calculations requiring
constrained optimization?
a)Goal seek
b)Scenario Manager
c)Data Tables
d)Solver
Give this one a try later!
b)Scenario Manager
A column contains phone numbers such as (801)-555-1234. What function should you
use to extract the last four
Give this one a try later!
, RIGHT
A work sheet contains addresses in column C. The addresses use commas after the
street, city, and state, such as 129 Elm Street, Burlington, NC, 27215. Column D
contains the phone number. You use the text to columns to divide the addresses into
multiple columns using comma delimiters. You successfully divide the addresses into
four columns. What happens to the phone numbers in column D?
a)The phone numbers are overwritten with city names
b)The phone numbers are converted to commas
c)Excel Phone number column is moved to the right side of all the columns containing
the parts of the addresses
d) The phone number column is moved to the left of the original address
Give this one a try later!
a)The phone numbers are overwritten with city names
Which tool is most effective when comparing the impact of various combinations of
production expenses and new customer acquisition on net sales profit?
a)Goal Seek
b)Solver
c)Two variable data table
d)Scenario Manager
Give this one a try later!
c)Two variable data table
constrained optimization?
a)Goal seek
b)Scenario Manager
c)Data Tables
d)Solver
Give this one a try later!
b)Scenario Manager
A column contains phone numbers such as (801)-555-1234. What function should you
use to extract the last four
Give this one a try later!
, RIGHT
A work sheet contains addresses in column C. The addresses use commas after the
street, city, and state, such as 129 Elm Street, Burlington, NC, 27215. Column D
contains the phone number. You use the text to columns to divide the addresses into
multiple columns using comma delimiters. You successfully divide the addresses into
four columns. What happens to the phone numbers in column D?
a)The phone numbers are overwritten with city names
b)The phone numbers are converted to commas
c)Excel Phone number column is moved to the right side of all the columns containing
the parts of the addresses
d) The phone number column is moved to the left of the original address
Give this one a try later!
a)The phone numbers are overwritten with city names
Which tool is most effective when comparing the impact of various combinations of
production expenses and new customer acquisition on net sales profit?
a)Goal Seek
b)Solver
c)Two variable data table
d)Scenario Manager
Give this one a try later!
c)Two variable data table
