Scribd
Upload
70 views1 page

Excel Exercise 3.2 - Formulas

The document provides instructions for completing an Excel exercise involving various formulas and functions: inserting the current date formula, calculating percentages using absolute references, IF statements, conditional formatting, concatenating names, COUNTIF formula, and freeze panes. Learners are asked to download a data file, insert formulas to determine today's date and percentages, concatenate product names, use IF statements to determine discounts, count drills using COUNTIF, apply conditional formatting, and freeze panes. The completed exercise is to be saved and uploaded for submission.

Uploaded by

andre
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
70 views1 page

Excel Exercise 3.2 - Formulas

The document provides instructions for completing an Excel exercise involving various formulas and functions: inserting the current date formula, calculating percentages using absolute references, IF statements, conditional formatting, concatenating names, COUNTIF formula, and freeze panes. Learners are asked to download a data file, insert formulas to determine today's date and percentages, concatenate product names, use IF statements to determine discounts, count drills using COUNTIF, apply conditional formatting, and freeze panes. The completed exercise is to be saved and uploaded for submission.

Uploaded by

andre
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

EXCEL EXERCISE 3.

2
OUTCOMES-FORMULA’s
 Inserting “Todays Date” Formula
 Calculating Percentages using Absolute Reference (F4-Key) / AutoFill
 IF Formula/Statement
 Conditional Formatting
 Concatenate Formula: Joining/Combining of Names/Words/Phrases etc.
 Count-If Formula
 Freeze Panes
……………………………………………………………………………………………………………………………………………………………………………………
Instructions:
 Download and Open the Excel File Named: Excel Exercise_Powertools_Data File, and complete as below:
 In Cell B:16, (Highlighted in Yellow), use a Formula to determine “Today’s Date”.
 In Cell D:13, Determine the Grand Total (D:3 to D:11) and apply Bold/Italics to the Cell.
 In Column C3 (Combined Products Names), use a Formula to Join A3 (Product First Name) and B3 (Product
Second Name), With a “Space” In between the Two names. Clue: Use the Concatenate Formula. Use the AutoFill
Feature to apply it to the Rest of the Combined Products Name’s, Vertically/Down (C:4 to C:11).
 In the Discount “Yes” or “No” Column (E:3 to E:11), Use an If Statement Formula, to Determine if a Customer/s
Purchase a Product that Cost More Than (>) R500 (In Column D-Total of Each Product), then That Customer/s
will Receive a “Discount”. If a Customer/s Purchase a Product Less Than (<) R500, then That Customer/s will
Receive “No Discount”.
 In Column F:3 (% of Each Product), Determine the % of Each Total Product in D:3 to D:11 By Dividing each
Product from the Grand Total in Cell D:13. Convert Column F:3 to F:11 to % and Use the Special “Absolute
Referencing Key” Feature (On your Keyboard) to apply your Formula. Auto Fill the rest of the Percentages
Vertical/Down from F:4 to F:11.
 In Cell B:18, (Highlighted in Blue), Use the “COUNTIF” Formula to Count the Number of “Drills” In Column B:3 to
B:11.
 Use Conditional Formatting to in Cell E:3 to E:11 to Highlight the Text That Contains “No Discount”, Using Green
Fill with Dark Green Text.
 In the View Tab (Toolbars) Use the Freeze Pane Feature to “Freeze” the First Two Rows (Main Heading and Sub
Headings). Scroll with your Mouse to “see” if the First Two Rows “Stand Still”.
 Save your Exercise as: Surname_StudentNo_YourGroup_Powertools and; Close/Exit.
 Upload your Above File/Exercise to Blackboard: Activity Submission Tab_All Excel Submissions Folder_Excel
Basic Formulas Exercise Folder_Excel Exercise 4 Submission Link

Your Possible Solution should like this:

You might also like