Solution-An absolute cell reference

An absolute cell reference

Assignment Help Business Management

Reference no: EM13940094

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

Reference no: EM13940094

Questions Cloud

About egypt socio cultural and economic market : About Egypt socio cultural and Economic Market ?. 3 pages not copy more that 30% from internet .

Project from a shareholder wealth maximizing perspective : Assume NEWC has an investment opportunity (similar to the air bag opportunity in Other People's Money).The firm can spend $325 Million on refurbishing its wire and cable plant to develop a product that will be sold in packets or units of twenty. How ..

Servant leadership begins with the natural feeling : Servant leadership is a popular and unique leadership behavior that has proven to be effective for many leaders and followers. Robert Greenleaf (1970) first presented the term "servant leadership" in a 1970 essay, entitled "The Servant Leader" where ..

Average cost of capital using new common stock : What is the weighted average cost of capital using retained earnings? What is the weighted average cost of capital using new common stock?

An absolute cell reference : 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 containin..

Calculate the margin of safety in units : Fixed manufacturing costs total $231,650 per year. Calculate the break-even point in units. Calculate the margin of safety in units. Calculate the margin of safety in dollars.

What is rezlers variable cost ratio : What is Rezler's variable cost ratio? What is its contribution margin ratio? Suppose Rezler's actual revenues are $30,000 more than budgeted. By how much will operating income increase?

Analyze the commission conundrum : Use that frame to analyze the "Commission Conundrum". And please write down the process in detail. For example, if your decision break a law, please write down what law does it break.

What is the weighted average cost of capital : What is the weighted average cost of capital using retained earnings? What is the weighted average cost of capital using new common stock?

User Account

All Pages

An absolute cell reference

Reference no: EM13940094

Reference no: EM13940094

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Caselet on michael porter’s value chain management

Mountain man brewing company

Mountain man brewing company

Analysis of the case using the doing ethics technique

Affiliations and partnerships

Innovation-friendly regulations

Effect of regional and corporate cultural issues

Structure of business plan

Identify the purposes of different types of organisations

Entrepreneur case study for analysis

Forecasting and business analysis

Educational instructional leadership

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT