09 Excel 3 Demo 1-If Statements, Conditional Formatting & Text Functions
- Due Nov 3, 2022 by 11:59pm
- Points 15
- Submitting a file upload
Assignment Overview
You will be practicing if statements, conditional formatting and using a variety of text function in Excel
- Watch and follow along with the demonstration videos to complete the assignment.
- Each demo builds on the previous one
- You will then submit the completed Excel 3 Demo 1 file
Guidelines
To insure full credit for your assignment, make sure to compare it to the demo files and then once uploaded to Canvas, double check your submission.
Turn In: Turn in your completed .xlsx document Lastname Firstname Excel 3 Demo 1 data.xlsx
Video: Excel 3 Demo 1a
Links to an external site.
Video: Excel 3 Demo 1b
Video: Excel 3 Demo 1c
Links to an external site.
OneDrive Link for files needed for assignments
Links to an external site.
Technical Support
Need help using Canvas Assignments? If so, please review the following guide:
Rubric
Please include a title
Criteria | Ratings | Pts | |
---|---|---|---|
Excel 3 Demo 1 data.xlsx uploaded to Canvas
threshold:
pts
|
pts
--
|
||
If Practice Sheet completed
threshold:
pts
|
pts
--
|
||
Fabrikam Sales Completed
threshold:
pts
|
pts
--
|
||
Fabrikam Alarm Codes (text functions) completed
threshold:
pts
|
pts
--
|
||
Total Points:
15
out of 15
|