# Devry BIS 155 Quiz 1 Latest

\$16

## 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

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

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

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

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

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

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

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:

ledger.

document.

journal.

Instructor Explanation: Textbook Chapter 1

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

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

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.

pie chart

bar chart

line chart

Instructor Explanation: Textbook Chapter 3

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

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:

pie chart.

3-D column chart.

box diagram.

Instructor Explanation: Textbook Chapter 3

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

exploded

displaced

clustered

Instructor Explanation: Textbook Chapter 3

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

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

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

Devry BIS 155 Quiz 1 Latest

## Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.