Reference no: EM131298224
These questions have to do with the computer program Microsoft Excel
1. The results of the logical test can either be true or false. (T/F)
2. The > < operator is defined as "not equal to". (T/F)
3. A valid output of a logical function is either "1" or "0". (T/F)
4. The = < operator is defined as "less than or equal to". (T/F)
5. The output of the logical test 4 <= 5 is TRUE. (T/F)
6. The value of the "logical_test" arguement in the IF function can be either "1" or "-1". (T/F)
7. If a text input is used to define the [value_if_true] argument in the IF function, then that text must be enclosed in round brackets. (T/F)
8. If one of the logical tests in the OR function is true, the output of the function will be the word TRUE. (T/F)
9. The COUNT function will count the number of cells in a range that contain numeric or text data. (T/F)
10. The arguments used the COUNTIF function are "coefficient" and "mean". (T/F)
11. The AVERAGEIF function allows the user to define three cell ranges. (T/F)
12. The COUNTIFS function provides the option of defining multiple sets of criteria for selecting cells from a targeted range that will be used in the function output. (T/F)
13. The VLOOKUP function is typically used to access and display data located in another worksheet or workbook. (T/F)
14. A VLOOKUP function will search horizontall across the first row of a range of cells to find what is called a lookout value. (T/F)
15. "Criteria" is one of the arguments used in a VLOOKUP function. (T/F)
16. The cell range defined by the Table_array argument of the VLOOKUP function must contain the criteria used to define the Lookup_value in the first column. (T/F)
17. When the [Range_lookup] argument of the VLOOKUP function is defined with the word FALSE, the function will look for an exact match to the criteria used to define the Lookup_value argument in the first column of the table array range. (T/F)
18. If the [Range_lookup] argument of the VLOOKUP function is defined with the word TRUE, the function will look for a value that is an exact match or the closest match that is "more than" the lookup value. (T/F)
19. If the [Range_lookup] argument of the HLOOKUP function is defined with the word TRUE, the data in the table array range must be sorted based on the values in the first row in descending order from left to right. (T/F)
20. If the [Range_lookup] argument of the HLOOKUP function is not defined it will automatically be defined with the word TRUE. (T/F)
|
Explain why its earnings may be lower initially
: If Sue decides to expand CHC's existing facilities, explain why its earnings may be lower initially? A health club differs from manufacturing firms in that it produces a service rather than products.
|
|
Two investment advisers are comparing performance
: Two investment advisers are comparing performance. One averaged a 17% rate of return and the other a 13.5% rate of return. However, the beta of the first investor was 1.5, whereas that of the second was 1. If the T-bill rate were 4% and the market re..
|
|
Explain why the current ratio is important to chc
: Explain why the current ratio is important to CHC ? Explain how CHC's financial leverage can be measured. If the leverage is too high, what is the danger to CHC?
|
|
Final project-problem resolution in corrections
: You are the Director of Programs for a large state correctional system. The Commissioner comes to you with three (3) assignments. Each assignment has specific goals. Unfortunately, achievement of these goals cannot require an increase in the syste..
|
|
Criteria is one of the arguments used in vlookup function
: The results of the logical test can either be true or false. The =
|
|
Why is financial reporting important for firms
: Why is financial reporting important for firms? What impact might financial reporting have on a firm's stock price?- Describe the Sarbanes-Oxley Act of 2002.
|
|
Did g.m. sell 6,800 lemons to people who bought the pickups
: Did G.M. sell 6,800 lemons to people who bought the pickups? If G.M. did, what was the private information that it had that buyers did not know? If G.M. didn't, explain why not.
|
|
How to resolve workplace conflicts
: After reading your post the word 'involved' is critical to resolving or moving forward with conflict. Involvement requires rules during the process of resolvinig conflict.
|
|
Discuss the pros and cons of financial leverage for a firm
: If board members are being compensated with shares of the firm's stock, how could they be forced to act in the long-term interests of the company? Discuss the pros and cons of financial leverage for a firm.
|