Devry BIS 155 ALL Quiz Latest

Description

Devry BIS 155 ALL Quiz Latest

 

Devry BIS 155 Quiz 1 Latest

 

Question 1. Question : (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)?

Student Answer: Displays the name of a worksheet within a workbook

Is at the intersection of a column and a row

Identifies the address of the current cell

Displays the content of the active cell

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 2. Question : (TCO 1) In Excel 2010, a sheet tab ________.

Student Answer: displays the content of the active cell

conceals the applicable formulas for the workbook

identifies the address of the current cell

displays the name of a worksheet within a workbook

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 3. Question : (TCO 1) Which of the following best describes the AutoComplete function?

Student Answer: Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 4. Question : (TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?

Student Answer: Includes letters, numbers, and spaces

Controls the sequence in which Excel performs arithmetic operations

Is a software application used to create and modify business communications

Includes formulas, functions, and formatting

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 5. Question : (TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?

Student Answer: Cannot complete a sequence of dates in a column

Changes the background color of the selected cells to yellow

Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula

Has two or more sub-commands related to the command

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 6. Question : (TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?

Student Answer: Just type longer or taller formulas in some of them

Click and drag across the cells to select them and use any sizing method you choose

Drag the fill handle across the cells

Type A1 in the “Go To” dialog box

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 7. Question : (TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a:

Student Answer: workbook.

ledger.

document.

journal.

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 8. Question : (TCO1) In Excel, a border ________.

Student Answer: is data from another cell that is only temporarily residing in the active cell

is a line that surrounds a cell or a range of cells

never prints

is preset and weight cannot be adjusted

Instructor Explanation: Textbook Chapter 1

Points Received: 2 of 2

Comments:

Question 9. Question : (TCO 3) A chart can be defined as ________.

Student Answer: a group of related data points

a visual representation of numerical data

a numeric value that describes a single value on a chart

text that describes a collection of data points in a chart

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 10. Question : (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.

Student Answer: column chart

pie chart

bar chart

line chart

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 11. Question : (TCO 3) When creating a chart in Excel, a single data series _____.

Student Answer: compares values for one set of data

groups or clusters similar data in columns to compare values across categories

is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

compares two or more sets of data in one chart

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 12. Question : (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:

Student Answer: stacked column chart.

pie chart.

3-D column chart.

box diagram.

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 13. Question : (TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart.

Student Answer: expanded

exploded

displaced

clustered

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 14. Question : (TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs:

Student Answer: Design, Layout, and Format.

Home, Insert, and Page Layout.

Chart, Type, and Formulas.

Data, Review, and Data.

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

Question 15. Question : (TCO 3) Which of the following best describes a trendline?

Student Answer: A line used to depict trends and forecast future data

Text that describes a collection of data points in a chart

A group of related data points

Displays data comparisons vertically in columns

Instructor Explanation: Textbook Chapter 3

Points Received: 2 of 2

Comments:

 

Devry BIS 155 Quiz 2 Latest

 

Grade Details – All Questions

Question 1. Question : (TCO 2) A formula in Excel begins with a(n):

Student Answer: *.

$.

=.

/.

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

Question 2. Question : (TCO 2) In Excel, a function can be defined as a _____.

Student Answer: predefined formula that performs a calculation

cell reference or a value

list of values and defined names as you enter data into a spreadsheet

set of rules that govern the structure and components for a formula

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

Question 3. Question : (TCO 2) =$E2-G$4 contains examples of _____ cell references.

Student Answer:

Question 4. Question : (TCO 2) In Excel, an Argument would be best described by which of the following statements?

Student Answer: 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.

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

Question 5. Question : (TCO 2) The _____ function returns a result based on a condition.

Student Answer:

Instructor Explanation:

Question 6. Question : (TCO 2) Which of the following best describes the COUNT function?

Student Answer:

Question 7. Question : (TCO 2) The NOW function would perform which of the following?

Student Answer

Question 8. Question : (TCO 2) If you enter an = and the first few letters of a function in the formula bar, Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.

Student Answer:

Question 9. Question : (TCO 2) Which of the following best describes the HLOOKUP function?

Student Answer:

Question 10. Question : (TCO 2) To simplify entering ranges in formulas, you can use _____.

Student Answer:

Question 11. Question : (TCO 2) The PMT function is best described by which of the following?

Student Answer:

Question 12. Question : (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.

Student Answer

Question 13. Question : (TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.

Student Answer:

Question 14. Question : (TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.

Student Answer

Question 15. Question : (TCO 7) Users must click _____ Content to use the workbook and run the macros in the workbook.

Student Answer:

Devry BIS 155 Quiz 3 Latest

Grading Summary

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: 7/26/2015

Time Spent: 26 min , 08 secs

Points Received: 28 / 30 (93.3%)

Question Type: # Of Questions: # Correct:

Multiple Choice 15 14

Grade Details – All Questions

Question 1. Question : (TCO 4) In Excel, a dataset would be which of the following?

Student Answer:

Comments:

Question 2. Question : (TCO 4) Which of the following best describes a page break?

Student Answer:

Question 3. Question : (TCO 4) To create a table from an existing range of data, _____.

Student Answer:

Comments:

Question 4. Question : (TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.

Student Answer:

Comments:

Question 5. Question : (TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.

Student Answer:

Points Received: 2 of 2

Comments:

Question 6. Question : (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____.

Student Answer:

Question 7. Question : (TCO 4) When data is grouped, the margin area displays the _____.

Student Answer:

Comments:

Question 8. Question : (TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group.

Student Answer:

Question 9. Question : (TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?

Student Answer:

Comments:

Question 10. Question : (TCO 4) A faster way to expand all categories at one time is to click _____.

Student Answer:

Points Received: 2 of 2

Comments:

Question 11. Question : (TCO 4) Data displayed in the PivotTable will be updated _____.

Student Answer:

Points Received: 2 of 2

Comments:

Question 12. Question : (TCO 4) What are the areas of a PivotTable Report where fields can be placed?

Comments:

Question 13. Question : (TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.

Question 14. Question : (TCO 4) Click the _____ to sort or filter the chart representation based on the values.

Comments:

Question 15. Question : (TCO 4) Pivot Charts look best when they use basic charts, such as a _____.

Devry BIS 155 Quiz 4 Latest

Grading Summary

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: Time Spent: 59 min , 18 secs

Points Received: 28 / 30 (93.3%)

Question Type: # Of Questions: # Correct:

Multiple Choice 15 14

Grade Details – All Questions

Question 1. Question : (TCO 8) Which of the following is one of the most common file types imported into Excel?

Student Answer:

Question 2. Question : (TCO 8) Which of the following is NOT a text file?

Student Answer:

Question 3. Question : (TCO 8) Which of the following is NOT a method for refreshing data?

Student Answer:

Comments:

Question 4. Question : (TCO 8) Text to Columns command splits text in one column into separate ________.

Student Answer:

Comments:

Question 5. Question : (TCO 8) Which of the following is an example of a text string?

Student Answer:

Comments:

Question 6. Question : (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.

Student

Comments:

Question 7. Question : (TCO 8) Which of the following will produce the same result as the CONCATENATE function?

Student Answer: =

Points Received: 2 of 2

Comments:

Question 8. Question : (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon.

Student Answer:

Comments:

Question 9. Question : (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?

Student Answer:

Comments:

Question 10. Question : (TCO 8) If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need:

Student Answer:

Points Received: 2 of 2

Comments:

Question 11. Question : (TCO 8) The ________ command displays all comments in the entire workbook.

Student Answer:

:

Question 12. Question : (TCO 8) An Excel file saved as a .pdf does all the following EXCEPT:

Student Answer:

Question 13. Question : (TCO 8) The ________ command displays additional document properties such as Company.

Student Answer:

Question 14. Question : (TCO 8) Which function is similar to the Find and Replace feature?

Student Answer:

Comments:

Question 15. Question : (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.

Student Answer:

Devry BIS 155 Quiz 5 Latest

Grading Summary

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: Time Spent: 13 min , 35 secs

Points Received:

Question Type: # Of Questions: # Correct:

Multiple Choice 15 15

Grade Details – All Questions

Question 1. Question : (TCO 5) The tabs of grouped worksheets are displayed with a ________ background.

Question 2. Question : (TCO5) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets:

Student Answer:

Comments:

Question 3. Question : (TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window.

Student

Question 4. Question : (TCO 5) In Excel, which of the following is NOT a method for removing a split window?

Student Answer: Drag a split bar to the edge of the worksheet.

Double-click a split bar.

Click Split in the Window group on the View tab.

Right-click in the active cell and click Remove.

Instructor Explanation: Textbook Chapter 8

Points Received: 2 of 2

Comments:

Question 5. Question : (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?

Student Answer:

Question 6. Question : (TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT:

Student Answer:

Question 7. Question : (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)?

Student Answer:

Question 8. Question : (TCO 6) When creating a range for the substitution values in a one-variable data table, it is best to arrange them in a(n) ________ orientation.

Student Answer:

Question 9. Question : (TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?

Student Answer:

Question 10. Question : (TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?

Student Answer:

Question 11. Question : (TCO 6) The value you want to achieve in Goal Seek needs to be entered in the ________ box in the Goal Seek dialog box.

Student Answer:

Question 12. Question : (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

Student Answer:

Question 13. Question : (TCO 6) Which of the following is NOT one of the three parameters in Solver?

Student Answer:

Question 14. Question : (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?

Student Answer:

Question 15. Question : (TCO 6) The maximum number of scenarios Scenario Manager can handle is:

Student Answer:

 

DeVry Courses helps in providing the best essay writing service. If you need 100% original papers for Devry BIS 155 ALL Quiz Latest, then contact us through call or live chat.

Devry BIS 155 ALL Quiz Latest