Case-Based Critical Thinking Questions
?
Case 8-3
You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
?
?
You implement the VLOOKUP formula at your colleague's suggestion, but you get the #VALUE! error as the result of the formula. Which of the following is likely true?
A. You might have entered a table name for the table_array value instead of the cell reference of the lookup table.
B. You might have indicated that the compare values are a range of values instead of an exact match.
C. You might have entered a number for the col_index_num instead of a letter.
D. You might have entered a letter for the col_index_num instead of a number.
Answer: D
You might also like to view...
________ allows the specification of rules that apply formatting to cells or specific controls, as determined by the rule outcome
A) A group header B) A control C) Conditional formatting D) A theme
The act of splitting the wires of a twisted-pair cable connection would be an example of which of the following?
A. Wardriving B. Data emanation C. Wiretapping D. Spectral analyzing
The maximum amount of work that it takes to access a given node in a full binary tree is O(N).
Answer the following statement true (T) or false (F)
Processes are usually referred to by their _______________.
A. globally unique identifier (GUID) B. service name C. executable name D. process identifier (PID)