+1 223-217-0404 info@assignmenthero.net

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

Related Articles

Management | Module 4 Assignment in Word Format

RULE OF THUMB If a question is worth 10 points, then I'm looking for 10 quality sentences as a minimum. I welcome more discussion as opposed to less, but this rule of thumb seems to get at a minimum that reaches a quality level that I desire. Also, be sure that you...

read more

English | Final Exam

THE FINAL IS AN ESSAY THAT YOU WILL WRITE AND SUBMIT. I WILL NOT TELL YOU THE TOPIC IN ADVANCE SINCE IT IS A TEST AND YOU CAN ONLY FIND OUT THE TOPIC ONCE THE TIMER STARTS. YOU MUST MAKE SURE THAT YOU HAVE AT LEAST 120 MINUTES AT YOUR DISPOSAL WHEN YOU START TO TAKE...

read more

| Feedback and Support

VIGNETTE 6.1 Sally and Cris, both supervised by Nicole, work with a 12-year-old boy with autism. Both recently finished their first graduate-level course in behavior analysis, titled Principles of Applied Behavior Analysis. Sally excelled in the class, whereas Cris...

read more
GET A FREE QUOTE