CO 1) An Output Area (as it applies to Excel 2010) is defined as_______.
a range of cells containing results based upon manipulation of the variables in the input area
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your essay.
Write My Essay For Medisplays 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
Question 2. Question :
(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
Question 3. Question :
(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
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
: 2 of 2
Comments:
Question 6. Question :
(TCO 1) Ribbon Commands with arrows indicate_____.
a shortcut to cell A1
there are two or more sub-commands related to the command
the next step in the process
directionality
Question 7. Question :
(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:
workbook.
ledger.
document.
journal.
:
Question 8. Question :
(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.
Question 9. Question :
(TCO 3) Groups of related numeric values in an Excel worksheet are:
data point.
data roles.
categories.
data series
Question 10. Question :
(TCO 3) Which of the following best describes a column chart?
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
Question 11. Question :
(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
Question 12. Question :
(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.
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) 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
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
Welcome to our trusted essay writing website with track record among students. We specialize in connecting students in need of high-quality essay assistance with skilled writers who can deliver just that. Explore the ratings of our essay writers and choose the one that best aligns with your requirements. When you rely on our online essay writing service, rest assured that you will receive a top-notch, plagiarism-free A-level paper. Our experienced professionals write each paper from scratch, carefully following your instructions. Request a paper from us and experience 100% originality.