BIS 155 Week 1 Quiz NEW

Question 1. Question : (TCO 1) An Input Area (as it applies to Excel 2013) is defined as_____.

a range of cells containing results based on the output area
displays the name of a worksheet within a workbook
a range of cells containing values for variables used in formulas

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

Must have formulas entered into it
Cannot be used for labels or headings
Must have text entered into it

Question 3. Question : (TCO 1) Which of the following best describes the active cell?

Is where all the functions of the database perform the calculations
Is the cell that always holds the current date
Is the location of the insertion point as indicated by a dark border
Is where all the formulas of the workbook do the math

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

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

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

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?

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.

Question 7. Question : (TCO 1) Which of the following best describes a range in Excel 2013?

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

Question 8. Question : (TCO 1) In Excel, a border _.

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

Question 9. Question : (TCO 3) A data series is a group of related _.

charts on a worksheet
category labels on a horizontal axis
data points on a chart
numerical values on a vertical axis

Question 10. Question : (TCO 3) Which best describes a data point?

A numeric value that describes a single value on a chart
A group of related data points
Displays data comparisons vertically in columns
Text that describes a collection of data points in a chart

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

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

Question 12. Question : (TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _.

line chart
bar chart
pie chart
doughnut chart

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

expanded
exploded
displaced
clustered

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

Design, Layout, and Format.
Home, Insert, and Page Layout.
Chart, Type, and Formulas.
Data, Review, and Data.

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