BIS 155 ALL QUIZZES WEEK 1 – 5
Follow below link to get this tutorial:
Contact us at:
BIS 155 ALL QUIZZES WEEK 1 – 5
Week 1
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)
Week 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)
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 3
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)
Week 4
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)
Week 5
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)
No comments:
Post a Comment