CSE EXAM 2 QUESTIONS AND ANSWERS

CSE EXAM 2 QUESTIONS AND ANSWERS
The main difference between a VLOOKUP function and an HLOOKUP function is the
orientation of the table array used (vertical versus horizontal).

TRUE/FALSE - answer- TRUE

Absolute or mixed cell referencing does not apply to the array arguments when copying
a VLOOKUP or HLOOKUP function to another cell.

TRUE/FALSE - answer- FALSE

What is one of the main reasons why reference functions are used in place of the
nested IF function? - answer- - the nested IF function is difficult to maintain
- the nested IF function can be cumbersome and time consuming to implement
- the IF function is limited to 64 nested IFs

Given the table above, which formula will give the letter grade if the score is located in
cell H6, and the score is not an exact match? - answer- =HLOOKUP(H6, B1:F2, 2,
TRUE)

For the HLOOKUP function, the lookup_value must be in the first row of the table array.

TRUE/FALSE - answer- TRUE

The ________________ is the current value or original amount of the financial
instrument, either a loan or an investment. - answer- Principle

Which of the following is a built-in financial function available in Excel? - answer- - PV( )
- NPER( )
- RATE( )
- PMT( )

Spreadsheets can be used to track a variety of financial information, including which of
the following? - answer- - loan obligations
- the value of investment portfolios
- income and expenditures

A(n) ____________ is a non-empty field, or collection of fields, in a table whose
value(s) uniquely identify each record in it. - answer- Primary key

Every table must have a single-field primary key.

TRUE/FALSE - answer- FALSE