BIS 155 WEEK 1 QUIZ EXCEL FUNDAMENTALS AND CHARTING
To Download tutorial
Copy and Paste below Link into your Browser
BIS 155 Week 1 Quiz
Excel Fundamentals and Charting
Week 1 : Excel Fundamentals
and Charting – Quiz
|
1. (TCO
1) Which of the following describes the function of the Formula Bar (as
it applies to Excel 2010)? (Points : 2)
|
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
|
|
2. (TCO 1) Which of the following best describes a cell
address? (Points : 2)
|
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
|
|
3. (TCO 1) If you wanted to insert the current date into
an active cell, which of the following would you use? (Points : 2)
|
F4
Ctrl + Alt + Delete
The Ctrl + D key combination
The Ctrl and semicolon key combination
|
|
4. (TCO 1) In Excel a Formula is _______. (Points : 2)
|
a number that represents a date and can be the basis of
calculations
a combination of cell references, operators, values, and/or functions used
to perform calculations
a number that represents a quantity and can be the basis of calculations
should be used in each column of a workbook
|
|
5. (TCO 1) Which of the following describes the Auto Fill
in Excel 2010? (Points : 2)
|
Enables you to copy the contents of a cell or to
continue a sequence by dragging the fill handle
Is the fastest way to type A1 in the name box
Is adjustable so you can display more or less characters in a column
Helps carry over the fill to the remaining worksheets
|
|
6. (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
|
|
7. (TCO 1) The three types of data that can be entered in
a cell in an Excel worksheet are ________________. (Points : 2)
|
columns, rows, and fields
numbers, fonts, and styles
functions, comments, and macros
text, values, and formulas
|
|
8. (TCO1) In Excel, a border ________. (Points : 2)
|
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
|
|
9. (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
|
|
10. (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. (Points : 2)
|
column chart
pie chart
bar chart
line chart
|
|
11. (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
|
|
12. (TCO 3) To display similar data in a single column,
with each series of data distinguished by a different color, use a:
(Points : 2)
|
stacked column chart.
pie chart.
3-D column chart.
box diagram.
|
|
13. (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.
|
|
14. (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
|
|
15. (TCO 3) Which of the following best describes a
trendline? (Points : 2)
|
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
|
|
Comments
Post a Comment