1. Jason wants to display the text "Poor" if the value in cell A3 is less...

1. Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

a. IF(A3 > 50, "Good", =IF(A3 < 25, "Poor", "Good")

b. =IF(A3 < 25, "Poor"), IF(A3 < 50, "Average")

c. =IF(A3 < 25, "Poor", "Average", "Good")

D. =IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good"))

2. Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?

Select one:

a. Negative

b. Modified Percent

c. General

d. Custom

3. If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

Select one:

a. SERIAL

b. HOUR

c. TIME

d. NOW

Solutions

Expert Solution

Answers :

1) Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?
Ans : D. =IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good"))

2) Betty wants to display negative percentages in red text with parentheses. What type of number format should she apply?
Ans : d. Custom

3) If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

Ans : a. SERIAL

Nightingale answered 2 years ago

Next > < Previous

Related Solutions

Question 1: Write an AVR program to display text on a 2-line WH2002 LCD display based...

Question 1: Write an AVR program to display text on a 2-line WH2002 LCD display based on the HD44780 controller. Apply the following: The LCD instruction/data bus is connected to PORTD, and control bus is connected to PORTB (RS is connected to PB0, R/W to PB1, E to PB2). Use the #define command to name PORTD as Display_port. Use the #define command to name PORTB as Control_port. The displayed information is stored in the microcontroller Flash ROM (maximum size of...

MCQ 1. Upon retirement, Jason wants to invest his super in a fund where the manager...

MCQ 1. Upon retirement, Jason wants to invest his super in a fund where the manager buys only blue chip companies that pay a regular and high dividend. He is happy for the manager to constantly search for the best stocks which fit this profile and is happy for the portfolio composition to be changed to include the best opportunities of this type. Jason does not require liquidity in the investment. Given the following advertisements of funds, which fund is...

1. Write a bash command that will display the value of all environment variables defined in...

1. Write a bash command that will display the value of all environment variables defined in your shell process, sorted in alphabetical order, and numbered. Here is a sample of the type of output your command should produce: 1 } 2 ALSA_CONFIG_PATH=/etc/alsa-pulse.conf 3 AUDIODRIVER=pulseaudio 4 BASH_FUNC_mc%%=() { . /usr/share/mc/mc-wrapper.sh 5 COLORTERM=1 2. Write a bash command that will display the value (and only the value) of the JAVA_ROOT environment variable. Here is a sample of the type of output your...

Question 1 1. Text messages were first made available to cell phone users with the advent...

Question 1 1. Text messages were first made available to cell phone users with the advent of ____ technology. a. 3G b. 1G c. 2.5G d. 2G 1 points Question 2 A Bluetooth-enabled smartphone will also be compatible with a Bluetooth-enabled ____. a. notebook computer b. printer c. car d. all of the above 1 points Question 3 A MAC address contains ____. a. only symbols b. digits and letters c. only digits d. only letters 1 points Question 4...

1. For each vendor display the vendor name, sum of all orders as Total Value and...

1. For each vendor display the vendor name, sum of all orders as Total Value and the number of orders placed as # Orders. Hint you must calculate the total amount for each order based upon unit price and number of units ordered. Write SQL Query 2. Display the name of vendors who have supplied at least one order to every event. Hint this query will require nested correlated subqueries using the not exists operator. Write SQL query

1. how does your cell phone call or send a text message? ( i know it...

1. how does your cell phone call or send a text message? ( i know it related resonance photon frequency , and electromagnetic induction, but how to using it?) 2. how does message get recieved by the person you are hoping to call?

1)Under the net-present-value method, if the cost of the asset is less than the present value...

1)Under the net-present-value method, if the cost of the asset is less than the present value of the future cash flows, the: investment's expected return is greater than the firm's cost of capital firm's cost of capital is greater than the rate of return on assets net-present-value is negative investment should not be made 2) A capital investment generates a satisfactory rate of return when its return is: Greater than the internal rate of return Less than the cost of...

Refer to information in table 1. A cell phone company wants to devise pricing based on...

Refer to information in table 1. A cell phone company wants to devise pricing based on potential buyers’ differences in preferences. Differences in preferences are shown by the group elasticities in column 2. Marginal cost (MC) of the cell phone is $200. Table 1: cell phone elasticities by consumer groups and marginal costs Consumer groups Price elasticity of demand MC Price Working adults -1.25 $200 High income households -1.35 $200 Senior citizens -1.7 $200 Students -2 $200 If the base...

1. What is the probability that a value chosen from the standard normal distribution is less...

1. What is the probability that a value chosen from the standard normal distribution is less than -0.86? (Keep 4 decimals) 2. What is the probability that a value chosen from the standard normal distribution is greater than 2.02? (Keep 4 decimals) 3. what is the probability that a value chosen from the standard normal distribution is between 0.44 and 1.35? (Keep 4 decimals) 4. Find Q1 for the standard normal distribution. (Keep 2 decimals) 5. Find Q3 for the...

1. What is the probability that a value chosen from the standard normal distribution is less...

1. What is the probability that a value chosen from the standard normal distribution is less than -0.86? (Keep 4 decimals) 0.1949 0.02172. What is the probability that a value chosen from the standard normal distribution is greater than 2.02? (Keep 4 decimals) 0.24153. what is the probability that a value chosen from the standard normal distribution is between 0.44 and 1.35? (Keep 4 decimals) 4. Find Q1 for the standard normal distribution. (Keep 2 decimals) 5. Find Q3 for...

Subjects