100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
AIS || Questions and 100% Verified Answers. $11.09   Add to cart

Exam (elaborations)

AIS || Questions and 100% Verified Answers.

 1 view  0 purchase
  • Course
  • AIS |
  • Institution
  • AIS |

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...

[Show more]

Preview 2 out of 8  pages

  • August 23, 2024
  • 8
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • AIS |
  • AIS |
avatar-seller
FullyFocus
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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67866 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.09
  • (0)
  Add to cart