MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
PRACTICAL EXERCISE 1.2
Enter the data given below into a worksheet.
E
Stationery
Supplies Ltd
2.
Receipt
Amount
Date
SalesPerson Item
No
Toys
Stationery
Toys
1238 1,782.10
1255 4,853.55
51.35
21-Nov
Carl
26-Nov
Carl
Carl
1395
26-Nov
Carl's
Total
1141
91.16
Cards
21-Nov
24-Nov
10 21-Nov
John
John
John
1982
442.60
Books
9
561.50
62.75
1885
Toys
Toys
1875
11
26-Nov
John
John's
Total
12
234.50
472.60
1032
Judy
Judy
Books
13 22-Nov
14 26-Nov
1920
Sports
goods
Judy's
Total
15
16 25-Nov
Mary
Toys
1774
364.15
Mary's
Total
17
52.95
81.60
1160
18 22-Nov
19 23-Nov
Susan
Susan
Electronics
Cards
Others
1075
1745
132.95
20 23-Nov
Susan
1662 2,580.10
Sports
goods
21 24-Nov
Susan
Susan's
Total
22
23
Grand
Total
24
(i). Calculate the totals for each salesperson and get the grand total using
a formula.
(ii). Format the worksheet as follows:
Make all the Totals bold, two decimal places, comma, center the title
across columns A-E and make it size 16, bold and Italic.
(iii). Put a double border round the whole table and a single line border
inside the table.
(iv). Save the worksheet as Stationery Analysis.
expand button
Transcribed Image Text:PRACTICAL EXERCISE 1.2 Enter the data given below into a worksheet. E Stationery Supplies Ltd 2. Receipt Amount Date SalesPerson Item No Toys Stationery Toys 1238 1,782.10 1255 4,853.55 51.35 21-Nov Carl 26-Nov Carl Carl 1395 26-Nov Carl's Total 1141 91.16 Cards 21-Nov 24-Nov 10 21-Nov John John John 1982 442.60 Books 9 561.50 62.75 1885 Toys Toys 1875 11 26-Nov John John's Total 12 234.50 472.60 1032 Judy Judy Books 13 22-Nov 14 26-Nov 1920 Sports goods Judy's Total 15 16 25-Nov Mary Toys 1774 364.15 Mary's Total 17 52.95 81.60 1160 18 22-Nov 19 23-Nov Susan Susan Electronics Cards Others 1075 1745 132.95 20 23-Nov Susan 1662 2,580.10 Sports goods 21 24-Nov Susan Susan's Total 22 23 Grand Total 24 (i). Calculate the totals for each salesperson and get the grand total using a formula. (ii). Format the worksheet as follows: Make all the Totals bold, two decimal places, comma, center the title across columns A-E and make it size 16, bold and Italic. (iii). Put a double border round the whole table and a single line border inside the table. (iv). Save the worksheet as Stationery Analysis.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman