\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Differential \newcommand\dd[2][]{\mathrm{d}^{#1}{#2}} % use as \dd, \dd{x}, or \dd[2]{x}\\% 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{{\kern-4mu}\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{\kern-4mu}^\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 % % Capacitance \newcommand\farad{\unit{F}} \newcommand\F{\farad} \newcommand\microfarad{\micro\farad} \newcommand\muF{\micro\farad} % % 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} \]

Jan 19, 2026 | 538 words | 5 min read

9.3.1. Task 1

Learning Objectives

This task has three parts. In Part A, you will familiarize yourself with key administrative details, course resources, and expectations to set yourself up for success in the course. Parts B and C will help you build foundational skills in MS Excel, including performing calculations, using cell addressing techniques, and applying essential functions.

Part A: Policies and Resources

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

   Note

   Your Purdue username is the portion of your Purdue email address that appears before the “@” symbol.

   Example: If your email address is smith123@purdue.edu, then your username is: smith123

2. Answer all the questions in the answer sheet.

3. Save your spreadsheet as ex1_ind_1a_username.pdf.

Part B: MS Excel Calculations

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

2. Answer all the questions in the answer sheet.

3. Save your spreadsheet as ex1_ind_1b_username.pdf.

Part C: MS Excel Tutorial

1. Open the exercise sheet ex1_ind_1c_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 “Let’s go” to move forward.

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

4. Introduction to Functions - learn how to use basic MS 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 MS 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 MS 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 MS 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_1 folder with the file name ex1_ind_1c_username.pdf. Please refer to Part C: Producing PDFs 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. 9.6 Initial number of pages.

   

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

Deliverables

• You may seek help on individual tasks from classmates, the instructional team, or others but the work that you submit should always be your own.

• If you collaborate with others and use information developed together or by someone else, ALWAYS document and reference that material.

• Upload all deliverables to Gradescope as a single submission.

Table 9.6 Deliverables

Deliverables	Description
ex1_ind_1a_username.pdf	PDF of your completed MS Excel document.
ex1_ind_1b_username.pdf	PDF of your completed MS Excel document.
ex1_ind_1c_username.pdf	PDF of your completed MS Excel document.