Quiz 2 Flashcards
True or False?
When copying a formula down the column, it is necessary to put $ before each column address.
False
True or False?
Formulas or functions cannot be nested inside of each other in Excel.
False
What is the difference between a formula and a function in Excel?
A. Functions never use numbers
B. Functions are predefined formulas that perform specific calculations
C. Formulas only use numbers
D. Formulas are user defined functions that perform various calculations
E. There is no difference
D
True or False?
The COUNTA( ) function determines the number of numeric and non-numeric values in a list and the order of the arguments in the list does not matter.
True
Given the following information,
Cell A1=45
Cell A2= blank
Cell A3= MIN(A1,A2)
What is the value in cell A3?
45
True or False?
Only some, not all, of the predefined functions in Excel have an underlying algorithm that is programmed into the software.
False
Why use the SUM function with a range of cells when adding the values together accomplishes the same thing?
A. It requires no modification if row or column is added to the range
B. It saves time
C. Range is adjusted when copying function into another cell
D. All of the above
D
Which of the following is true about cell referencing in Excel?
A. An absolute cell reference is a cell address that contains a $ in the row an column
B. By default, all cell references are relative references (when copied they change based on the relative position of the rows and columns
C. Absolute references remain constant no matter where they’re copied
D. Mixed cell referencing is where either the row or column is made absolute (anchored in)
E. All of the above
E
True or False?
Named ranges are always treated as absolute cell references.
True
True or False
When you translate a problem and encode it into a spreadsheet the first thing you should do is consider using absolute cell referencing.
False
That is the last thing you should do.