\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch \newcommand\bar{\unit{bar}} \end{aligned}\end{align} \]

Oct 24, 2024 | 432 words | 4 min read

2.1.2. Task 0

Learning Objectives

By the end of this task, you will be able to navigate the MS Excel interface with ease, apply basic functions such as SUM, AVERAGE, MIN, and MAX, and use the IF function to incorporate conditional logic into your worksheets. You will gain proficiency in using the Function Wizard to efficiently insert and modify various functions, as well as develop the ability to identify and resolve common formula errors like #DIV/0! and #VALUE!. Through practical exercises, you will perform basic data analysis, applying logical operations to solve real-world problems. Ultimately, this task will provide you with a solid foundation in MS Excel, equipping you with the skills necessary for effective data management and analysis.

Task Instructions

1. Open the exercise sheet ex2_pre_1_username.xlsx. Save it with your Purdue username replacing username in the file name.

2. Fill in the header information and list any collaborators as requested. Click Next to move forward.

3. Basics of Excel Calculations - This sheet will guide you through performing basic mathematical operations in Excel, such as addition, subtraction, multiplication, and division. Click Next to move forward.

4. Introduction to Functions - learn how to use basic Excel functions like AVERAGE, MIN, and MAX to analyze data. Follow the instructions provided in the sheet to complete each task. Click Next to continue.

5. Conditional Logic with IF Statements - This sheet will introduce you to using the IF function to apply conditional logic in Excel. You’ll be guided through creating statements that return different results based on specified conditions. Complete the tasks as directed and click Next to proceed.

6. Using the Function Wizard - This section will help you understand how to use the Function Wizard to find and insert Excel functions. It provides a step-by-step guide for using the wizard to perform tasks like VLOOKUP. After completing the tasks, click on the links provided to explore more functions and their uses.

7. Handling Formula Errors - Here, you’ll learn how to identify and fix common formula errors in Excel. The sheet includes examples of errors like #DIV/0! and #VALUE!, with explanations on how to resolve them. Click Next or follow the provided links to learn more.

8. From the desktop version of MS Excel, print the spreadsheet to a PDF by selecting File ‣ Print. Before you print, adjust the scaling settings to fit all the information on a single page per sheet as if you are preparing for a technical presentation. Then save the PDF in your Excel_2 folder with the file name ex2_pre_1_username.pdf. Please refer to Task 3 in Team Assignments for printing as pdf.

   Note

   When following the steps to print this file, be sure to select “Fit Sheet on One Page” setting for each page, finally giving you 10 pages.

   

   Fig. 2.1 Initial number of pages.

   

   Fig. 2.2 Final number of pages, after scaling each page to “Fit Sheet on One Page”.