You can edit the data or a label in a cell by double-clicking the cell and then positioning the insertion point within the cell. correct answers True
You must select ________ on a worksheet to create a pie chart. correct answers two ranges
In a map chart, each region displays shading to indic...
AIS || Questions and 100% Verified Answers.
You can edit the data or a label in a cell by double-clicking the cell and then positioning the
insertion point within the cell. correct answers True
You must select ________ on a worksheet to create a pie chart. correct answers two ranges
In a map chart, each region displays shading to indicate the values in the data series. correct
answers True
Which of the following displays trends over time? correct answers A line chart
In a line chart, which of the following resides along the bottom of the chart? correct answers The
x-axis
To what extent can a pie chart be rotated? correct answers Up to 360 degrees
________ is an Excel tool that finds the input needed to arrive at a desired result. correct answers
Goal Seek
If B4 contains the formula "=$F$5" and you copy and paste B4 into D8, what will the formula be
in D8? correct answers $F$5
The process of changing cells in a worksheet to see how those changes affect the outcome of
formulas is known as ________. correct answers what-if analysis
Use the F1 key to cancel a moving border after you have copied and pasted. correct answers True
Bevel is a shape effect that uses bolding and colors to make the edges of a shape appear to be
straight or diagonal. correct answers True
If you edit data in a worksheet that is associated with a pie chart ________. correct answers the
pie slices will be automatically updated
A pie chart should be considered when you have just one data series to plot. correct answers
False
A graphic image can be inserted into the background of a chart. correct answers True
A chart sheet contains only a chart and the data used to generate that chart. correct answers True
In the PivotTable Field List, you can rearrange existing fields by using one of the four areas at
the bottom of the layout section. correct answers True
The data for a PivotTable formatted in columns and rows is called ________. correct answers
source data
, Which of the following is an interactive Excel report that summarizes and helps analyze large
amounts of data? correct answers PivotChart
Excel uses the column titles as the ________ for the categories of data. correct answers field
names
Most of the formatting that has been practiced in standard charts works the same way in a
PivotChart. correct answers True
A slicer includes a slicer header that specifies the category of the slicer items. correct answers
True
________ are filtering controls with buttons that enable you to drill down through large amounts
of data. correct answers Slicers
The area to rearrange and reposition fields in the PivotTable is called the ________. correct
answers layout section
In a PivotTable, a single piece of information for every record is called a ________. correct
answers field
A method of incorporating data from multiple, related tables into an Excel worksheet is a
________. correct answers Data Model
You update or refresh PivotTable report data. correct answers True
Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable
report. correct answers True
Which of the following is not a benefit to organizations of using Power BI? correct answers It
focusses on one data source
The ________ is a window that lists all the fields from the source data in a PivotTable and
provides an area in which you can arrange the fields in the PivotTable. correct answers
PivotTable Fields pane
A PivotChart usually has an associated PivotTable and the two are interactive. correct answers
True
You can customize your table by creating and applying a custom table style of your own design.
correct answers True
You can share worksheets or workbooks with others by ________. correct answers printing
paper copies, sending the file electronically, or posting the file to the web or a shared workspace
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.09. You're not tied to anything after your purchase.
