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...
you can edit the data or a label in a cell by doub
Geschreven voor
AIS |
AIS |
Verkoper
Volgen
FullyFocus
Ontvangen beoordelingen
Voorbeeld van de inhoud
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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
√ Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, Bancontact of creditcard voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper FullyFocus. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €10,51. Je zit daarna nergens aan vast.
