Exam (elaborations)
CGS 2518 Exam 2 Questions with correct Answers 100%
- Course
- Institution
CGS 2518 Exam 2 Questions with correct Answers
[Show more]
Content preview
CGS 2518 Exam 2 Questions withcorrect Answers
You want to apply a subtotal to a dataset containing names, departments, and salaries.
What is the first step you need to do?
(a)Filter the dataset by salaries
(b)Select the function to be used for the subtotal
(c)Insert new rows where you want the subtotal rows within the dataset
(d)Sort the dataset by a field containing categories - Answers -d) Sort the dataset by a
field containing categories
Why would you click the collapse outline symbol above a column of outlined data?
(a)You want to see more detailed columns that relate to the formula in that column.
(b)You want to hide the detailed columns to focus on the result column.
(c)You want to insert a subtotal row for a set of rows.
(d)You want to delete columns containing values. - Answers -b) You want to hide the
detailed columns to focus on the result column
After creating a blank PivotTable, you click a field containing monetary amounts in the
PivotTable Fields task pane. Where does Excel place that field?
(a)Filters area
(b)Columns area
(c)Values area
(d)Rows area - Answers -(c)Values area
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
(a)APR
(b)Periodic interest rate
(c)Loan amount
(d)Number of payment periods - Answers -(b)Periodic interest rate
What is the keyboard shortcut to create an absolute reference?
(a)F2
(b)F3
(c)F4
(d)Alt - Answers -(c)F4
The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?
(a)=YEAR(C1)
(b)=MONTH(C1)
(c)=DAYS(B1,C1)
(d)=DAY(C1) - Answers -(d)=DAY(C1)
, What is the default summary statistic for any value field added to a PivotTable?
(a)Average
(b)Count
(c)Min
(d)Sum - Answers -(d)Sum
You created a PivotTable and changed some values in the dataset from which the
PivotTable was created. How does this affect the PivotTable?
(a)The PivotTable is updated automatically when you make changes to the dataset.
(b)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
(c)You must create a new PivotTable if you want updated results in a PivotTable.
(d)The PivotTable is deleted from the workbook because it is not up to date. - Answers -
(b)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
What settings should you select to apply a different color scheme and display a fill color
for every other row or horizontal lines within the PivotTable?
(a)Banded Rows and Banded Columns check boxes
(b)Banded Columns check box and a different PivotTable style
(c)Banded Rows check box and a different PivotTable style
(d)A different PivotTable style only - Answers -(c)Banded Rows check box and a
different PivotTable style
Why would you create a slicer for a PivotTable?
(a)To filter data in a PivotTable
(b)To sort data for a field in a PivotTable
(c)To slice the data into a timeline
(d)To create a color-coded slice for each category - Answers -(d)To create a color-
coded slice for each category
Which of the following is not used when creating a calculated field in a PivotTable?
(a)Operands, such as multiplication (*)
(b)Name of a field containing values
(c)Another value to be used in the calculation
(d)A cell reference to a value outside of the PivotTable - Answers -(d)A cell reference to
a value outside of the PivotTable
You created a PivotChart showing sales by quarter by sales rep. How do you remove a
sales rep from the chart without deleting the data?
(a)Make the employee's data points and axis titles invisible.
(b)You cannot delete the rep from the chart without first deleting the data.
(c)Filter the Sales Rep field in the PivotChart and deselect the employee's check box.
(d)Hide that rep's row(s) in the underlying list, which automatically removes that rep
from the chart. - Answers -(c)Filter the Sales Rep field in the PivotChart and deselect
the employee's check box.
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 millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now
