Based on the instructions and my excel worksheet can you let me know my mistakes or fix them as well as do the quiz. the quiz is pasted into the section below and the lab will be attached as well the instructions.
| 1. (TCO 2) An absolute cell reference |
causes a potential error.
indicates a cell's specific location and the reference does not change when you copy the formula.
occurs when a formula directly or indirectly refers to the cell containing the formula.
contains both an absolute and a relative cell reference.
|
| Question 2. 2. (TCO 2) In Excel, a function can be defined as a _____. (Points : 2) |
predefined formula that performs a calculation
cell reference or a value
list of values and defined names as you enter data into a spreadsheet
set of rules that govern the structure and components for a formula
|
| Question 3. 3. (TCO 2) =$E2-G$4 contains examples of _____ cell references. (Points : 2) |
absolute
mixed
relative
constant
|
| Question 4. 4. (TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function. (Points : 2) |
PRESENT
TODAY
CURRENT
SET
|
| Question 5. 5. (TCO 2) The _____ function returns a result based on a condition. (Points : 2) |
MAX
TODAY
FIND
IF
|
| Question 6. 6. (TCO 2) The MIN function would identify the _____. (Points : 2) |
highest value in a range
Tallies of the number of blank cells in a range
lowest value in a range
midpoint value in a range
|
| Question 7. 7. (TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____. (Points : 2) |
logical test
lookup value
breakpoint
table array action
|
| Question 8. 8. (TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false. (Points : 2) |
feature
formula
condition
option
|
| Question 9. 9. (TCO 2) Arithmetic operations, cell references, and _____ can be used in Excel formulas. (Points : 2) |
constants
macros
programs
procedures
|
| Question 10. 10. (TCO 2) To simplify entering ranges in formulas, you can use _____. (Points : 2) |
range names
a cell's relative location
both an absolute and a relative cell reference
a cell's specific location
|
| Question 11. 11. (TCO 2) The PMT function is best described by which of the following? (Points : 2) |
It is the periodic interest rate, such as a monthly interest rate.
It is the total number of payment periods.
It is the present value of a loan.
It calculates the periodic payment for a loan with a fixed interest rate and a fixed term.
|
| Question 12. 12. (TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose. (Points : 2) |
theme
style
template
macro
|
| Question 13. 13. (TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit. (Points : 2) |
format
hide
lock
unlock
|
| Question 14. 14. (TCO 7) Which of the following file formats can store macros? (Points : 2) |
xlsm
csv
xml
xlsx
|
|
Question 15.15. (TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette. (Points : 2)
|
View
Data
Insert
Developer |
Attachment:- BIS 155 Week 2 - iLab.xlsm