Devry Bis 155 Week 2 Quiz - Updated

In: Other Topics

Submitted By mysinvedi
Words 1008
Pages 5
DeVry BIS 155 Week 2 Quiz - Updated
IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-2-quiz-updated IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM
DeVry BIS 155 Week 2 Quiz

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 containing the formula.

Question 2.2. (TCO 2) Which of the following best describes a mixed cell reference? (Points : 2) Occurs when a formula directly or indirectly refers to the cell containing the formula. Causes a potential error. Contains absolute or relative cell references, but not both. Contains both an absolute and a relative cell reference.

Question 3.3. (TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2) abstract relative mixed absolute

Question 4.4. (TCO 2) Which of the following describes the SUM function? (Points : 2) Identifies the midpoint value in a set of values. Calculates the total of values contained in two or more cells. Calculates the arithmetic mean or average of values in a range. Displays the lowest value in a range.

Question 5.5. (TCO 2) The _____ function returns a…...

Similar Documents

Bis 155 Week 2 Excel’s Advanced Formulas & Functions – Quiz

...BIS 155 Week 2 Excel’s Advanced Formulas & Functions – Quiz http://homeworkfy.com/downloads/bis-155-week-2-excels-advanced-formulas-functions-quiz/ 1. (TCO 2) An absolute cell reference: (Points : 2) 2. (TCO 2) Which of the following best describes a circular reference? (Points: 2) 3. (TCO 2) =$E2-G$4 contains examples of _____ cell references. (Points: 2) 4. (TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points: 2) 5. (TCO 2) The MEDIAN function would identify the ____. (Points: 2) 6. (TCO 2) The MAX function identifies the _____. (Points: 2) 7. (TCO 2) The NOW function would perform which of the following? (Points:2) 8. (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2) 9. (TCO 2) Arithmetic operations, cell references, and ____can be used in Excel formulas. (Points : 2) 10. (TCO 2) To simplify entering ranges in formulas, you can use _____. (Points : 2) 11. (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year. (Points : 2) 12. (TCO 2) When calculating a PMT function, the PV is best described by which of the following? (Points : 2) 13. (TCO 7) Before protecting a worksheet, you should __ the cells that you want users to be able to edit. (Points : 2) 14. (TCO 7) Which of the following file formats can store macros? (Points : 2) 15. (TCO 7) By default...

Words: 280 - Pages: 2

Bis 155 Week 3 : Data Analysis Functions – Quiz

...BIS 155 Week 3 : Data Analysis Functions – Quiz http://homeworkfy.com/downloads/bis-155-week-3-data-analysis-functions-quiz/ BIS 155 Week 3 : Data Analysis Functions – Quiz 1. (TCO 4) If there are certain columns of information that are not needed at a particular time but might be needed later,_ the unneeded columns to allow users to focus on only the essential information. (Points:2) 2. (TCO 4) In Excel, the print area is defined as _____. (Points : 2) 3. (TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2) 4. (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is……__. (Points:2) 5. (TCO 4) To create a new Conditional Formatting Rule, _____. (Points : 2) 6. (TCO 4) In addition to sorting and filtering cells by content, you can sort and/or filter by _____. (Points : 2) 7. (TCO 4) When data is grouped, the margin area displays the _____. (Points : 2) 8. (TCO 4) A _____ allows you to identify relationships between variables in your data. (Points : 2) 9. (TCO 4) Data mining techniques such as PivotTables can detect _____ of data. (Points : 2) 10. (TCO 4) A faster way to expand all categories at one time is to click _____. (Points : 2) 11. (TCO 4) Data displayed in the PivotTable will be updated _____. (Points : 2) 12. (TCO 4) A quick way to display the Go to dialog box is to press the _____ key(s). (Points : 2) 13. (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be......

Words: 311 - Pages: 2

Devry Bis 155 Week 2 Quiz - Updated

...DeVry BIS 155 Week 2 Quiz - Updated IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-2-quiz-updated IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DeVry BIS 155 Week 2 Quiz 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 containing the formula. Question 2.2. (TCO 2) Which of the following best describes a mixed cell reference? (Points : 2) Occurs when a formula directly or indirectly refers to the cell containing the formula. Causes a potential error. Contains absolute or relative cell references, but not both. Contains both an absolute and a relative cell reference. Question 3.3. (TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2) abstract relative mixed ......

Words: 1008 - Pages: 5

Bis 155 Complete Class Devry

...BIS 155 COMPLETE CLASS DEVRY To purchase this visit here: http://www.activitymode.com/product/bis-155-complete-class-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 COMPLETE CLASS DEVERY BIS 155 (Advanced PC Applications with Lab) Complete Course - DeVry Latest Course LATEST COURSE WORK - October 2014 BIS 155 Lab1 BIS 155 Week 1 Quiz BIS 155 Week 1 DQ Getting Familiar with Excel BIS 155 Lab 2 BIS 155 Week 2 Quiz BIS 155 Week 2 DQ Formulas and Functions BIS 155 Lab 3 BIS 155 Week 3 Quiz BIS 155 Week 3 DQ Data Analysis BIS 155 Lab 4 BIS 155 Week 4 Quiz BIS 155 Week 4 DQ Excel Data Exchange BIS 155 Lab 5 BIS 155 Week 5 Quiz BIS 155 Week 5 DQ Data Consolidation and What BIS 155 Lab 6 BIS 155 Week 6 Quiz BIS 155 Week 6 DQ Bringing It All Together BIS 155 Lab 7 BIS 155 Week 7 Quiz BIS 155 Week 7 DQ Database Decisions BIS 155 Memo Northwind Trades Project BIS 155 Week-6-Course-Project BIS 155 Final Exam - Latest Activity mode aims to provide quality study notes and tutorials to the students of BIS 155 COMPLETE CLASS DEVRY in order to ace their studies. BIS 155 COMPLETE CLASS DEVRY To purchase this visit here: http://www.activitymode.com/product/bis-155-complete-class-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 COMPLETE CLASS DEVERY BIS 155 (Advanced PC Applications with Lab) Complete Course - DeVry Latest Course LATEST COURSE WORK - October 2014 BIS 155 Lab1 BIS 155 Week 1 Quiz BIS 155......

Words: 628 - Pages: 3

Bis 155 Complete Class Devry

...BIS 155 COMPLETE CLASS DEVRY To purchase this visit here: http://www.activitymode.com/product/bis-155-complete-class-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 COMPLETE CLASS DEVERY BIS 155 (Advanced PC Applications with Lab) Complete Course - DeVry Latest Course LATEST COURSE WORK - October 2014 BIS 155 Lab1 BIS 155 Week 1 Quiz BIS 155 Week 1 DQ Getting Familiar with Excel BIS 155 Lab 2 BIS 155 Week 2 Quiz BIS 155 Week 2 DQ Formulas and Functions BIS 155 Lab 3 BIS 155 Week 3 Quiz BIS 155 Week 3 DQ Data Analysis BIS 155 Lab 4 BIS 155 Week 4 Quiz BIS 155 Week 4 DQ Excel Data Exchange BIS 155 Lab 5 BIS 155 Week 5 Quiz BIS 155 Week 5 DQ Data Consolidation and What BIS 155 Lab 6 BIS 155 Week 6 Quiz BIS 155 Week 6 DQ Bringing It All Together BIS 155 Lab 7 BIS 155 Week 7 Quiz BIS 155 Week 7 DQ Database Decisions BIS 155 Memo Northwind Trades Project BIS 155 Week-6-Course-Project BIS 155 Final Exam - Latest Activity mode aims to provide quality study notes and tutorials to the students of BIS 155 COMPLETE CLASS DEVRY in order to ace their studies. BIS 155 COMPLETE CLASS DEVRY To purchase this visit here: http://www.activitymode.com/product/bis-155-complete-class-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 COMPLETE CLASS DEVERY BIS 155 (Advanced PC Applications with Lab) Complete Course - DeVry Latest Course LATEST COURSE WORK - October 2014 BIS 155 Lab1 BIS 155 Week 1 Quiz BIS 155......

Words: 628 - Pages: 3

Devry Bis 155 Week 3 Quiz - Updated

...DeVry BIS 155 Week 3 Quiz - Updated IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-3-quiz-updated IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DeVry BIS 155 Week 3 Quiz Page 1 Question 1.1. (TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2) Formatting Freezing Resizing Tiling Question 2.2. (TCO 4) In Excel, a table is defined as _____. (Points : 2) an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis a complete set of data for an entity a Field, which is an individual piece of data an individual piece of data, such as a last name Question 3.3. (TCO 4) To create a table from an existing range of data, _____. (Points : 2) click within the range, click the Table Tools Design tab, and then select Convert to Table select any cell in the worksheet and then click Existing Range in the Tools group click in a cell and on the Home tab, and click the Insert arrow in the Cells group click the Insert tab and then click Table in the Tables group Question 4.4. (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. (Points : 2) a......

Words: 859 - Pages: 4

Devry Bis 155 Week 4 Quiz

...DEVRY BIS 155 Week 4 Quiz IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-4-quiz IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DEVRY BIS 155 Week 4 Quiz Page 1 Question 1.1. (TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2) commas tabs spaces hyphens Question 2.2. (TCO 8) Which of the following is NOT a text file? (Points : 2) Tab-delimited Comma-separated value XML Fixed-width Question 3.3. (TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2) Click the Refresh All command. Save the Excel workbook. Click the Refresh All arrow, then click Refresh. Right-click in a range of data and then select Refresh. Question 4.4. (TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2) File Data Insert Page Layout Question 5.5. (TCO 8) To change the text string jOHndOE to John Doe, use the ________ function. (Points : 2) CONCATENATE PROPER UPPER LOWER Question 6.6. (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2) UPPER LOWER PROPER CONCATENATE Question 7.7. (TCO 8) Which of the following functions does not change......

Words: 790 - Pages: 4

Bis 261 Week 2 Quiz

...BIS 261 Week 2 Quiz Click Link Below To Buy: http://hwcampus.com/shop/bis-261-week-2-quiz/ Part 1 1. (TCO 4) According to research, a major reason why projects fail or are only partially successful is: 2. (TCO 4) The Standish Group's list of reasons why IT projects fail includes all of the following except 3. (TCO 4) Organizing and directing other people to achieve a planned result within a predetermined schedule and budget is a definition of: 4. (TCO 4) By definition, the oversight committee for a project consists of: 5. (TCO 4) By definition, tasks that involve directing other people to achieve a planned result are: 6. (TCO 4) A philosophy of software development that embraces flexibility is described as: 7. (TCO 4) Defining the problem and producing the project schedule are classified as _______ activities. 8. (TCO 4) Improvements that will accrue to a company as a result of a project and its deliverables are known as: 9. (TCO 4) “Do we understand what we are supposed to be working on?” is the key question for which project planning activity? 10. (TCO 4) Which column in a risk analysis matrix provides an assessment of how badly the project will be affected if the risk materializes? Part 2: 1. (TCO 4) The project management area concerned with identifying potential trouble spots in the project is: 2. (TCO 4) Potential shifting of political power due to adoption of a new system may represent a (n) ________________ feasibility risk. 3. (TCO 4) A deadline...

Words: 409 - Pages: 2

Devry Bis 155 Memo Northwind Trades Project

...DeVry BIS 155 Week 2 Quiz - Updated IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-2-quiz-updated IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DeVry BIS 155 Week 2 Quiz 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 containing the formula. Question 2.2. (TCO 2) Which of the following best describes a mixed cell reference? (Points : 2) Occurs when a formula directly or indirectly refers to the cell containing the formula. Causes a potential error. Contains absolute or relative cell references, but not both. Contains both an absolute and a relative cell reference. Question 3.3. (TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2) abstract relative mixed ......

Words: 1008 - Pages: 5

Devry Bis 155 Week 3 Quiz - Updated

...DeVry BIS 155 Week 3 Quiz - Updated IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-3-quiz-updated IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DeVry BIS 155 Week 3 Quiz Page 1 Question 1.1. (TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2) Formatting Freezing Resizing Tiling Question 2.2. (TCO 4) In Excel, a table is defined as _____. (Points : 2) an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis a complete set of data for an entity a Field, which is an individual piece of data an individual piece of data, such as a last name Question 3.3. (TCO 4) To create a table from an existing range of data, _____. (Points : 2) click within the range, click the Table Tools Design tab, and then select Convert to Table select any cell in the worksheet and then click Existing Range in the Tools group click in a cell and on the Home tab, and click the Insert arrow in the Cells group click the Insert tab and then click Table in the Tables group Question 4.4. (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____. (Points : 2) a......

Words: 859 - Pages: 4

Devry Bis 155 Week 4 Quiz

...DEVRY BIS 155 Week 4 Quiz IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-4-quiz IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DEVRY BIS 155 Week 4 Quiz Page 1 Question 1.1. (TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2) commas tabs spaces hyphens Question 2.2. (TCO 8) Which of the following is NOT a text file? (Points : 2) Tab-delimited Comma-separated value XML Fixed-width Question 3.3. (TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2) Click the Refresh All command. Save the Excel workbook. Click the Refresh All arrow, then click Refresh. Right-click in a range of data and then select Refresh. Question 4.4. (TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2) File Data Insert Page Layout Question 5.5. (TCO 8) To change the text string jOHndOE to John Doe, use the ________ function. (Points : 2) CONCATENATE PROPER UPPER LOWER Question 6.6. (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2) UPPER LOWER PROPER CONCATENATE Question 7.7. (TCO 8) Which of the following functions does not change......

Words: 790 - Pages: 4

Devry Bis 155 Week 4 Quiz If You Want to Purchase a+ Work Then Click the Link Below for Instant Down Load Http: //Www.Acehomework.Net/?Download=Devry-Bis-155-Week-4-Quiz If You Face Any Problem Then E Mail Us at

...DEVRY BIS 155 Week 4 Quiz IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.acehomework.net/?download=devry-bis-155-week-4-quiz IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM DEVRY BIS 155 Week 4 Quiz Page 1 Question 1.1. (TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2) commas tabs spaces hyphens Question 2.2. (TCO 8) Which of the following is NOT a text file? (Points : 2) Tab-delimited Comma-separated value XML Fixed-width Question 3.3. (TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2) Click the Refresh All command. Save the Excel workbook. Click the Refresh All arrow, then click Refresh. Right-click in a range of data and then select Refresh. Question 4.4. (TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2) File Data Insert Page Layout Question 5.5. (TCO 8) To change the text string jOHndOE to John Doe, use the ________ function. (Points : 2) CONCATENATE PROPER UPPER LOWER Question 6.6. (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2) UPPER LOWER PROPER CONCATENATE Question 7.7. (TCO 8) Which of the following functions does not change......

Words: 790 - Pages: 4

Bis 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab

...BIS 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab To Buy This material Click below link http://www.uoptutors.com/bis-155/bis-155-week-2-quiz-data-analysis-with-spreadsheets-with-lab (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 containing the formula (TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points : 2) Calculates the total of values contained in two or more cells. Displays a list of functions and defined names as you enter a function. Is an input, such as a cell reference or a value needed to complete a function. Is a small pop-up description that displays the results of the cell. (TCO 2) The MIN function would identify the _____. (Points : 2) The highest value in a range. Tallies the number of blank cells in a range. The lowest value in a range. The midpoint value in a range (TCO 2) The NOW function would perform which of the following? (Points : 2) FIND SEARCH HLOOKUP VLOOKUP (TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2) The periodic interest rate, such as a......

Words: 1309 - Pages: 6

Bis 155 Week 3 Quiz

...hihho1. (TCO 4) In Excel, a dataset would be which of the following? (Points : 2) Indicates where data starts on a new printed page Collection of structured, related data in columns and rows Freezing rows to keep them visible Freezing panes to keep them visible Question 2.2. (TCO 4) In Excel, a table is defined as _____. (Points : 2) an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis a complete set of data for an entity a Field, which is an individual piece of data an individual piece of data, such as a last name Question 3.3. (TCO 4) When sorting in Excel, it arranges records in a table _____. (Points : 2) by the number of pages in the worksheet by the number of pages in the workbook by the value in field(s) within a table by permanently removing extraneous data Question 4.4. (TCO 4) Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of _____. (Points : 2) the use of a table element as a formula a Number Filter a Text Filter a Date Filter Question 5.5. (TCO 4) Which of the following best describes conditional formatting? (Points : 2) Highlights or emphasizes cells that meet certain conditions Tags a table element as a reference in a formula Formats the condition of the worksheet in......

Words: 603 - Pages: 3

Bis 261 Week 2 Quiz

...BIS 261 Week 2 Quiz Click Link Below To Buy: http://hwcampus.com/shop/bis-261-week-2-quiz/ Part 1 1. (TCO 4) According to research, a major reason why projects fail or are only partially successful is: 2. (TCO 4) The Standish Group's list of reasons why IT projects fail includes all of the following except 3. (TCO 4) Organizing and directing other people to achieve a planned result within a predetermined schedule and budget is a definition of: 4. (TCO 4) By definition, the oversight committee for a project consists of: 5. (TCO 4) By definition, tasks that involve directing other people to achieve a planned result are: 6. (TCO 4) A philosophy of software development that embraces flexibility is described as: 7. (TCO 4) Defining the problem and producing the project schedule are classified as _______ activities. 8. (TCO 4) Improvements that will accrue to a company as a result of a project and its deliverables are known as: 9. (TCO 4) “Do we understand what we are supposed to be working on?” is the key question for which project planning activity? 10. (TCO 4) Which column in a risk analysis matrix provides an assessment of how badly the project will be affected if the risk materializes? Part 2: 1. (TCO 4) The project management area concerned with identifying potential trouble spots in the project is: 2. (TCO 4) Potential shifting of political power due to adoption of a new system may represent a (n) ________________ feasibility risk. 3. (TCO 4) A deadline...

Words: 409 - Pages: 2