MBA6320_HW1_Edwards

.xlsx

School

Ohio University, Main Campus *

*We aren’t endorsed by this school

Course

6320

Subject

Chemistry

Date

Feb 20, 2024

Type

xlsx

Pages

28

Uploaded by ProfSummer15147

Report
Copyright © Dr. Young and Question 1. The correct hot key combination to select cells in a column in Excel is 2. The correct hot key to select the correct absolute/relative settings is 3. The correct absolute/relative setting to make both the column and row absolute is 4. The correct absolute/relative setting to make only the column absolute is 5. The correct absolute/relative setting to make only the row absolute is 6. The correct absolute/relative setting to make both the column and row relative is 7. The correct hot key combination to copy a formula down is 8. If you are asked to compute the mean, what Excel function should you use 9. To find the largest value in a column, which function should you use 10. Numbers obtained as a result of measurements are Copyright © Dr. Young and
d Professor Goodnite. All rights reserved. Answer Ctrl Shift Down Arrow F4 $A$1 $A1 A$1 A1 Ctrl D AVERAGE MAX Continuous numbers d Professor Goodnite. All rights reserved.
Periodic Table I I 1 H 1.008 Hydrogen II II 3 4 Li Be 6.941 9.012 Lithium Beryllium III 11 12 Na Mg 22.990 24.305 Sodium Magnesium III IV V VI VII VIII IX IV 19 20 21 22 23 24 25 26 27 K Ca Sc Ti V Cr Mn Fe Co 39.098 40.078 44.956 47.880 50.942 51.996 54.938 55.847 58.933 Potassium Calcium Scandium Titanium Vanadium Chromium Manganese Iron Cobalt V 37 38 39 40 41 42 43 44 45 Rb Sr Y Zr Nb Mo Tc Ru Rh 85.468 87.620 88.906 91.224 92.906 95.940 (98) 101.070 102.906 Rubidium Strontium Yttrium Zirconium Niobium Molybdenum Technetium Ruthenium Rhodium VI 55 56 Rare Earth (below) 72 73 74 75 76 77 Cs Ba Hf Ta W Re Os Ir 132.905 137.327 180.948 180.948 183.850 186.207 190.230 192.220 Cesium Barium Hafnium Tantalum Tungsten Rhenium Osmium Iridium VII 87 88 104 105 106 107 108 109 Fr Ra Rf Db Sg Bh Hs Mt (223) 226.025 (261) (262) (263) (262) (265) (266) Francium Radium Rutherfordium Dubnium Seaborgium Bohrium Hassium Meitnerium Legend Non-Metal Alkali Metals 57 58 59 60 61 62 Alkaline Earth Metals La Ce Pr Nd Pm Sm Transition Metals 138.906 140.115 140.908 144.240 (145) 150.360 Other Metals Lanthanum Cerium Praseodymium Neodymium Promethium Samarium Metalloids 89 90 91 92 93 94 Halogen Ac Th Pa U Np Pu Noble Gases 227.028 232.038 231.036 238.029 237.048 (244) Rare Earth Actinium Thorium Protactinium Uranium Neptunium Plutonium
of Elements XVIII 2 He 4.003 XIII XIV XV XVI XVII Helium 5 6 7 8 9 10 B C N O F Ne 10.811 12.011 14.007 15.999 18.998 20.180 Boron Carbon Nitrogen Oxygen Flourine Neon 13 14 15 16 17 18 Al Si P S Cl Ar 26.982 28.086 30.974 32.066 35.453 39.948 X XI XII Aluminum Silicon Phosphorous Sulfur Chlorine Argon 28 29 30 31 32 33 34 35 36 Ni Cu Zn Ga Ge As Se Br Kr 58.690 63.546 65.390 69.723 72.610 74.922 78.960 79.904 83.800 Nickel Copper Zinc Gallium Germanium Arsenic Selenium Bromine Krypton 46 47 48 49 50 51 52 53 54 Pd Ag Cd In Sn Sb Te I Xe 106.420 107.868 112.411 114.818 118.710 121.750 127.600 126.904 131.290 Palladium Silver Cadmium Indium Tin Antimony Tellurium Iodine Xenon 78 79 80 81 82 83 84 85 86 Pt Au Hg Tl Pb Bi Po At Rn 195.080 196.967 200.590 204.383 207.200 208.980 (209) (210) (222) Platinum Gold Mercury Thallium Lead Bismuth Polonium Astatine Radon 110 111 112 Uum Uuu Uub (269) (272) (272) Ununnillum Unununium Ununbium 63 64 65 66 67 68 69 70 71 Eu Gd Tb Dy Ho Er Tm Yb Lu 151.965 157.250 158.925 162.500 164.930 167.260 168.934 173.040 174.967 Europium Gadolinium Terbium Dysprosium Holmium Erbium Thulium Ytterbium Lutetium 95 96 97 98 99 100 101 102 103 Am Cm Bk Cf Es Fm Md No Lr (243) (247) (247) (251) (252) (257) (258) (259) (260) Americium Curium Berkelium Californium Einsteinium Fermium Mendelevium Nobelium Lawrencium
Given Data Invoice Number State Distributor Product Line Sales Amount 1259847 Indiana Gamma $6,874.04 1259848 Illinois Eta $10,781.26 1259849 Indiana Eta $2,580.52 1259850 Ohio Delta $7,959.09 1259851 Ohio Eta $7,157.01 1259852 Illinois Gamma $4,241.67 1259853 Ohio Gamma $2,243.36 1259854 Ohio Alpha $3,648.19 1259855 Indiana Beta $2,306.51 1259856 Indiana Delta $9,448.73 1259857 Indiana Alpha $2,003.26 1259858 Ohio Beta $1,128.13 1259859 Ohio Eta $3,096.91 1259860 Indiana Gamma $4,137.43 1259861 Ohio Eta $2,003.26 1259862 Illinois Eta $947.54 1259863 Ohio Alpha $1,136.03 1259864 Illinois Gamma $4,831.09 1259865 Illinois Eta $5,475.40 1259866 Indiana Delta $9,681.83 1259867 Illinois Delta $2,144.27 1259868 Illinois Alpha $2,098.17 1259869 Illinois Delta $10,259.91 1259870 Indiana Eta $4,562.70 1259871 Indiana Eta $7,824.38 1259872 Indiana Beta $8,614.83 1259873 Ohio Eta $3,268.17 1259874 Indiana Alpha $5,744.69 1259875 Ohio Gamma $9,656.35 1259876 Ohio Eta $10,464.07 1259877 Illinois Eta $3,111.48 1259878 Illinois Beta $5,956.48 1259879 Indiana Gamma $7,071.80 1259880 Indiana Gamma $5,363.54 1259881 Illinois Eta $10,079.01 1259882 Ohio Delta $6,371.49 1259883 Illinois Alpha $3,384.21 1259884 Illinois Beta $5,118.80 1259885 Indiana Eta $2,886.32 1259886 Ohio Delta $10,920.75 1259887 Illinois Alpha $5,674.74
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help