BIS 155 WEEK 1 QUIZ EXCEL FUNDAMENTALS AND CHARTING

BIS 155 WEEK 1 QUIZ EXCEL FUNDAMENTALS AND CHARTING

To Download tutorial Copy and Paste below Link into your Browser

for any inquiry email us at  ( essayblue@gmail.com )

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

Popular posts from this blog

BIO 365S HOMEWORK 3 RESPIRATORY

ASSIGNMENT 3: POWERPOINT PRESENTATION

ASSIGNMENT 3: LEADERSHIP OF RICHARD BRANSON