Bis 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab

(TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate

Same Domain Values: Data within a column adheres to a single domain. For instance a geneder column will have values for gender but no other.

The formula refers to a cell range that Excel cannot understand. Make sure that the range is entered correctly.

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output; this information is needed in order to receive full credit on these problems.

| When you add a bound control to a form, Access adds a text box and, to its left, a(n) ____. a.

When a new column is added to a spreadsheet it is added to the _____ of the selected column. (Unit 5)

Question 1.1.(TCO 10) Match the terms in Column I with the descriptions in Column II.

The symbol ¶ or abbreviation “para.” Both are acceptable (¶ can be found on the Insert

The fourth pair of columns on a 10-column work sheet prepared at the end of the period would be the

Ai Using the table below, explain in your own words what each term means. Give one

To calculate the return at T, several calculations have to be performed. The following formula is applied to calculate the future value of the loan taken, in other words, what Jim has to buy back at T:

// celltop computes the y coordinate for the top of a cell in row r

In this formula p stands for a prime number, therefore in the first example two is the prime number being used. You have two as the base because this is what the formula calls for, and then you subtract one from your prime number, two, to get two to the first power. Then inside your parenthesis you have two to the second power, the base taken from the formula

Conversely, a relative reference (this is the standard format) will remain relative to where it is placed; if you copy the formula down a particular row or column, the formula will auto-update based on its placement in the data. You can also combine the two functions, also known as a mixed cell reference. If you place the $ sign before only 1 reference point – column OR row, it becomes a mixed reference. Based on where you place the $ sign, that particular row or column will remain fixed, while the rest of the data will update if it is moved or copied. It is also possible to reference data from another worksheet in the workbook, or from an entirely different workbook. You can link workbooks and their data in this way. I have used external references at work to link a cost analysis review to another workbook that was shared with other users in a local network so they could be apprised of a certain set of data.

Number of parameters: It represents the complexity in using the function which may also relate to comment change, if the function is changed.