Question

1. Which step is first in viewing all the conditional rules you have applied to a Pivot Table? Select an answer:

- Open a new worksheet, then click any cell.
- Click any Totals or Subtotals cell within the Pivot Table.
- Click any cell on the worksheet outside of the Pivot Table.
- Click any cell on the within the Pivot Table.

2. Why would you use Data Bars with a Pivot Table? Select an answer:

- to horizontally display the relative magnitude of values in a cell
- to horizontally display the values of data in a cell
- to highlight the values of data in a cell
- to highlight the relative magnitude of values in a cell

3. Your Pivot Table shows purchases for each quarter of 2019 for three products you buy. If you perform the operation in the Analyze to Show Report Filter Pages by category, what will you create? Select an answer:

- three separate worksheets, one for each product category
- three Pivot Tables, one for each product category, on the same worksheet
- four separate worksheets, one for each quarter
- four Pivot Tables, one for each quarter, on the same worksheet

4. Which function do "slicers" have in an Excel Pivot Table? Select an answer:

- Slicers are limitations on filtering data in a Pivot Table.
- Slicers are a deeper level filter applied to a filter.
- Slicers are the way multiple fields are filtered through.
- Slicers are a visual display of filters applied to a Pivot Table.

Answer #1

Answer 1 d

For viewing conditional formatting in pivot table we have to click in any cell in the pivot table then click conditional formating

Answer 2 d

Data bars add a horizontal bar in color showing the rlative strength of cell value.

Answer 3 a

The result will be displayed on three seprete worksheets on the same workbook, each displaying the individual product.

Answer 4 d

Slicer in a pivot table provide visual filters with the help of which the data can be filtered according to users needs.

Record the data.
In class, randomly pick one person. On the class list, mark
that person’s name. Move down four names on the class list. Mark
that person’s name. Continue doing this until you have marked 12
names. You may need to go back to the start of the list. For each
marked name record the five data values. You now have a total of 60
data values.
For each name marked, record the data.
5
3
0
0
0...

Tableau can connect to all these file types except which of the
following?
Text
PDF files
Excel
Microsoft Access
Microsoft Power BI
Which of the following is least likely to be a Dimension field
in Tableau?
Total cost
Country
State
Segment
None of the choices are correct.
Which of the following is least likely to be a Measure field in
Tableau?
Sales revenue
Segment
Total cost
Quantity sold
None of the choices are correct.
Which of the following best describes...

In this assignment you will analyze the performance of actual
company divisions. FASB ASC 280 (formerly SFAS 131) requires
publicly traded companies to disclose segment information in the
notes to the financial statements. You will use Excel to create
visually appealing data tables and bar charts to analyze
division performance, and then comment on the results.
Due Date: Tuesday, May 1, 2018. Submit as an
attachment in Blackboard in the Module 24 Assignment.
SECTION I
The link is to...

Part 3 – Steelcase Production
Steelcase Corporation manufactures 3 basic products: chairs,
desks, and tables. Below is chart which summarizes the number of
labor hours spent for each product in each division.
Chairs
Desks
Tables
Process
Carpentry
2
3
6
Finishing
1
1
1
Assembly
4
6
2
In a given week, Steelcase has 250 hours available for
carpentry, 100 hours available for finishing, and 400 hours
available for assembly.
Steelcase makes a profit of $66 on each chair, $75...

Excel Lab 2: Regression and Goal Seek
In this lab, you will use Excel to determine the equation of the
model which best fits a set of ordered pairs
obtained from data sets. You will enter data, graph the data, find
the equation for the regression model,
and then use that equation to make predictions for the dependent
variable. You will use the goal seek to make
predictions for the independent variable. Then you will consider
how accurate your predictions...

Project Description:
As the Human Resources Manager, you maintain employee salary
data. You exported data from the corporate database into an Excel
workbook. You want to display subtotals for salary by city. For
further analysis, you want to create a PivotTable to determine what
the total salaries would be if employees who earn an Excellent
rating get a 5% increase in salary. Finally, you want to create a
PivotChart that depicts what percentage of employees earn each
performance rating.
Instructions:...

Use only one worksheet; it should be labeled “Q Set 1”. Be sure
to label all results/formulas clearly.
Question Set 1.
You are an inventory management consultant. You have been hired
by Whole Foods to help optimize inventory management for their
produce department. Your immediate task is building a Monte Carlo
simulation for sales of apples, oranges, and bananas. The
probabilities of daily demand levels are:
Probability
Apples
Oranges
Bananas
0.10
225
344
266
0.15
259
394
300
0.25
278...

Sex
Sports
Popularity
Grades
Boys
60
50
117
Girls
30
91
130
Sports
Popularity
Grades
Proportion of boys who selected each category.
0.2643171806
0.2202643172
0.5154185022
Proportion of girls who selected each category
0.1195219124
0.3625498008
0.5179282869
1)if goals were contingent on district type. Was there any
difference in the goals of students from rural, urban, or suburban
areas?
Create an observed frequency table using the raw data and
calculate Χ2. Χ2 =
Hint: I counted up the observed frequencies for the...

Suppose that you have received 100 email messages 90 of which
are genuine and
10 are spam. Suppose that your email server runs a spam filtering
software that
classified the above email messages as follows.
• Out of the the 90 genuine messages 88 classified as genuine but 2
are wrongly
flagged as spam.
• The probability of correct classification of a message is at
least 97%
Using the above data, please answer the three questions below. Each
answer must...

Class-In Assignment 3:
Chapters 4&5 How to retrieve data from two or more
tables Exercises
1. Write a SELECT statement that returns all columns from the
Vendors table inner-joined with all columns from the Invoices
table.
2. Write a SELECT statement that returns four columns:
vendor_name vendor_name from the Vendors table invoice_number
invoice_number from the Invoices table invoice_date invoice_date
from the Invoices table balance_due invoice_total minus
payment_total minus credit_total from the Invoices table The result
set should have one row...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 8 minutes ago

asked 16 minutes ago

asked 28 minutes ago

asked 47 minutes ago

asked 54 minutes ago

asked 56 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago