BIS155 Quiz Week 1

$5.00

BIS155 Quiz Week 1
(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color…

Description

BIS155 Quiz Week 1

BIS155 Quiz Week 1

A+

(TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)

A range of cells containing results based upon manipulation of the variables in the input area

Displays the name of a worksheet within a workbook

A range of cells containing values for variables used in formulas

Displays the content of the active cell

(TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)

Must have formulas entered into it

Cannot be used for labels or headings

Must have text entered into it

Is the intersection of a column and a row

(TCO 1) In Excel 2010, a column width ________. (Points : 2)
is adjustable so you can display more or less characters in a columnis not adjustable so keep the formulas as short as possible

always switches back to default

is best left unchanged unless you absolutely have to

(TCO 1) Which of the following best describes a “Range” in Excel 2010? (Points : 2)

Cannot be selected with the mouse

Are the numbers that fall between the smallest and largest in the formula

Is another word for the active worksheet

Refers to a group of adjacent or contiguous cells

(TCO 1) The fill handle in Excel 2010 _______. (Points : 2)
is the fastest way to type A1 in the name box

helps carry over the fill to the remaining slides

is the same action as pressing “Enter”

is a small black square at the bottom-right corner of a cell that facilitates fill operations

(TCO 1) Which of the following best describes the AutoComplete function? (Points : 2)

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

(TCO 1) Why would you use cell references in formulas instead of constant values? (Points : 2)

You can easily include letters, numbers, and spaces

It is easier to debug the errors

You can change the input values without changing the formulas

You can control the sequence in which Excel performs arithmetic operations

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

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

(TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)

A shortcut to cell A1

There are two or more sub-commands related to the command

The next step in the process

Directionality

(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: (Points : 2)

Workbook.

Ledger

Document

Journal

(TCO 1) Which of the following describes the horizontal Alignment in Excel 2010? (Points : 2)

Refers to the up-down position of contents in a cell

Removes the vertical lines running through the data

Puts a line horizontally through the data

Refers to the left-right position of contents in a cell

(TCO 3) A data series is a group of related ____________. (Points : 2)

Charts on a worksheet

Category labels on a horizontal axis

Data points on a chart

Numerical values on a vertical axis

(TCO 3) Which of the following best describes a column chart? (Points : 2)

Displays data comparisons vertically in columns

A horizontal line that borders the plot area to provide a frame of reference for measurement

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

(TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _________. (Points : 2)

line chart

bar chart

pie chart

doughnut chart

(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)

diagram.

pop-up comment box.

legend.

note.

(TCO 3) Which of the following best describes the X Y (scatter) chart? (Points : 2)

Shows values as percentages of the whole but may contain more than one data series

Shows the high, low, and close prices for individual stocks over time

Shows trends using two dimensions on a continuous curve

Shows a relationship between two variables

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

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

(TCO 3) When creating a chart in Excel, a multiple data series _______. (Points : 2)

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

Compares two or more sets of data in one chart

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

Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color

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

Expanded

Exploded

Displaced

Clustered

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

Design, Layout, and Format

Home, Insert, and Page Layout

Chart, Type, and Formulas

Data, Review, and Data

(TCO 3) Which of the following best describes a sparkline? (Points : 2)

A label that describes either the category axis or the value axis

A miniature chart contained in a single cell

The value or name of a data point

A label that describes the chart

BIS155 Quiz Week 1

(TCO 1) Which of the following best describes a cell address?

Identifies the electronic “neighborhood” of a spreadsheet

Identifies a cell by a column letter and a row number

Searches for and displays similar labels as you type

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

(TCO 1) Which of the following best describes the AutoComplete function?

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

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

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

(TCO 1) When you paste copied data, Excel displays the Paste Options button:

In the status bar at the left of the screen

In the next set of nonadjacent ranges

On the toolbar

In the bottom right corner of the pasted data

(TCO 3) Groups of related numeric values in an Excel worksheet are:

Data point

Data roles

Categories

Data series

(TCO 3) Which of the following best describes the chart area?

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

A vertical line that borders the plot area to provide a frame of reference for measurement

A horizontal line that borders the plot area to provide a frame of reference for measurement

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

Stacked column chart

Pie chart

3-D column chart

Box diagram

(TCO 3) In Excel, an area chart _______

Shows the high, low, and close prices for individual stocks over time

Trends using two dimensions on a continuous curve

Emphasizes the magnitude of changes over time by filling in the space between lines with a color

Shows a relationship between two variables

(TCO 3) After creating a chart, you can change the chart type by using _____.

Page Layout tab / Chart Options button

Design tab / Change Chart Type button

Data tab / Chart Changer tool

You cannot change the chart

BIS155 Quiz Week 1