The writer is very fast, professional and responded to the review request fast also. Thank you.
Book/movie review
22/08/2022
Week 1 Quiz
1.Question :(TCO 1) An Input Area (as it applies to Excel 2010) is defined as______.
Student Answer: 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
displays the content of the active cell
Question 2.Question :(TCO 1) In Excel 2010, a cell is best described by which of the following?
Student Answer: Must have formulas entered into it
Cannot be used for labels or headings
Must have text entered into it
Is the intersection of a column and a row
Question 3.Question :(TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use?
Student Answer: F4
Ctrl + Alt + Delete
The Ctrl + D key combination
The Ctrl and semicolon key combination
Question 4.Question :(TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?
Student Answer: 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?
Student Answer: 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?
Student Answer: 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) The three types of data that can be entered in a cell in an Excel worksheet are ________________.
Student Answer: columns, rows, and fields
numbers, fonts, and styles
functions, comments, and macros
text, values, and formulas
Question 8.Question :(TCO 1) When you paste copied data, Excel displays the Paste Options button:
Student Answer: 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) A data series is a group of related ____________.
Student Answer: 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?
Student Answer: 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, the plot area ________.
Student Answer: contains graphical representation of values in data series
is a vertical line that borders the plot area to provide a frame of reference for measurement
is a horizontal line that borders the plot area to provide a frame of reference for measurement
provides descriptive group names for subdividing the data series
Question 12.Question :(TCO 3) When creating a chart in Excel, a multiple data series _______.
Student Answer: groups or clusters similar data in columns to compare values across categories
compares two or more sets of data in one chart
is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart
places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color
Question 13.Question :(TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart.
Student Answer: expanded
exploded
displaced
clustered
Question 14.Question :(TCO 3) In Excel, an area chart _______.
Student Answer: 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) Which of the following best describes a trendline?
Student Answer: 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
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more