| ID | Description | Date Acquired | Life | End of Life | Location | Status | Service | Value |
| 1064 | Tower | 1/8/14 | 5 | 1/7/19 | Tundra | R | Y | $ 350.00 | | | | | Using Functions: | | | | Criteria: |
| 1025 | Server | 5/24/09 | 8 | 5/22/17 | Hoffman | A | Y | $ 12,000.00 |
| 1026 | Keyboard | 11/26/14 | 2 | 11/25/16 | Hoffman | A | N | $ 60.00 | | | | | | 1020 |
| 1024 | Tower | 11/26/14 | 5 | 11/25/19 | Tundra | A | Y | $ 475.00 | | | | | What is the Life of ID 1020? | | | | How many have a Date Acquired between 5/1/2016 and 6/1/2016? |
| 1027 | Tower | 11/26/14 | 5 | 11/25/19 | Tundra | A | Y | $ 475.00 | | | | | | 1044 |
| 1029 | Keyboard | 11/26/14 | 2 | 11/25/16 | Hoffman | A | N | $ 60.00 | | | | | What is the Description of ID 1044? | | | | How many have a Description of Monitor or have a Status of R? |
| 1028 | Tower | 11/26/14 | 5 | 11/25/19 | Tundra | A | Y | $ 475.00 |
| 1030 | Tower | 11/26/14 | 5 | 11/25/19 | Hoffman | A | Y | $ 500.00 | | | | | Create a header for Column J called Commission. | | | | How many have a Description of Tower or Keyboard? |
| 1032 | Keyboard | 8/28/16 | 2 | 8/28/18 | Hoffman | R | N | $ 55.00 | | | | | Calculate the Commission as 3% of the Value if |
| 1033 | Monitor | 11/26/14 | 5 | 11/25/19 | Hoffman | A | N | $ 150.00 | | | | | Status is R and Value is greater than $250. If not, |
| 1034 | Monitor | 11/26/14 | 5 | 11/25/19 | Tundra | A | N | $ 120.00 | | | | | No Commission. |
| 1031 | Tower | 11/26/14 | 5 | 11/25/19 | Hoffman | A | Y | $ 500.00 |
| 1036 | Monitor | 5/4/16 | 5 | 5/3/21 | Tundra | R | N | $ 495.00 | | | | | Create a header for Column K called Discount. |
| 1042 | Tower | 11/26/14 | 5 | 11/25/19 | Tundra | A | Y | $ 475.00 | | | | | Calculate that will be a Discount if the Description is | | | | Criteria |
| 1038 | Monitor | 11/26/16 | 5 | 11/25/21 | Hoffman | A | N | $ 150.00 | | | | | Monitor or Value is greater than $400. If not, No Discount | | | | Total Value if there is no discount. |
| 1043 | Tower | 11/26/14 | 5 | 11/25/19 | Hoffman | A | Y | $ 500.00 |
| 1040 | Keyboard | 11/26/14 | 2 | 11/25/16 | Tundra | A | N | $ 90.00 | | | | | | | | | Total Value if Location and Description have 7 characters. |
| 1041 | Keyboard | 11/26/14 | 2 | 11/25/16 | Tundra | A | N | $ 90.00 | | | | | In Column L (Label Header "# of Days"), calculate the # of |
| 1049 | Tower | 11/26/14 | 5 | 11/25/19 | Hoffman | A | Y | $ 500.00 | | | | | days between End of Life and current date. | | | | Total Value if Life is 2 or Service is Y |
| 1053 | Tower | 11/26/14 | 5 | 11/25/19 | Hoffman | A | Y | $ 500.00 |
| 1044 | Server | 6/18/10 | 8 | 6/16/18 | Tundra | R | Y | $ 12,000.00 |
| 1045 | Server | 7/21/12 | 8 | 7/19/20 | Tundra | R | Y | $ 11,500.00 |
| 1046 | Monitor | 11/26/14 | 5 | 11/25/19 | Hoffman | R | N | $ 100.00 |
| 1047 | Monitor | 11/26/14 | 5 | 11/25/19 | Tundra | A | N | $ 120.00 |
| 1048 | Monitor | 8/28/16 | 5 | 8/27/21 | Tundra | A | N | $ 110.00 |
| 1061 | Tower | 11/26/14 | 5 | 11/25/19 | Hoffman | A | Y | $ 500.00 |
| 1050 | Monitor | 11/26/14 | 5 | 11/25/19 | Tundra | A | N | $ 120.00 |
| 1051 | Keyboard | 11/26/14 | 2 | 11/25/16 | Hoffman | A | N | $ 60.00 |
| 1052 | Monitor | 3/24/16 | 5 | 3/23/21 | Tundra | A | N | $ 125.00 |
| 1065 | Tower | 11/26/14 | 5 | 11/25/19 | Tundra | A | Y | $ 475.00 |
| 1054 | Server | 8/12/16 | 8 | 8/10/24 | Tundra | A | Y | $ 9,000.00 |
| 1055 | Keyboard | 11/26/14 | 2 | 11/25/16 | Tundra | A | N | $ 90.00 |
| 1056 | Monitor | 11/26/14 | 5 | 11/25/19 | Hoffman | A | N | $ 150.00 |
| 1057 | Server | 1/8/13 | 8 | 1/6/21 | Tundra | A | Y | $ 11,000.00 |
| 1058 | Monitor | 11/26/14 | 5 | 11/25/19 | Tundra | R | N | $ 120.00 |
| 1059 | Monitor | 8/28/16 | 5 | 8/27/21 | Tundra | A | N | $ 110.00 |
| 1060 | Monitor | 11/26/14 | 5 | 11/25/19 | Hoffman | A | N | $ 150.00 |
| 1068 | Tower | 11/26/14 | 5 | 11/25/19 | Tundra | A | Y | $ 475.00 |
| 1062 | Keyboard | 11/26/14 | 2 | 11/25/16 | Tundra | A | N | $ 90.00 |
| 1063 | Keyboard | 11/26/14 | 2 | 11/25/16 | Tundra | A | N | $ 90.00 |
| 1090 | Tower | 12/11/14 | 5 | 12/10/19 | Hoffman | R | Y | $ 450.00 |
| 1035 | Tower | 8/28/16 | 5 | 8/27/21 | Tundra | A | Y | $ 450.00 |
| 1066 | Keyboard | 9/7/14 | 2 | 9/6/16 | Tundra | R | N | $ 85.00 |
| 1067 | Monitor | 8/28/16 | 5 | 8/27/21 | Tundra | A | N | $ 110.00 |
| 1037 | Tower | 8/28/16 | 5 | 8/27/21 | Tundra | A | Y | $ 450.00 |
| 1069 | Keyboard | 11/26/14 | 2 | 11/25/16 | Hoffman | A | N | $ 60.00 |
| 1070 | Keyboard | 11/26/14 | 2 | 11/25/16 | Hoffman | A | N | $ 60.00 |
| 1039 | Tower | 8/28/16 | 5 | 8/27/21 | Tundra | A | Y | $ 450.00 |
| 1071 | Tower | 8/28/16 | 5 | 8/27/21 | Tundra | A | Y | $ 450.00 |
| 1072 | Tower | 8/28/16 | 5 | 8/27/21 | Tundra | A | Y | $ 450.00 |
| 1074 | Server | 6/1/09 | 8 | 5/30/17 | Hoffman | R | Y | $ 8,000.00 |
| 1075 | Monitor | 11/26/14 | 5 | 11/25/19 | Tundra | A | N | $ 120.00 |
| 1076 | Monitor | 11/26/14 | 5 | 11/25/19 | Tundra | A | N | $ 120.00 |
| 1077 | Monitor | 8/28/14 | 5 | 8/27/19 | Tundra | A | N | $ 110.00 |
| 1078 | Multifunction | 8/28/16 | 5 | 8/27/21 | Hoffman | A | N | $ 600.00 |
| 1079 | Multifunction | 7/17/16 | 5 | 7/16/21 | Tundra | R | N | $ 600.00 |
| 1080 | Monitor | 11/26/14 | 5 | 11/25/19 | Hoffman | A | N | $ 150.00 |
| 1081 | Keyboard | 11/26/14 | 2 | 11/25/16 | Hoffman | A | N | $ 60.00 |
| 1082 | Monitor | 8/28/16 | 5 | 8/27/21 | Tundra | R | N | $ 110.00 |
| 1083 | Monitor | 8/28/16 | 5 | 8/27/21 | Tundra | A | N | $ 110.00 |
| 1084 | Monitor | 8/28/16 | 5 | 8/27/21 | Tundra | A | N | $ 110.00 |
| 1085 | Monitor | 11/26/14 | 5 | 11/25/19 | Hoffman | A | N | $ 150.00 |
| 1086 | Keyboard | 8/28/16 | 2 | 8/28/18 | Tundra | A | N | $ 85.00 |
| 1087 | Keyboard | 8/28/16 | 2 | 8/28/18 | Tundra | R | N | $ 85.00 |
| 1088 | Keyboard | 8/28/16 | 2 | 8/28/18 | Tundra | A | N | $ 85.00 |
| 1089 | Keyboard | 8/28/16 | 2 | 8/28/18 | Tundra | A | N | $ 85.00 |
| 1073 | Tower | 8/28/16 | 5 | 8/27/21 | Tundra | A | Y | $ 450.00 |
| 1091 | Multifunction | 8/28/16 | 5 | 8/27/21 | Tundra | A | N | $ 600.00 |
| 1092 | Keyboard | 8/28/16 | 2 | 8/28/18 | Tundra | A | N | $ 85.00 |
| 1093 | Keyboard | 8/28/16 | 2 | 8/28/18 | Tundra | A | N | $ 85.00 |
| 1094 | Keyboard | 11/26/14 | 2 | 11/25/16 | Tundra | A | N | $ 90.00 |
| 1095 | Laptop | 8/10/16 | 5 | 8/9/21 | Tundra | A | Y | $ 500.00 |
| 1096 | Laptop | 8/10/16 | 5 | 8/9/21 | Hoffman | A | Y | $ 500.00 |
edddiemayorga
Quiz-ThursJun232022.xlsx
