BIS 155 All Quizzes Week 1 - 5

Hochgeladen von

Beschreibung:

BIS 155 All Quizzes Week 1 – 5
Purchase here
https://sellfy.com/p/z1ib
Product Description
Week 11. (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)
Week 21. (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)
Week 31. (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 i

Stufen Sie dieses Dokument als nützlich ein?

Sind diese Inhalte unangemessen?

Beschreibung:

BIS 155 All Quizzes Week 1 – 5
Purchase here
https://sellfy.com/p/z1ib
Product Description
Week 11. (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)
Week 21. (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)
Week 31. (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 i

BIS 155 All Quizzes Week 1 - 5

Hochgeladen von

Beschreibung:

BIS 155 All Quizzes Week 1 – 5
Purchase here
https://sellfy.com/p/z1ib
Product Description
Week 11. (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)
Week 21. (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)
Week 31. (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 i

BIS 155 All Quizzes Week 1 5

Purchase here

https://sellfy.com/p/z1ib

Product Description

Week 11. (TCO 1) Which of the following

describes the function of the Formula Bar (as itapplies to Excel 2010)? (Points : 2)2. (TCO 1) Which of the following best describes acell address? (Points : 2)3. (TCO 1) If you wanted to insert the current dateinto an active cell, which of the following wouldyou use? (Points : 2)

4. (TCO 1) In Excel a Formula is _______. (Points

: 2)5. (TCO 1) Which of the following describes theAuto Fill in Excel 2010? (Points : 2)6. (TCO 1) Ribbon Commands with arrowsindicate_____. (Points : 2)7. (TCO 1) The three types of data that can beentered 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 mosteffective way to display proportional relationships,such as market share data, where the individualdata values represent parts of a whole. (Points :2)11. (TCO 3) When creating a chart in Excel, asingle 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 anexplanation of the representations of the colorsutilized in the data series in your chart, provide a:(Points : 2)14. (TCO 3) Which of the following best describesthe X Y (scatter) chart? (Points : 2)15. (TCO 3) Which of the following best describesa trendline? (Points : 2)Week 21. (TCO 2) An absolute cell reference:(Points : 2)2. (TCO 2) Which of the following best describes acircular 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 bestdescribed 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 performwhich of the following? (Points:2)8. (TCO 2) The _____ number is the number ofthe column in the lookup table that contains thereturn 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 informulas, you can use _____. (Points : 2)12. (TCO 7) A _____ helps to ensure consistencyand standardization for similar workbooks, suchas detailed income statements for all 12 months ina year. (Points : 2)11. (TCO 2) When calculating a PMT function, thePV 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 canstore macros? (Points : 2)15. (TCO 7) By default, Excel automatically _____macros and displays a security warning when afile containing macros is opened. (Points : 2)Week 31. (TCO 4) If there are certain columns ofinformation that are not needed at a particulartime but might be needed later, _____ theunneeded columns to allow users to focus on onlythe essential information. (Points : 2) 2. (TCO 4) InExcel, the print area is defined as _____. (Points :2) 3. (TCO 4) When sorting in Excel, it arrangesrecords in a table _____. (Points : 2) 4. (TCO4) Filtering the Cost column (field) to show onlyrecords greater than $10,000 is an application of_____. (Points : 2) 5. (TCO 4) To create a newConditional 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 isgrouped, the margin area displays the _____.(Points : 2) 8. (TCO 4) A _____ allows you toidentify relationships between variables in yourdata. (Points : 2) 9. (TCO 4) Data miningtechniques such as PivotTables can detect _____of data. (Points : 2) 10. (TCO 4) A faster way toexpand all categories at one time is to click_____. (Points : 2)11. (TCO 4) Data displayed in the PivotTable willbe updated _____. (Points : 2) 12. (TCO 4) Aquick way to display the Go to dialog box is topress the _____ key(s). (Points : 2) 13. (TCO4) After a PivotChart has been created, thePivotTable Settings can still be changed by usingthe _____. (Points : 2) 14. (TCO 4) To build aPivotTable and PivotChart at the same time, clickthe PivotTable arrow and then select _____.(Points : 2)15. (TCO 4) Which of the following willNOT delete a PivotChart? (Points : 2)

Week 41. (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 isNOT a text file? (Points : 2) 3. (TCO 8) Which ofthe following is NOT a method for refreshing data?(Points : 2) 4. (TCO 8) The Convert Text toColumns Wizard allows you to choose the filetype, such as Delimited or ________ width.(Points : 2) 5. (TCO 8) Which of the following is afrequently used function to manipulate txt? (Points: 2) 6. (TCO 8) To change the text string Jack Doeto JACK DOE, use the ________ function. (Points: 2) 7. (TCO 8) Which of the following cannot beused in a CONCATENATE function? (Points : 2) 8.(TCO 8) If you want to send a letter to all yourcustomers using Mail Merge, and you alreadyhave the customers' names and addresses storedin an Excel file, you should choose _________from the Select Recipients menu while performingthe merge. (Points : 2) 9. (TCO 8) The NewComment 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 islocated on the ________ tab. (Points : 2) 12.(TCO 8) The command to send an Excelworkbook by e-mail is located on the ________tab. (Points : 2) 13. (TCO 8) Windows can searchfor files by author name or keywords that havebeen entered into ________. (Points : 2) 14. (TCO8) Which function is similar to the Find andReplace feature? (Points : 2)15. (TCO 8) To encrypt a workbook with apassword, click Info on the File tab, click________, and then select Encrypt withPassword. (Points : 2)Week 51. (TCO 5) When multiple worksheets areselected, the word ________ appears in the titlebar. (Points : 2) 2. (TCO 5) In Excel, which of thefollowing would you perform to group adjacentworksheets? (Points : 2) 3. (TCO 5) When twowindows of the same workbook are opened, Excel

adds ________ to the title bar of the second

window. (Points : 2) 4. (TCO 5) After saving thearrangement of windows, a workbook can beopened by opening the ________ file. (Points :2) 5. (TCO 5) Which of the following functions doNOT work with 3D formulas? (Points : 2) 6. (TCO5) Excel's ability to manage worksheets allowsyou to do all EXCEPT: (Points : 2) 7. (TCO 5) If A1contains the hourly pay rate of $10.25, A2contains 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 acar purchase, the original interest rates of 6% and5%, 5.5% and 6.5% are the ________ values.(Points : 2) 9. (TCO 6) Which What-If Analysis toolwould be best at comparing the combined effectsof various interest rates and down payments?(Points : 2) 10. (TCO 6) After entering thesubstitution values and the reference to a formula,the next step to complete a two-variable data tableand 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 inthe What-If Analysis command in the Data Toolsgroup on the Data tab? (Points : 2) 13. (TCO6) Which of the following is NOT one of the threeparameters in Solver? (Points : 2) 14. (TCO6) Which of the following is NOT required forSolver to generate a solution? (Points :2) 15. (TCO 6) The initial results of a Goal Seekare: (Points : 2)