Category: Excel

This project covers the following MOS Objectives:
Create Excel tables from cell ranges (EX21-3.1.1)
Sort data by multiple columns (EX21-3.3.2)
Add or remove table rows and columns (EX21-3.2.1)
Convert tables to cell ranges (EX21-3.1.3)
Filter records (EX21-3.3.1)
Filter and Sort Table Data (EX21-3.3)
Apply table styles (EX21-3.1.2)
Insert and configure total rows (EX21-3.2.3)
Configure table style options (EX21-3.2.2)
Steps to complete this project:
Mark the steps as checked when you complete them.
Open the start file EX2021-MOS-Ch3 presentation. If the presentation opens in Protected View, click the Enable Editing button in the Message Bar at the top of the presentation so you can modify it.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
Create the customer list table.
Format the data on the Customer List worksheet into a table using Green, Table Style Light 14. The table data should include cells A1:I65. Be sure to include the table headers.
Clean up the customer list table by removing all duplicate rows with identical data in the First Name, Last Name, and Street columns. Excel should find and remove 8 duplicate values, leaving 56 unique values.
Sort the customer list data by Last Name and then by First Name.
Convert the table to a normal range.
Create the sales analysis table.
Go to the Sales Analysis worksheet.
Sort the sales data by the Purchase Date column so the oldest dates appear first.
Apply the Dark Blue, Table Style Dark 6 table style.
Display the total row and show the total (sum) number of sales in the # Items Purchased column and the total (sum) in the Purchase Total column.
Filter the table to show only sales from the city Rocklin with the zip 95663. There should be nine rows that meet the criterial.
Remove the banding from the table.
Create the February Sales table.
Go to the February Sales worksheet.
Sort the table by Zip, and then by City, and then by Purchase Total with the largest purchase totals at the top.
Add a custom filter to the table to show only purchases after or equal to 2/1/23 and before or equal to 2/28/23. There should be six rows that meet that criteria.
Apply the Blue, Table Style Medium 6 table style to the table.
Create the custom filter table.
Go to the Custom Filter worksheet.
Clear the existing filter from the City column.
Create the criteria range by inserting four blank rows above the table header row and then copying the table header row (row 5) to row 1.
Enter filter criteria to show only records where the city is Rocklin and the # of items purchased is less than five and the purchase total is greater than 100 OR where the city is Rocklin and the # of items purchased is greater than five and the purchase total is less than 100.
Filter the data in place. Hint: Use the Advanced Filter feature with cells A1:I3 as the criteria range and cells A5:I69 as the list range. There should be nine rows that meet that criteria.
Add a total row to the table to show the number (count) of records in the City column, the average in the # Items Purchased column, and the average in the Purchase Total column.
Save and close the presentation.
Upload and save your project file.
Submit project for grading.

This project covers the following MOS Objectives:
Merge and unmerge cells (EX21-2.2.1)
Apply cell styles (EX21-2.2.7)
Format cells by using Format Painter (EX21-2.2.3)
Apply number formats (EX21-2.2.5)
Apply cell formats from the Format Cells dialog box (EX21-2.2.6)
Modify cell alignment, orientation, and indentation (EX21-2.2.2)
Fill cells by using Auto Fill (EX21-2.1.2)
Insert sparklines (EX21-2.4.1)
Define a named range (EX21-2.3.1)
Name a table (EX21-2.3.2)
Wrap text within cells (EX21-2.2.4)
Paste data by using special paste options (EX21-2.1.1)
Remove conditional formatting (EX21-2.4.3)
Apply built-in conditional formatting (EX21-2.4.2)
Insert and delete cells (EX21-2.1.4)
Clear cell formatting (EX21-2.2.8)
Insert and delete multiple columns or rows (EX21-2.1.3)
Steps to complete this project:
Mark the steps as checked when you complete them.
Open the start file: EX2021-MOS-Ch2. If the file opens in Protected View, click the Enable Editing button in the Message Bar at the top of the file so you can modify it.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
On the By Region worksheet, make the following formatting modifications:
Merge and center the tile across cells A1:E1.
Apply the Title style to the merged cells.
Use Format Painter to copy the formatting from cell A3 to cells A4:A7.
Apply the Accounting number format to cells B3:E8.
Decrease the decimal so the values are whole numbers with no cents (e.g., $   236,878).
Apply a thick, top, blue border to cells B2:E2. Hint: Use the Format Cells dialog and select the thick line style that is the second up from the bottom in the right column in the Border tab, Style box. Use the Standard blue color.
Change the horizontal alignment for cells B2:E2 to Center.
On the By Region worksheet, complete the total row.
Use AutoFill to fill the formula from cell B8 to cells C8:E8.
Apply the Total cell style to cells A8:E8.
On the By Region worksheet and add Column Sparklines in F3:F7 for the data range B3:E7.
Create named ranges.
On the By Region worksheet, create named ranges for each of the columns in cells B2:E7. The names should come from the column header cells in row 2. There should be four named ranges created.
On the By Region worksheet, create a new named range from cell B8. Name the range: Region1Total
Change the name of Table1 on the Sales Data worksheet to: SalesDataTable
On the Sales Data worksheet, modify the following formatting:
Apply cell wrapping to cells F2 and G2.
Apply the Currency number format to cells G3:H37.
Copy cells A2:H2 from the Sales Data worksheet (the column headings) and paste the text values but not the formatting to cells A2:H2 on the Sales Analysis worksheet.
On the Sales Analysis worksheet, make the following formatting changes:
Remove the conditional formatting from cells F3:F38.
Apply conditional formatting to cells G3:G38 to highlight cells greater than 50. Use the Green Fill with Dark Green Text formatting option.
Apply data bar conditional formatting to cells H3:H38. Use the solid fill blue data bar style.
Setup the Sales Template worksheet:
On the Sales Template worksheet, insert a new cell at C1, shifting cells to the right.
In cell C1, type: Feb
Use AutoFill to extend the month series from cells B1:D1 through cell M1.
Select cells B1:M1 (the month headings) and apply bold formatting.
With cells B1:M1 still selected, angle the cell alignment counterclockwise to 45 degrees.
Delete cell A2, moving the existing cells up.
Clear the formatting from cells A2:A5.
Insert four new rows below row 2.
Copy cells B2:E2 from the By Region worksheet (the region headings).
Paste the copied cells into the Sales Template worksheet, cells A3:A6. Hint: You will need to transpose the text so the headings are pasted vertically instead of horizontally.
Clear the formatting from the pasted cells.
Save and close the file.
Upload and save your project file.
Submit project for grading.

The Anova Excel Data sheet is needed for this activity. Access the Excel sheet attached
There are 3 files: Follow the Directions (1) to complete the assignment using the Anova data from the Class Survey Data File (2), and submit your work using the Assignment Submission Form (3) via the appropriate link

This project covers the following MOS Objectives:
Adjust row height and column width (EX21-1.3.2)
Freeze worksheet rows and columns (EX21-1.4.3
Search for data within a workbook (EX21-1.2.1)
Display and modify workbook content in different views (EX21-1.4.2)
Customize headers and footers (EX21-1.3.3)
Modify page setup (EX21-1.3.1)
Set a print area (EX21-1.5.1)
Configure print settings (EX21-1.5.3)
Change window views (EX21-1.4.4)
Navigate to named cells, ranges, or workbook elements (EX21-1.2.2)
Insert and remove hyperlinks (EX21-1.2.3)
Display Formulas (EX21-1.4.6)
Import data from .txt files (EX21-1.1.1)
Import data from .csv files (EX21-1.1.2)
Customize the Quick Access toolbar (EX21-1.4.1)
Inspect workbooks for issues (EX21-1.5.4)
Modify basic workbook properties (EX21-1.4.5)
Save workbooks in alternative file formats (EX21-1.5.2)
Important: Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, make sure to extract the files after downloading the resources zipped folder. Visit the SIMnet instant help for step-by-step instruction.
Steps to complete this project:
Mark the steps as checked when you complete them.
Open the start file: EX2021-MOS-Ch1 If the file opens in Protected View, click the Enable Editing button in the Message Bar at the top of the file so you can modify it.
The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
On the Kia data worksheet, make the following modifications:
Autofit column I to fit the data.
Modify the row height of row 1 to exactly 78.
Apply Freeze Panes so the first row is always visible as you scroll down the worksheet.
Find the cell with the underhood ID MKMXV01.6J13 and apply Bold formatting. (Hint: Verify that the top row of the worksheet is no longer selected, or the Find feature may be limited to the highlighted cells.)
Throughout the workbook, review headers and footers and make the following modifications:
From Normal view, on the Kia data worksheet, add a custom header to the center section: Kia Data
On the 2020 Green Cars Federal worksheet, use Layout view to delete the text in the left footer section and replace it with: Source: fueleconomy.gov
On the 2020 Green Cars Federal worksheet, add the sheet name to the footer center section. Hint: Do not type the sheet name in the footer. Insert a code so Excel will display the name of the current worksheet.
On the Kia data worksheet, make the following page and print settings modifications:
Using Page Break Preview view, move the page break between pages one and three to before the Stnd Description column (between columns H and I).
Define the print area to print only the Kia Forte data (cells A1:R7).
On the 2020 Green Cars Federal worksheet, make the following page and print settings modifications:
Change the orientation to landscape.
Modify the scaling so all columns will fit on one page.
Modify the print settings to repeat row 1 at the top of every page.
Set the margins to the Narrow option.
Split the worksheet view into two vertical panes at cell H1.
On the Kia data worksheet, navigate to the named range Sportage_data. When you navigate to the range, Excel will highlight the range for you. Copy the data and paste starting in cell A10 on the Summary worksheet.
Add hyperlinks to the Summary worksheet.
On the Summary worksheet, insert a hyperlink in cell A1 to navigate to cell A1 on the Kia data worksheet.
On the Summary worksheet, insert a hyperlink in cell A2 to navigate to the web site: https://www.fueleconomy.gov/feg/download.shtml
On the Summary worksheet, display formulas.
Import from a text file.
Import the tab-delimited text file SmartWay Vehicle List for MY 2020.txt to a new worksheet.
Rename the sheet: SmartWay
Import from a CSV file.
Import the CSV file 2022 FE Guide preliminary data.csv to a new worksheet.
Rename the sheet: 2022 Prelim
Add the Quick Print option to the Quick Access Toolbar.
Inspect the workbook for issues and remove all document properties and personal information.
Modify the workbook properties to add the keyword: fuel
Save and close the file.
Upload and save your project file.
Submit project for grading.
If directed to do so by your instructor: open the workbook file and save it in the .xls format compatible with older versions of Excel. Provide this file to your instructor for additional grading.

I need someone to rewrite what I already wrote about a specific country, check the facts, put intext citations (APA 7), I created graph with chatgpt but the teacher asks excel sheet with the data (from bankworld) and that uses formula to create it.  I’ll put an exemple of a report, they didn’t get a good mark but it shows the kind of work needed (especially for the excel sheet), I also only need the part you find in my work the other sections don’t have to be done. 

For this assignment, please use the following as your template, bolding keywords as bolded below:
Interpretation of what the graph is telling us about happiness and ecological footprint in general. Don’t just comment on only part of the graph; say what the general trend is.
Provide an estimated range (minimum to maximum value) for the correlation coefficient (statistic), with a width of no more than 0.2. For example, a range of correlation coefficients of 0.1 to 0.3 would have a width of 0.2. You can go by just looking at the graph. No calculations are required for this educated guess. One thing I’ll look for though is whether you get the direct of the coefficient correct (positive versus negative). Explain what each number represents, like I did in my example above (the 0.1 to 0.3 and the 0.2).
See examples below for your estimate. Note that the range of correlation coefficients is from    -1.0 (indirect or negative correlation) to +1.0 (direct or positive correlation). Support your answer with an explanation of the data points you see.
What could affect the size of the correlation statistic?
Regarding the actual data points (hint: A straight line of dots going at a 45-degree angle would be a very strong correlation.) Does the graph show a straight line?
Regarding how the variables were measured (i.e., what information is used to define them, as well as other potential information not considered?)

仪表板详细信息：
您应该在第一张工作表上构建仪表板并适当命名。要有创意和专业。使用最能代表所选数据的图表。根据您创建图表的方式，您的仪表板应该有 6 到 8 个图表。这可能会根据您包含的其他可视化效果而有所不同，例如具有条件格式和迷你图的小表格。仪表板的数据位于项目文件的第 2 页上。
您将获得几种不同类型的数据。您不仅应该使用提供给您的原始数据，还应该使用您在课堂上学到的函数来创建更有意义的数据转换。为了刷新您的记忆，这些函数包括（但不限于）SUM、AVERAGE、MIN、MAX、STDEV 等。例如，您可以计算每个月销售额的百分比变化，然后创建结果的迷你表，使用条件格式或迷你图来帮助可视化数据。
分析：
您还需要编写一份报告来分析仪表板的输出。该报告的长度应在 750 至 1250 字之间。您应该使用仪表板计划问题来指导此报告。此外，请确保还解决以下问题：
经理可以根据您的仪表板做出哪些类型的决策（这应该基于您在仪表板计划中提出的问题）？
您在创建仪表板时遇到了哪些困难？
如果您能够访问更多数据，未来版本的仪表板会有哪些改进？

For
this project, think of a situation in business/organization or in your personal
life where you can apply the analysis and tools we learned throughout the
semester to improve or automate decision-making. You can use
functions, pivot table, macros, as well as things beyond what you leaned in the
class.
The
goal is that application of these tools can help the business/organization to
run more efficiently or effectively. There are two general directions you can
take to achieve this goal:
·     
extract insights from data to help firm improve their operations
or make better decisions,
·     
automate certain operations so that it is easier for users/decision-makers
to search and access information or insights.
You
can pick one of them or do a hybrid of both.
Submission
Your
final submission should include an Excel file with your data and
analysis and a recorded presentation with slides that explain: 1. The
scenario 2. How your analysis/automation help with the business/organization. 
I
am grading your project mainly based on two aspects.
·     
The technical aspect: whether the tools you use is appropriate
for the analysis and the sophistication level of the tools
·     
The business aspect: whether you are solving a meaningful
problem (to aswer the “so what” question)

In these two assignments, there is strict rules to SHOW WORK. Showing work is how this assignement is completed, please attatch the answers into the right slot, the questions are to left side of the assignment. If you have any questions you can reach out to me. Plase do all of thw work on excel and turn in the answers with an excel link. 
Directions: Charts and other visual aids are important features of Microsoft Excel and other data analytic platforms. Visualization tools allow you to effectively communicate data insights to others. The following video covers some basics of creating and modifying charts in Excel. Please review the video before working through the practice files below (2 practice files in this lesson), and before taking the quiz (below this assignment on the Modules page).

Please upload your practice files after completing the exercises. If you save files to your computer, you can upload more than one file at a time. If you are submitting from OneDrive, you might have to submit twice, i.e. it seems like resubmitting, but with a different file – we’ll see both!
The two practice files that need to be completed are attatched below

Please do a correct solution without mistakes, without similarities, without plagiarism. Put the answer in the file and make sure to solve all the paragraphs. If you do a good job, I have many assignments that I will ask you to do. Check yourself and do your best
Make sure the plagiarism rate is zero