BIS 155 Week 1 Quiz (New)

Order ready-to-submit essays. No Plagiarism Guarantee!

Note:  All our papers are written from scratch by human writers to ensure authenticity and originality.

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.