1 page/≈275 words
Accounting, Finance, SPSS
Statistics Project: Computing Data Into Excel Sheet (Statistics Project Sample)
Comparing dAte and computing into excel sheetsource..
Department of Foundation and General Studies
Academic Year 2016 - 2017, Semester â€“ Fall
Computer Applications and Technology SAT 103
Section 1- Evening
Total Marks: 5
Marks Obtained: _____
Name of Student:___________________________________________
Student ID: ___________________
With your name and ID.
Question 1: Microsoft Excel (5 marks) â€“ CLO (3)
Design the following table and answer the questions below it.
1 Calculate the Amount Column, where Amount = Quantity * Unit price
2 Format the Amount Column, as currency with KWD symbol with two decimal places.
3 Calculate the amount of Discount in Discount column, Use IF Function as follow : If the Amount greater than or equal to 100, Discount = Amount * 10%else
Discount = Amount * 5%.
4 Calculate the Total column as, Tot...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
- Descriptive Statistics: Scope and Methods in Political ScienceDescription: This test statistic assumes that there is a weak significant relationship between the respondents and their views on whether president Obama will be re-elected...8 pages/≈2200 words| No Sources | APA | Accounting, Finance, SPSS | Statistics Project |
- Statistics Project: Computing Data Into Excel Sheet Description: Calculate the amount of Discount in Discount column, Use IF Function as follow : If the Amount greater than or equal to 100, Discount...1 page/≈275 words| No Sources | APA | Accounting, Finance, SPSS | Statistics Project |
- Anlysing SpreadsheetDescription: The total sales chart depicts a graphical representation of total sales that are made in twenty one countries...7 pages/≈1925 words| APA | Accounting, Finance, SPSS | Statistics Project |