CMR 282 Module 2 Review of Basic Microsoft Excel Features 1. Follow the instruction inside the excel plz CMR 282 – Module 2 Homework Review of Basic Micros

CMR 282 Module 2 Review of Basic Microsoft Excel Features 1. Follow the instruction inside the excel plz CMR 282 – Module 2 Homework
Review of Basic Microsoft Excel Features
GENERAL INSTRUCTIONS
Before you start, SAVE the workbook to a different name. Name it using your unique id – UniqueID 282 Module 2.xlsm
example, maysta 282 Module 2.xlsm
For
Be sure to save your file often. This workbook contains many sheets. Click on each tab (bottom of screen) to complete each
sheet. Follow the instructions on each sheet. You must use formulas that can be copies down/across. Formulas must
generally use cell references, not numbers.
When done, SAVE your file again.
Yellow-Shadded Tabbed Worksheets Require You to Do Something
Individual worksheets with white tabs are informational. There is nothing specific to
complete. Just read and understand the provided information.
Individual worksheets that have yellow tabs require you to do complete a task such as
create formulas.
Yellow-shaded Cells Require Formulas
This sheet is informational, and it provides an example of what a problem looks like before and after it has been
solved with formulas.
Example of a Problem that You Will Work on:
BEFORE
Region
Jan
East
123,00
Central
456,00
West
789,00
Total
1.368,00
Average
456,00
Feb
159,00
951,00
357,00
1.467,00
489,00
Mar
456,00
654,00
987,00
2.097,00
699,00
Total
738,00
2.061,00
2.133,00
4.932,00
1.644,00
Example of Your Answers:
AFTER. Click the yellow shaded cells to see the formulas.
Region
Jan
East
123,00
Central
456,00
West
789,00
Total
1.368,00
Average
456,00
Feb
159,00
951,00
357,00
1.467,00
489,00
Mar
456,00
654,00
987,00
2.097,00
699,00
Total
738,00
2.061,00
2.133,00
4.932,00
1.644,00
before and after it has been
Excel Basics Begin Here
The next several sheets provide basic Excel review information.
Columns and Rows
Columns are referenced using letters as seen across the top of the spreadsheet.
Rows are referenced using numbers as seen on the left hand of the screen.
Mathematical Operations and Symbols
Math operations
OPERATION SYMBOL
Addition
+
Subtraction
Multiplication
*
Division
/
Raising to a
^
Power
Equal
Less Than
Greater Than
Less Than or
Equal to
Greater Than or
Equal to
Not Equal
=
< >
= 14
58 < > 62
Sorting
Sort Order
Ascending
Text
A to Z
Type of Data Field
Number
Smallest to Biggest
Descending
Z to A
Biggest to Smallest
Greater than Less than
>
Greater Than
>=
Greater Than
or Equal To
< Less Than Purchase answer to see full attachment