The ____ function can be used to calculate the payment schedule required to completely repay a mortgage or other type of loan
answer
PMT
question
_________ is the amount of money being loaned?
answer
Principle
question
Each chart must have a(n) _________.
answer
data source
question
Which chart compares relative values of different categories to the whole?
answer
Pie Chart
question
What is a chart style?
answer
A chart style is similar to a cell style or a table style in that it formats several chart elements at one time. You can change the color and appearance of the slices by selecting a different chart style from the Chart Styles gallery on the Chart Tools Design tab
question
The ____ provides a description of the chart
answer
chart title
question
A pie slice is an ample of a _______.
answer
data marker
question
The color of pie slices can be changed.
answer
True
question
The ____ specifies the worksheet cells that contain the data on which the chart will be based.
answer
chart options
question
One type of what-if analysis that limits the data to a subset of the original values is a process called _______.
answer
filtering
question
Excel uses _______ to slow down the effect of changing data source values, making it easier to see how changing one value affects the chart.
answer
chart animation
question
A column chart turned on its side is called a(n) _______.
answer
bar chart
question
The process for creating a column chart is the same as for creating a pie chart.
answer
True
question
What is a line chart?
answer
A line chart compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.
question
A pie chart compares relative values of different categories to the whole.
answer
True
question
An exploded pie chart moves one slice away from the pie as if someone were taking the piece out of the pie.
answer
True
question
Leader lines can be added to labels placed outside the slices to connect them to their corresponding slices.
answer
True
question
Charts remain linked or connected to their data sources, even if they appear in different worksheets.
answer
True
question
If you change any values or labels in the data source, the chart must be manually updated to show the new content.
answer
False
question
The _____, or value, axis displays the values associated with the heights of each column.
answer
Vertical
question
The _____, or category, axis displays the categories associated with each data value.
answer
horizontal
question
A bar chart compares values from different categories.
answer
True
question
An _______ chart element floats in the chart area and is not fixed to a particular position.
answer
overlaid
question
A line chart is often used to show trends and changes over time.
answer
True
question
A line chart can be used with more than one data series.
answer
True
question
What are gridlines and what do they do?
answer
Gridlines are the horizontal and vertical lines that help you compare data and category values.
question
The range of values, or scale, of an axis is based on the values in the data source.
answer
True
question
Minor tick marks identify the main units on the chart axis.
answer
False
question
By default, titles appear next to the value and category axes.
answer
False
question
Charts remain linked or connected to their data sources, even if they appear in different worksheets.
answer
True
question
If you change any values or labels in the data source, the chart must be manually updated to show the new content.
answer
False
question
The Select Data Source dialog box lists all of the data series displayed in the chart.
answer
True
question
In a line chart, the data markers are the points connected by the line.
answer
True
question
In a line chart, the data markers are the points connected by the line.
answer
True
question
What is the first step when adding a data series to a chart?
answer
Select the chart to which you want to add a data series
question
A quick way to copy formatting is to use the Format Painter button.
answer
True
question
The Select Data Source dialog box lists all of the data series displayed in the chart.
answer
True
question
Changes to the plot area are often made in conjunction with the chart area.
answer
True
question
You can format the plot area by changing its fills and borders, and by adding visual effects.
answer
True
question
A chart sheet takes up less space than an embedded chart.
answer
False
question
You cannot add text to a shape.
answer
False
question
To select more than one shape, hold down the _____ key, then click each of the remaining shapes.
answer
Shift
question
A chart sheet can contain embedded charts.
answer
True
question
A chart cannot be rotated in the chart sheet.
answer
False
question
The _______ represents the length of the object.
answer
x-axis
question
The chart's ___________ controls how fast the chart appears to recede from the viewer's eye.
answer
perspective
question
What is the benefit of combination charts?
answer
Combination charts enable you to show two sets of data using the chart type that is best for each data set. Combination charts can have data series with vastly different values
question
A(n) _______ is descriptive text that appears next to the axis.
answer
axis title
question
You cannot remove an axis title.
answer
False
question
How do you add a data series to an existing chart?
answer
Select the chart, click the Select Data button in the Data group on the CHART TOOLS DESIGN tab to open the Select Data Source dialog box, click the Add button, and then select the range for the data series
question
You can modify the data source to specify which ranges should be treated as category values and which ranges should be treated as data values.
answer
True
question
You can edit the data source in the Edit Data Source dialog box.
answer
False, the Select Data Source dialog box
question
A ________ is a mini chart that is displayed within a worksheet cell
answer
sparkline
question
To create a set of sparklines, you first select a ________ , and then you select a location range where you want the sparklines to appear.
answer
data range
question
A ________ is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value.
answer
data bar
question
What are the three types of sparklines ? Give an ample of when each sparkline might be used. ?
answer
There are three types of sparklines - line, column, and win/loss. A line sparkline might be used to show the sales history of a department. A column sparkline could be used to present a record of monthly temperatures and a win/loss sparkline could be used to show the season results for sports teams
question
How are data bars and sparklines similar or different?
answer
Data bars differ from sparklines in that the bars are always placed in the cells containing the value they represent, and each cell represents only a single bar from the bar chart. By contrast, a column sparkline can be inserted anywhere within the workbook and can represent data from several rows or columns. However, like sparklines, data bars can be used to create compact graphs that can be easily integrated alongside the text and values stored in worksheet cells.
question
The width of data bars is determined based on the values in the selected range.
answer
False
question
A data bar is a type of sparkline
answer
False
question
What are watermarks and what are they used for? Where are they located on a worksheet?
answer
A watermark is text or an image that appears in the background behind other content. Watermarks are inserted into the header or footer of a worksheet. Many businesses distinguish works in progress from final versions by including the word "Draft" as a watermark on each page.
question
: A watermark is text or an image that appears in front of other content.
answer
False
question
Watermarks are only visible in Normal view.
answer
False
question
When you edit cells in a worksheet group, the changes you make to one worksheet are automatically applied to the other worksheets in the group.
answer
True
question
To ungroup worksheets, right-click ________.
answer
any sheet tab
question
What is the first step in copying worksheets to another workbook?
answer
Select the sheet tabs you want to copy
question
The fastest way to copy an entire worksheet to press and hold the Alt key as you drag and drop the sheet tab
answer
False
question
What are the steps to enter a formula that references another worksheet?
answer
Click the cell where you want to enter the formula. Type = and enter the formula. To insert a reference from another worksheet, click the sheet tab for the worksheet, and then click the cell or select the range you want to reference. When the formula is complete, press the Enter key
question
What is a 3-D reference?
answer
It refers to the same cell or range in multiple worksheets in the same workbook
question
What is a Worksheet Range?
answer
It is the range of worksheets you want to reference.
question
What is a Cell Range?
answer
The same cell or range in each of those worksheets that you want to reference
question
A _____ is a connection between the files that allows data to be transferred from one file to the other
answer
link
question
When two files are linked, the _____ file is the workbook that contains the data.
answer
source
question
The ______ is displayed at the end of the table.
answer
total row
question
The ______ file (sometimes referred to as the dependent file) is the workbook that receives the data.
answer
destination
question
A reference in a formula that refers to another workbook is called a workbook reference
answer
False
question
When you break a link using the Break Links command in the Edit Links dialog box, all the external reference formulas are converted to their most recent values
answer
True
question
A _____ is a link in a file
answer
hyperlink
question
To use a hyperlink, you click the anywhere inside the cell that contains the link.
answer
False
question
When you start Excel and see the blank workbook called Book1, you are actually using a workbook based on a template known as the _____ template.
answer
default
question
You can create a workbook with all the formulas and formatting you need and then save it as a template on which you can base other workbooks.
answer
True
question
A _____ is a workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting
answer
custom template
question
___________ refers to data, applications, and even resources that are stored on servers that you access over the Internet rather than your own computer.
answer
Cloud computing
question
You can access your SkyDrive and the office Web Apps anywhere you have Internet access.
answer
True
question
When you save a worksheet as a Web page, Excel converts the contents of the worksheet into XML
answer
False
question
You can save an item in a worksheet as a Web page
answer
True
question
When a text file's data is separated by commas, it is said to be _____.
answer
delimited
question
A text file contains number, text, formulas, and special fonts.
answer
False
question
A ______ is a defined method of retrieving data from an external file.
answer
connection
question
To delete a connection to its data source, select the connection in the list in the Workbook Connections dialog box, and then click the _____ button
answer
Remove
question
You can define how Excel updates, or refreshes, the data.
answer
True
question
How do you apply a connection to a new location?
answer
Click the existing Connections button in the Get external Data group on the Data tab. Open the connection you want to apply, and specify the new location in the workbook
question
Where do you find the Trust Center in Excel?
answer
Click the Office Button and then click the Excel Options button
question
You define a trusted location through the _________.
answer
Trust Center
question
When other users copy your Excel projects to their own computers, path names to external data sources might change and become unusable.
answer
True
question
A ____ is a file that stores a collection of related data.
answer
database
question
A ____ is a collection of data arranged in rows and columns
answer
table
question
A ____ is a question you ask about the data in the database.
answer
query
question
In a database, a table and a query are actually the same thing.
answer
False
question
The first step in the Query Wizard is to create a data source.
answer
True
question
What is a data filter?
answer
When you filter data, you specify which records you want to retrieve using specific criteria
question
What is a filter?
answer
When you filter data, you specify which records you want to retrieve using specific criteria
question
When you _____ a query, Excel retrieves the most current data from the data source, using the query definition you have created
answer
refresh
question
. _____ is a file format that allows for text formatting styles including boldface, italic, and color, but not advanced features such as hyperlinks or complicated table structures. (
answer
Rich Text Format (RTF)
question
How do you edit a Web query?
answer
Web query files are simple text files, so you can view and edit their contents in Notepad. If you understand the Web query language, you can create sophisticated programs to retrieve and process Web data
question
____ are abbreviations for the stock names used by the market.
answer
Ticker symbols
question
You cannot manually refresh a Web query
answer
False
question
Data in an XML document is contained within_____.
answer
elements
question
A(n) _____ marks the beginning of the data value.
answer
opening tag
question
A(n) _____ can be created that displays the layout of the elements in a schematic diagram. (
answer
data map
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
