Chapter Two Flashcards
1
Q
What is the correct syntax for the ROUND function?
A
=ROUND(number,num_digits)
2
Q
In cell D10, Rachel entered the following formula: =D8+D9+D10. What term describes what is going on with this formula?
A
Circular Reference
3
Q
What function uses a lookup table that is organized in columns?
A
VLOOKUP
4
Q
What function counts the number of cells in a range that contain any data type (text or numbers)?
A
COUNTA
5
Q
What is the correct syntax for the IF function?
A
=IF(C5<=20,7,10)
6
Q
What Formula Auditing tools displays arrows to all cells that use the active cell directly or indirectly in a formula?
A
Trace Dependents
7
Q
What references cells located in another worksheet in the same workbook?
A
3D Cell Reference
