Questions
How do I get the full capstone video modules 9 through 12
delites05 asked 4 months ago1. Enrique Vaquero is a city planner for the city of Bradford in northeast Colorado.. Switch to the Caravella Springs worksheet. Break the external li...
davidmacago asked a year ago11. Some weeks you need to track facilities-related information, but that's not necessary this week. Move the Facilities worksheet between the Project...
davidmacago asked a year ago8. In cell B13, create a formula using the COUNT function to determine the number of projects that have booked facility hours by counting the values i...
davidmacago asked a year ago6. Switch to the Scheduling worksheet. In cell A3, change the cell content to Week of February 22, 2021 (instead of Week of February 15, 2021). 7. Cut...
davidmacago asked a year ago2. Enter the values shown in Table 1 into the corresponding cells in the range B8:C11. **Table 1: Data for the Range B8:C11** ``` B C 8 Yvonne Byr...
davidmacago asked a year agoAmy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The MedSight Auditory Instruments...
Cxrlitos asked a year agoHow can i watch the video on Module Project 2 because when i click on it it says the video has been removed. Is there any other way i can watch it?
carloscosma asked a year ago1. Elena Gonzalez works in the Operations Department of Canyon Transport, a company providing delivery and shuttle services in Flagstaff, Arizona. Can...
JDub8 asked a year agoCan you please drop a video on Mount Moreland Hospital ? I cant find it in the videos and my deadline is approaching. Thank you.
Aduke asked a year agoI cannot see the channel and I paid for it
Dj asked a year agoAlex Makula is a project manager for the Content Shop, an online firm based in New Haven, Connecticut, that provides written content for websites. Ale...
Softpups asked a year ago4. Switch to the Han worksheet, which contains listing information for Suki Han. Format the range A2:F10 as an Excel table with headers using the Oliv...
davidap asked a year ago3. Nico wants to compare the average asking prices and average sales prices for the Dahl listings. Insert a Total Row in the Dahl table, and then use ...
davidap asked a year ago2. Remove the filters from the Dahl table to display all of the data. Sort the data in ascending order first by the Listing Type field and then in des...
davidap asked a year ago1. Nico Hallas runs Hallas Realty, a small but growing real estate agency in Columbia, South Carolina. He keeps track of the listings of his four agen...
davidap asked a year ago6. Jacob also wants to examine the percentage that each type of lighting product contributed to total sales in each store. Create a PivotChart as foll...
neb asked a year ago5. Jacob occasionally would like to focus on the number of lighting products sold in the five stores per month. Add a Timeline Slicer as follows to th...
neb asked a year ago4. Edit the PivotTable as follows to provide this information for Jacob: - a. Use the following fields from the 2024_Orders table in the PivotTable: ...
neb asked a year ago3. Go to the Stores worksheet. Jacob wants to display information about lighting products purchased according to store and manufacturer. He has been t...
neb asked a year ago2. Go to the Previous Year worksheet, which lists the sales per month for the previous year in a table and compares the sales in a chart. Jacob import...
neb asked a year ago1. Jacob Sherman is the director of sales for Lighting Designs, a store and website that cater to building contractors in five locations in the Seattl...
neb asked a year ago6. Lucia also wants to examine the percentage each type of product contributed to total sales in each location. Create a PivotChart as follows: - a. ...
mentalmavens asked a year ago5. Lucia occasionally would like to focus on the number of products sold in the five locations per month. Add a Timeline Slicer as follows to the Mat...
mentalmavens asked a year ago4. Edit the PivotTable as follows to provide this information for Lucia: - a. Use the following fields from the 2021_Orders table in the PivotTable: ...
mentalmavens asked a year ago3. Go to the Material worksheet. Lucia wants to display information about products sold according to location and material. She has been tracking this...
mentalmavens asked a year ago2. Go to the Monthly Sales worksheet, which lists the sales per month for the previous year in a table and compares the sales in a chart. Lucia import...
mentalmavens asked a year ago1. Lucia Campos and three friends own a small business called Corvallis Group Restore, an upcycling business in Corvallis, Oregon, that sells useful a...
mentalmavens asked a year ago9. Go to the Estimated Earnings worksheet. Hwan has entered most of the income and expense data on the worksheet. He estimates sales will be $825,000 ...
neb asked a year ago8. Hwan also wants to determine the depreciation balance for the first year and the last year of the useful life of the product hardware. Determine ...
neb asked a year ago7. Calculate the declining balance depreciation amounts as follows: - a. In cell C19, enter a formula using the DB function to calculate the declinin...
neb asked a year ago6. Hwan wants to compare straight-line depreciation amounts with declining balance depreciation amounts to determine which method is more favorable fo...
neb asked a year ago5. Go to the Depreciation worksheet. Hwan needs to correct the errors on this worksheet before he can perform any depreciation calculations. Correct ...
neb asked a year ago4. Calculate the cumulative principal payments as follows: a. In cell G10, enter a formula using the CUMPRINC function to calculate the cumulative p...
neb asked a year ago3. Now Hwan is ready to calculate the annual principal and interest payments for the startup loan. Start by calculating the cumulative interest paymen...
neb asked a year ago2. Correct the #DIV/0! errors in the worksheet as follows: a. Use Trace Precedents arrows to find the source of the #DIV/0! error in cell G12. b. ...
neb asked a year ago1. Hwan Rhee is considering whether to start a software company called ChargeAll in Menlo Park, California, that will produce full-room wireless charg...
neb asked a year agoGiven the following limits, calculate the limits below, if they exist. (If it does not exist, enter NONE.) lim_(x->2) f(x) = 1 lim_(x->2) g(x) = -4 ...
kinechi asked a year ago11. Select the range I6:I13 and then use conditional formatting to add solid orange data bars. 12. Select the range J6:J13 and then add top/bottom co...
davidmacago asked a year ago10. Select the range H6:H13 and then format the range as described below: a. Format the range with the Percentage number format with zero decimal pla...
davidmacago asked a year ago8. Select the range A6:J14 and then add a White, Background 1 border to all sides of each cell. 9. Select the range A14:J14 and then add a thin top b...
neb asked a year ago6. Enter the values shown in Table 1 into the corresponding cells in the range A5:E5. Table 1: Data for the Range A5:E5 A B C D E 5 Abbreviation Depar...
davidmacago asked a year ago15. Edra wants to compare 2021 sales totals to the sales totals for 2020 and needs to add the 2020 data to the Consolidated Sales worksheet. Open the ...
neb asked a year ago1. Min Jee Woo is an artist who makes her living selling her artwork at art fairs around the Midwest. Min Jee is using an Excel workbook with multiple...
rajana asked a year ago12. Create names from the range A7:E9 using the values shown in the left column. 13. Apply the defined names Q1_Sales, Q2_Sales, Q3_Sales, and Q4_Sale...
mentalmavens asked a year ago11. Edra started to create named ranges in the worksheet and has asked you to complete the work. Create a defined name for the range B6:E6 using Walku...
mentalmavens asked a year ago10. Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows: ...
rajana asked a year ago9. Edra wants to create a copy of the formatted Oregon worksheet to use for the Washington section of the chain's sales data. Create a copy of the Or...
rajana asked a year ago8. With the Idaho, Montana, and Oregon worksheets still grouped, create a formula as follows: a. Enter a formula in cell B10 using the SUM function ...
rajana asked a year ago7. With the Idaho, Montana, and Oregon worksheets still grouped, update the worksheet as follows: a. In cell A6, change the text "In Person" to read...
rajana asked a year ago6. Min Jee wants to apply consistent formatting to the worksheets she collected from separate workbooks. Group the Chicago, St. Louis, and Minneapolis...
davidmacago asked 2 years ago4. In cell B9, create a hyperlink to the Narbonne Suites Locations listing as follows: a. Link to the file Support_EX19_5a_Locations.docx. b. Use Narb...
davidmacago asked 2 years ago2. In cell C5, remove the hyperlink, leaving the unlinked text "Bozeman, MT" in the cell. 3. In cell D7, create a hyperlink to an email address as fol...
davidmacago asked 2 years agoEdra is using multiple worksheets to summarize sales data by state. Break the external link in the worksheet, so that the formulas in the range B4:B7...
davidmacago asked 2 years ago4. Merge and center the contents of the range A2:J2. 5. Format the merged range A2:J2 as described below: a. Apply the 40% - Accent 5 cell style. b....
rajana asked 2 years ago1. Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building a workbook that summarizes income and expense...
davidmacago asked 2 years agoUse the Scenario Manager as follows to create a PivotTable that compares the profit per unit in each scenario as follows: a. Create a Scenario Pivot...
neb asked 2 years agoBenicio wants to compare three scenarios: one with the current prices costs, another with the prices raised $10.00, and a third that reduces the vari...
davidmacago asked 2 years agoRun Solver to solve this problem as follows: - Set the total number of virtual assistants produced (cell E5) as greater than or equal to 11,000, DIG ...
davidap asked 2 years agoHe wants to see how the gross profit changes if the price or unit sales are different. Create a two-variable data tableas follows to calculate gr...
davidap asked 2 years agoGo to the Sales Projections worksheet, which provides a profit analysis of a new virtual assistant product DIG Technology is planning to develop. Beni...
davidap asked 2 years agoa. Change the colors of the PivotChart to Monochromatic Palette 6 to coordinate with the PivotTable. b. Use the slicer to display sales data for onl...
davidap asked 2 years agoa. Insert a Stacked Column PivotChart based on the data in the PivotTable. b. Move and resize the PivotChart so that it covers the range A10:E25.
davidap asked 2 years agoFull question: Benicio wants to isolate sales for each product. Insert a slicer as follows to filter the PivotTable: a. Insert a slicer based on the ...
rames asked 2 years agoFormat the PivotTable as follows to make it easier for Benicio and others to interpret: a. Apply the Currency number format with 0 decimal places and...
davidap asked 2 years agoBenicio wants to examine the January, 2022 sales by country and channel. Create a PivotTable based on the Sales table as follows: a. On a new workshe...
davidap asked 2 years agoBenicio wants to make sure that the Sales table does not contain any duplicate records, which would make any sales analysis incorrect. Identify and ...
davidmacago asked 2 years agoFull question: The Sales table is currently sorted by the values in the Sale ID column, but Benicio wants to sort the table by date, then amount to ma...
davidmacago asked 2 years agoGo to the Current Sales worksheet, which contains a table listing sales data for January, 2022. To make it easy to refer to the data, the table has be...
rames asked 2 years agoBenicio also wants to make it easy to access more detailed information about the managers, which he has stored in a Word document. Create a link to ...
davidap asked 2 years agoIn the range I3:L7, Benicio listed information about the managers of the DIG Technology main offices in the U.S., Canada, and Mexico. He needs to add ...
davidap asked 2 years agoIn the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:...
davidap asked 2 years agoBenicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the ...
rajana asked 2 years agoBenicio started to define names for cells and ranges in the All Locations worksheet to make it easy to identify the total sales for each product. He w...
rames asked 2 years agoPlease help. Here is full context: Go to the All Locations worksheet, where Benicio wants to summarize the quarterly and annual totals from the three...
davidap asked 2 years agoa. Group the U.S., Canada, and Mexico worksheets. b. In cell F5, insert a formula using the SUM function that totals the Mini sales amounts for Quar...
davidap asked 2 years agoYour videos really help me, I was wondering if theres any way you can do these two?
luke_adzema asked 2 years ago5. In the 2021 Revenues by Insurance Type 3-D pie chart (in the range H26:O43), change the legend position to bottom. Add data labels that contain onl...
krishna asked 2 years ago3. Geneva wants a clustered column chart representing the total revenue for each insurance type by year. Create a 2-D clustered column chart based on ...
Bobi asked 2 years agopls hlp with these qnss: 8. Naomi and Kaito have more string instruments than any other type. Naomi wants to summarize the string instrument data usi...
rajana asked 2 years agohelp with these qns pls: 1. Kaito and Naomi Sato started collecting musical instruments as a hobby a few years ago and are now organizing their colle...
krishna asked 2 years agoPlease help with these questions: 9. Padma asks you to make it easy to filter the table based on the contractor's specialty and starting year. Insert...
krishna asked 2 years ago5. Padma wants to quickly identify the contractors who have been working with Veritate the longest. Sort the data in the Contractors table first in as...
K asked 2 years agoPlease help me with these questions: 1. Padma Laghari is a content manager for Veritate Online, a website that sells electronics, home furnishings, an...
rames asked 2 years agoFull question: In cell D7, enter a formula without using a function that divides the Cost of sales value in cell C7 by the revenue amount, using the d...
davidmacago asked 2 years agopls help with these qns 8. Lonnie prefers that accountants and others contact Lewellen through the link in cell H8 rather than one that connects to h...
rames asked 2 years ago11. Gudrun wants to compare future payments for three different scenarios for a park's bond offering. Switch to the Bond Offering worksheet. She has a...
dipen asked 2 years ago1. Lonnie Holtzman is a financial analyst for the Lewellen Group, a management consulting firm headquartered in Providence, Rhode Island. The firm als...
rames asked 2 years ago7. Gudrun wants a stacked bar chart showing spending per park for each year. a. Create a Stacked Bar chart based on the data in the range A4:E9. b. Re...
rames asked 2 years ago4. Gudrun has created a pie chart representing the percentage of the parks' budget that went to each park in 2018. Modify the chart in the range G2:O2...
rames asked 2 years agofull question is given below pls hlp 1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in preparatio...
rames asked 2 years agoFull question: In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20, subtracts it from the value in cel...
rames asked 2 years agopls hlp with these qns: 6. Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to displa...
rames asked 2 years agopls hlp with these questions: 1. Chanelle Larson is a professional assistant with Barrel Barnard Consulting. Chanelle is responsible for collecting c...
rajana asked 2 years agoNew Perspectives Excel 2019 | Module 2 - End of Module Project 1 6. Copy the formatting of the merged cell in the range A7:A9, then paste the formatt...
rames asked 2 years agopls help with the questions below: 1. Titus Allison is a loan officer with First Mittagong Community Bank. Titus is adding formatting to the workbook ...
krishna asked 2 years agoPlease help me with these steps. 6. Switch to the Scheduling worksheet. In cell A3, change the cell content to Week of February 22, 2021 (instead of ...
davidmacago asked 2 years agoBenicio has already calculated that the gross profit for the new product could be nearly $295,000 based on a unit price of $159.99 and unit sales of 2...
rames asked 2 years agoImagine an object is moving on a perfect circle as shown at below. If the radius of circle is 4.50km and the angle between AOB is 120 degree. What is ...
rames asked 2 years agoPls help me to edit the chart series names by using cell F5 as the series name for Series 1. For Series 2, use cell G5 as the series name. For Series ...
rames asked 2 years agoOne way to increase profits is to run the GymWear trade show for an extra day. Another way is to add exhibits. Fernanda has already created a scenario...
davidmacago asked 2 years agoHelp me to solve it pls. - Change the Minimum Bounds of the vertical axis to 120,000 and let the Maximum Bounds change automatically to 210,000. - C...
krishna asked 2 years agoI want urs help to - Create a Scatter with Straight Lines chart based on the range E4:G14 in the data table titled GymWear - Break-Even Analysis. - R...
dipen asked 2 years agoHow to apply the custom format? It has =C20 and 9.250 as the value
rames asked 2 years agoCan you pls help. I don't know how can I insert one-variable data table. This is the full question: Switch to the Builders worksheet. Fernanda wants ...
rames asked 2 years agoI have done =SUM(F17:F20)-J10+SUM(G17:G20)-160, but it is not matching with the required answer and gave me red checkmark. Help and advice would be a...
davidmacago asked 2 years agoHelp to solve this pls. I entered =SUM(D17:D20)-J8, but it is giving in negative. The full question is "Add formulas to complete the balances section...
rames asked 2 years agoFull questions is to create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the n...
rames asked 2 years agoThe full question is: Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check ...
dipen asked 2 years agohello, how can I solve it? I did =WORKDAY(19,C3), but it doesn't seem to be correct.
rajana asked 2 years agoIn cell E6, enter the following: AFS51EZ21 Select the range E6:E11, and then use the Flash Fill button (in the Editing group on the Home tab) to a...
davidmacago asked 2 years ago
