07 Jun BIS 155 All Quizzes Week 1 – 5………….(BIS 155 Advanced PC Applications with Lab – DeVry)
Posted at 10:14h
in 2General studies
Question
BIS 155 Week 1 Quiz
1. (TCO 1)Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)? (Points : 2)
2.(TCO 1) Which of the following best describes a cell address? (Points : 2)
3.(TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use? (Points : 2)
4.(TCO 1) In Excel a Formula is _______. (Points : 2)
5.(TCO 1) Which of the following describes the Auto Fill in Excel 2010? (Points : 2)
6.(TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)
7.(TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________. (Points : 2)
8.(TCO1) In Excel, a border ________. (Points : 2)
9.(TCO 3) A data series is a group of related ____________. (Points : 2)
10.(TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole. (Points : 2)
11.(TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)
12.(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a: (Points : 2)
13.(TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a: (Points : 2)
14.(TCO 3) Which of the following best describes the X Y (scatter) chart? (Points : 2)
15.(TCO 3) Which of the following best describes a trendline? (Points : 2)
2.(TCO 1) Which of the following best describes a cell address? (Points : 2)
3.(TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use? (Points : 2)
4.(TCO 1) In Excel a Formula is _______. (Points : 2)
5.(TCO 1) Which of the following describes the Auto Fill in Excel 2010? (Points : 2)
6.(TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)
7.(TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________. (Points : 2)
8.(TCO1) In Excel, a border ________. (Points : 2)
9.(TCO 3) A data series is a group of related ____________. (Points : 2)
10.(TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole. (Points : 2)
11.(TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)
12.(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a: (Points : 2)
13.(TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a: (Points : 2)
14.(TCO 3) Which of the following best describes the X Y (scatter) chart? (Points : 2)
15.(TCO 3) Which of the following best describes a trendline? (Points : 2)
BIS 155 Week 2 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)
12. (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)
11. (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, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2)
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)
12. (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)
11. (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, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2)
BIS 155 Week 3 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)
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 an application of _____. (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)
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 changed by using the _____. (Points : 2)
14. (TCO 4) To build a PivotTable and PivotChart at the same time, click the PivotTable arrow and then select _____. (Points : 2)
15. (TCO 4) Which of the following will NOT delete a PivotChart? (Points : 2)
BIS 155 Week 4 Quiz
1. (TCO 8) Which of the following is one of the most common file types imported into Excel? (Points : 2)
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 or ________ width. (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 Recipients menu while performing the merge. (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 author name or keywords that have been entered into ________. (Points : 2)
14.(TCO 8) Which function is similar to the Find and Replace feature? (Points : 2)
15. (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password. (Points : 2)
15. (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password. (Points : 2)
BIS 155 Week 5 Quiz
1. (TCO 5) When multiple worksheets are selected, the word ________ appears in the title bar. (Points : 2)
1. (TCO 5) When multiple worksheets are selected, the word ________ appears in the title bar. (Points : 2)
2. (TCO 5)In Excel, which of the following would you perform to group adjacent worksheets? (Points : 2)
3.(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window. (Points : 2)
4.(TCO 5)After saving the arrangement of windows, a workbook can be opened by opening the ________ file. (Points : 2)
5.(TCO 5) Which of the following functions do NOT work with 3D formulas? (Points : 2)
6.(TCO 5)Excel’s ability to manage worksheets allows you to do all EXCEPT: (Points : 2)
7.(TCO 5)If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)? (Points : 2)
8.(TCO 6) In a what-if analysis of a car purchase, the original interest rates of 6% and 5%, 5.5% and 6.5% are the ________ values. (Points : 2)
9.(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments? (Points : 2)
10.(TCO 6) After entering the substitution values and the reference to a formula, the next step to complete a two-variable data table and view the results is to: (Points : 2)
11.(TCO 6)The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)
12.(TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? (Points : 2)
13.(TCO 6)Which of the following is NOT one of the three parameters in Solver? (Points : 2)
14.(TCO 6)Which of the following is NOT required for Solver to generate a solution? (Points : 2)
15.(TCO 6) The initial results of a Goal Seek are: (Points : 2)
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.