Devry Bis 155 Week 4 Quiz

In: Other Topics

Submitted By mysinvedi
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 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 the case or capitalization of text? (Points : 2) PROPER CAPS UPPER LOWER

Question 8.8. (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon. (Points : 2) Merge Mailings Home Review

Question 9.9. (TCO 8) The New Comment command is located on the ________…...

Similar Documents

Bis 155 Week 4 : Office Integration and Mail Merge – Quiz

...BIS 155 Week 4 : Office Integration and Mail Merge – Quiz http://homeworkfy.com/downloads/bis-155-week-4-office-integration-and-mail-merge-quiz/ BIS 155 Week 4 : Office Integration and Mail Merge – Quiz 1. (TCO 8) Which of the following is one of the most common file types imported into Excel? (Points : 2) 2. (TCO 8) Which of the following is NOT a text file? (Points : 2) 3. (TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2) 4. (TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited____(Points:2) 5. (TCO 8) Which of the following is a frequently used function to manipulate txt? (Points : 2) 6. (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2) 7. (TCO 8) Which of the following cannot be used in a CONCATENATE function? (Points : 2) 8. (TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select……. (Points : 2) 9. (TCO 8) The New Comment command is located on the ________ tab. (Points : 2) 10. (TCO 8) An alternative method for inserting a comment in a cell includes: (Points : 2) 11. (TCO 8) The command to track changes is located on the ________ tab. (Points : 2) 12. (TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab. (Points:2) 13. (TCO 8) Windows can search for files by......

Words: 326 - Pages: 2

Bis 155 Week 8 Final Exam Answers – Devry

...BIS 155 Week 8 Final Exam Answers – Devry http://homeworkfy.com/downloads/bis-155-week-8-final-exam-answers-devry/ BIS 155 Week 8 Final Exam Answers – Devry 1. (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 weekly payroll for “15” employees with the following assumptions:……. (Points : 40) 2. (TCO 3) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state. Each parts supply store carries inventory in four categories. You have been presented with the sales figures for the last three years for each location and inventory category by store. Based on this information, you’re tasked with analyzing current sales for each store by category and overall total sales by store and category….. (Points : 40) 3. (TCO 4) You are given a spreadsheet with daily sales numbers ordered by date from January 1st to December 31st. You have been tasked with finding the average sales of each month, then to reorder the months so they are listed in order from highest to lowest average sales. Give a step-by-step explanation of how you will rearrange the data so you can analyze the best and worst months….. (Points : 40) 4. (TCO 5) You’ve just joined the staff of the XYZ Manufacturing......

Words: 473 - 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

Bis 155 Entire Course Devry

...BIS 155 ENTIRE COURSE DEVRY To purchase this visit here: http://www.activitymode.com/product/bis-155-entire-course-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 ENTIRE COURSE (DQS - QUIZES - LABS & COURSE PROJECT) DEVRY Week 1 discussion Getting Familiar with Excel (graded) Excel was introduced in 1985. Since then, it has become a standard business tool. In this thread, discuss the different features of Excel that make it a valuable business tool. In addition, discuss why Excel skills are so important in today’s job market. week 2 FORMULAS AND FUNCTIONS (GRADED) One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.  You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.  You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50.  You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due. Please feel free to add other, unique mathematical......

Words: 7326 - Pages: 30

Bsop 330 Week 4 Quiz Devry

...BSOP 330 WEEK 4 QUIZ DEVRY To purchase this visit here: http://www.activitymode.com/product/bsop-330-week-4-quiz-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BSOP 330 WEEK 4 QUIZ DEVRY BSOP 330 Week 4 Quiz Activity mode aims to provide quality study notes and tutorials to the students of BSOP 330 Week 4 Quiz DeVry in order to ace their studies. Activity mode , BSOP 330 Week 4 Quiz DeVry, Home Work Tutorials, Home Work Solutions, Home Work Essay, Home Work Questions.ACC 565 Wk 7 Assignment 3, ACC403 week 2 assignment, ACC565 Week 10, ACCT 212 (Financial Accounting), ACCT 344 (Entire Course) - Devry, ACCT 344 Final Exam Latest 2014 - Devry, ACCT 346 (Managerial Accounting), ACCT 346 Midterm Exam Updated DeVry, ACCT 504, ACCT 504 Week 8, ACCT 553, ART 101 Week 8, Ashford BUS 401, ASHFORD BUS 640, Ashford HIS 204, ASHFORD MAT 222 Week 3, BA 215 (Business Statistics), BA 215 All Assignments Week 1 -8 - Grantham, BA 225, BA 260, BA 265 (Business Law II), BA 265 (Business Law II) FINAL EXAM, BA 340 All Course Assignments, BA 340 Human Resource, BA 370 (Employment Law), BA 405 Multinational Management, BA 470 Week 3 - 5 - 6 - 7, BA 470 Entrepreneurship, BA350 Principles Of Finance, BIS 155 Final Exam - DeVry, BIS 220 Final Exam, BSOP 429, BSOP 434 Entire Course - Devry, BUS 303 Week 2, BUS 303 Week 3, BUS 303 Week 5, BUS 311 Business Law, BUS 330 Week 1, BUS 330 Week 3, BUS 330 Week 5, BUS 401 Week 4 DQ 1, BUS 401 Week 4 DQ 2, BUS 402 WEEK 4, BUS 405 (Principles of......

Words: 1245 - Pages: 5

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

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

Bis 261 Week 4 Quiz

...BIS 261 Week 4 Quiz Click Link Below To Buy: http://hwcampus.com/shop/bis-261-week-4-quiz/ 1. (TCO 1) A facilitator uses knowledge of _____ to formulate and deliver the needed structure for effective meeting interactions. 2. (TCO 1) The primary focus of the facilitator's role is on: 3. (TCO 1) A key difference between a team and a group is that: 4. (TCO 1) A well-facilitated team meeting is generally: 5. (TCO 1) The content of a meeting refers to: 6. (TCO 1) Typical elements included in a charter or purpose statement are: 7. (TCO 1) The agenda defines: 8. (TCO 1) At the beginning of a meeting, the facilitator should 9. (TCO 1) A process intervention is: 10. (TCO 1) If Alice is the only member who is interrupting or starting side conversations while Bob is presenting, the recommended intervention is to: Part 2: 1. (TCO 1) If the group discussion tends to veer away from the main agenda items into talking about less important side issues, the first recommended intervention is to: 2. (TCO 1) If Alice begins to recount a familiar personal "war story" that everyone has heard before, the first recommended intervention is to: 3. (TCO 1) A facilitator should, as a last resort, invite a group member to bow out of a meeting when: 4. (TCO 1) One recommended facilitation strategy to encourage members to return from breaks on time is to: 5. (TCO 1) A recorder or scribe who keeps track of running memory using a computer-based tool is sometimes called: 6.(TCO 1) One...

Words: 351 - Pages: 2

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 4 Quiz Data Analysis with Spreadsheets with Lab

...BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab To Buy This material Click below link http://www.uoptutors.com/bis-155/bis-155-week-4-quiz-data-analysis-with-spreadsheets-with-lab (TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2) Commas Tabs Spaces Hyphens (TCO 8) The ________ group on the Data tab contains tools to help you manage your external data connections. (Points : 2) Get External Data Data Tools Analysis Connections (TCO 8) Which of the following is an example of a text string? (Points : 2) =B5*B7 =SUM(A5:A10) =IF(B3>B4, B3) John Doe (TCO 8) To change the text string JANE doe to jane doe, use the ________ function. (Points : 2) CONCATENATE PROPER UPPER LOWER (TCO 8) When the data source you select for a mail merge is an Excel workbook that has more than one worksheet, what does Word do? (Points : 2) Automatically uses the data from the first worksheet in the workbook. Automatically uses the data from the last worksheet in the workbook. Displays a list of the worksheet names and lets you pick which one to use. Displays an error message and is unable to continue. (TCO 8) An alternative method for inserting a comment in a cell includes: (Points : 2) typing the comment into the cell and then clicking New Comment. right-click the cell and choose Insert Comment. left-click the cell and choose Insert Comment. clicking paste on the Home tab after typing in the comment. (TCO 8) An Excel file saved as a......

Words: 1032 - Pages: 5

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