AnswersCHS- TX-Professional Communications CRUse Spreadsheet Functions and Formulas

Use Spreadsheet Functions and Formulas Answers

4 verified answers3 views
1
Free Preview

Use the drop-down menus to answer each of the following questions.Which lookup function would you use to search for and return values from adjacent rows of a table?

A
VLookup
B
HLookup
2
Free Preview

Which lookup function would you use to search for and return values from adjacent columns of a table?

A
VLookup
B
HLookup
3

Which function should you use to extract shipping values from the Lookup Table?

A
VLookup
B
HLookup
C
Average
D
Sum
4

Which of the following best defines a nested IF statement?

A
formatting that applies to a cell if specific conditions are met
B
a function used to test if a specific condition is true or false
C
an IF function within an IF function
D
specifications to prevent modifications to data

Did you find these answers helpful?

More from this Course

Assignment
4 verified answers

Part 3

Assignment
3 verified answers

Part 1

Assignment
20 verified answers

Advanced Spreadsheet Features

Use Spreadsheet Functions and Formulas Answers…