Devry Bis 155 Week 2 Quiz - Updated Essay examples

1021 Words Nov 26th, 2015 5 Pages
DeVry BIS 155 Week 2 Quiz - Updated
IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM
DeVry BIS 155 Week 2 Quiz

Question 1.1. (TCO 2) In Excel, a relative cell reference: (Points : 2) indicates a cell's specific location and the reference does not change when you copy the formula. contains both an absolute and a relative cell reference. indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula. occurs when a formula directly or indirectly refers to the cell
…show more content…
(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) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks? (Points : 2) Macros Templates Themes Background

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) By default, a macro records cells as _____ references if they are selected while recording the macro. (Points : 2) absolute relative flexible mixed

Question 15.15. (TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2) saves deletes runs disables

Additional Questions to Quiz 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

Related Documents