YEAR Y W R L K
1948 1.214 0.243 0.1454 1.415 0.612 Attempt all the questions given
1949 1.354 0.26 0.2181 1.384 B 0.559
1950 1.569 0.278 0.3157 1.388 0.573
1951 1.948 0.297 0.394 1.55 0.564
1952 2.265 0.31 0.3559 1.802 0.574
1953 2.731 0.322 0.3593 1.926 0.711 Apply the formulas in highlight
1954 3.025 0.335 0.4025 1.964 0.776 Q. 1 How many numbers are the
1955 3.562 0.35 0.3961 2.116 0.827 Q. 2 How many blanks are there
1956 3.979 0.361 0.3822 2.435 Q. 3 How many non blank cells a
1957 4.42 0.379 0.3045 2.707 0.921
1958 4.563 0.391 0.3284 2.706 1.067
1959 5.385 0.426 0.3856 2.846 1.083
1960 5.554 0.441 0.3193 3.089 1.481
1961 5.465 0.46 0.3079 3.122 1.736
1962 5.825 0.485 0.3783 3.184
1963 6.876 0.506 0.418 3.263 2.041
1964 7.823 0.538 0.5163 3.412 1.997
1965 9.12 0.564 0.5879 3.623 2.257
1966 10.512 0.586 0.5369 4.074 2.742
1967 13.02 0.622 0.4443 4.71 3.564
1968 15.261 0.666 0.3052 5.217 4.767
1969 16.313 0.731 0.2332 5.569 6.511??
1970 16.002 0.831 0.1883 5.495 7.627
1971 15.876 0.906 0.2023 5.334 8.673
1972 16.662 1 0.2506 5.345 8.331
1973 17.014 1.056 0.2668 5.662 8.557
1974 19.305 1.131 0.2664 5.729 9.5P08
1975 18.721 1.247 0.2301 5.722 9.062
1976 19.25 1.375 0.3452 5.762 8.262
1977 20.647 1.544 0.4508 5.877
1978 22.726 1.703 0.5877 6.108 7.104
1979 23.619 1.779 0.5346 6.852 6.874
pt all the questions given on sheet 1 and sheet 2.
the formulas in highlighted cells in front of the questions
How many numbers are there in Range K? 29
How many blanks are there in Range K? 3
How many non blank cells are there in range K? 26
OrderDate Region Rep Item Units Unit Cost Total
9/1/14 Central Smith Desk 2 125.00 250.00 Apply the formulas in high
6/17/15 Central Kivell Desk 5 125.00 625.00 Q. 4
9/10/15 Central Gill Pencil 7 1.29 9.03 Q. 5
11/17/15 Central Jardine Binder 11 4.99 54.89 Q. 6
10/31/15 Central Andrews Pencil 14 1.29 18.06 Q. 7
2/26/14 Central Gill Pen 27 19.99 539.73 Q. 8
10/5/14 Central Morgan Binder 28 8.99 251.72
Q. 9
12/21/15 Central Andrews Binder 28 4.99 139.72
2/9/14 Central Jardine Pencil 36 4.99 179.64
8/7/15 Central Kivell Pen Set 42 23.95 1,005.90
1/15/15 Central Gill Binder 46 8.99 413.54
1/23/14 Central Kivell Binder 50 19.99 999.50 Q. 10
3/24/15 Central Jardine Pen Set 50 4.99 249.50
5/14/15 Central Gill Pencil 53 1.29 68.37
7/21/15 Central Morgan Pen Set 55 12.49 686.95
4/10/15 Central Andrews Pencil 66 1.99 131.34
12/12/14 Central Smith Pencil 67 1.29 86.43
4/18/14 Central Andrews Pencil 75 1.99 149.25
5/31/15 Central Gill Binder 80 8.99 719.20
2/1/15 Central Smith Binder 87 15.00 1,305.00
5/5/14 Central Jardine Pencil 90 4.99 449.10
6/25/14 Central Morgan Pencil 90 4.99 449.10
12/4/15 Central Jardine Binder 94 19.99 1,879.06
11/25/14 Central Kivell Pen Set 96 4.99 479.04
2/18/15 East Jones Binder 4 4.99 19.96
11/8/14 East Parent Pen 15 19.99 299.85
9/18/14 East Jones Pen Set 16 15.99 255.84
7/12/14 East Howard Binder 29 1.99 57.71
8/15/14 East Jones Pencil 35 4.99 174.65
4/1/14 East Jones Binder 60 4.99 299.40
6/8/14 East Jones Binder 60 8.99 539.40
7/4/15 East Jones Pen Set 62 4.99 309.38
10/22/14 East Jones Pen 64 8.99 575.36
12/29/14 East Parent Pen Set 74 15.99 1,183.26
7/29/14 East Parent Binder 81 19.99 1,619.19
1/6/14 East Jones Pencil 95 1.99 189.05
4/27/15 East Howard Pen 96 4.99 479.04
8/24/15 West Sorvino Desk 3 275.00 825.00
3/7/15 West Sorvino Binder 7 19.99 139.93
5/22/14 West Thompson Pencil 32 1.99 63.68
3/15/14 West Sorvino Pencil 56 2.99 167.44
10/14/15 West Thompson Binder 57 19.99 1,139.43
9/27/15 West Sorvino Pen 76 1.99 151.24
Apply the formulas in highlighted cells in front of the questions
Sum of units (column E) using SUM function 2121
Average of Unit Cost (Column F) using Average function 20.31
Find the maximum number of units (Column E) by using Max fumnction 96
Find the lowest Unit cost (Column F) by using MIN function 1.29
Mention Today's date by using short cut key 8/9/2023
In Total (Column G), there is the formula. Remove the formula from entire
column G by using Paste Special
Google
[Link]
