Answered You can hire a professional tutor to get the answer.

QUESTION

D' Module 9 : Overvie x Online Excel Assign X Excel: Functions X G how to make a tab X what is an increme X * Homework Help - (x * Homework Help - X...

Hello, I have this assignment due, I have added an image of the instructions here. I have never worked with excel nor do I know the first thing about it. I am in an online computer science class and we do not have a textbook or anything that I could use to help. I really am lost and was hoping I could get some help.

D' Module 9 : Overvie xOnline Excel Assign XExcel: FunctionsXG how to make a tab Xwhat is an increme X* Homework Help - (x * Homework Help - XHow do I take a sc XOX-C 0 @ File | C:/Users/maeve/Downloads/Online%20Excel%20Assignment%201.pdf*PDFMOnline Excel Assignment 1.pdf1/1C:Excel assignment #1Using cell formatting, arithmetic operations, cell references, making a table, and using thefill handle1.Recreate the spreadsheet in the file named RecreateSpreadsheetAssignment1,located in the FILES for our class.2.Make a table of values for f(x) defined below.The values should start at x = -5 and end at x = 5. The increments should be .25f (x) =x +4x-3x2+53.Enter the following table into excel. Then, in column F, find the total of the entries ineach row.AD1ProductJanFebMarApr2X34534003780290017603Y109187021309004300X54635075010002005X671648199184.cell range B2:E5.Using the table, in cell f6, put the grand total for all products. Use the data from the5.For each product, in column G, calculate the percentage of the total of all products.This should use an absolute addressing.6.Re-format the entries for the numerical cells as appropriate.+O Type here to searchem9aN5:23 PMI xA3/14/2019LJEM
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question