KU Formulas Including Auto Sum, Sum, and Average Discussion

The Discussion Topic:

From your reading in the textbook, you can see there are numerous techniques that are unique to Excel. Select just one of them from THE LIST OF TECHNIQUES below, and explain why you consider it to be a valuable technique to understand how to use. It is assumed that many students are not familiar with Excel, but from the textbook readings, SimNet, and research – you can contribute upbuilding, expressive postings we can all learn from.

More than 1 student may choose the same technique from the list – that is fine, no problem at all.

DO NOT use techniques outside of this list or request to use other techniques not on the list, and do not cover more than 1 technique from the list. You will need to focus on just “one” single technique listed below so that there will be depth of material to support the discussion. NOT following these instructions will result in 0 points for your main posting and will not be re-graded.

Word Count requirements/grading rubric (100 points total):

• Main posting: at least 100 words
  • 70 points – main post
    • 40 points – Relevant
    • 10 points – spell/grammar
    • 5 points – At least 100 words
    • 5 points – Includes WC
    • 10 points – citation

• • Posting(s) to other students: at least 75 words
    • 30 points – post to at least one other student’s posts
    • 25 points – Relevant
    • 5 points – At least 75 words

• Your word count should be included at the bottom of all your posting(s).
• Also required is at least 1 cited reference to support your main posting material.
• Note: Points may be deducted at the discretion of the instructor for any of the following but not limited to:

• Quality of the postings; responses do not contribute to the conversation, are too short/trivial, and/or do not answer the posted questions.
• Postings were completed on the same day.
• Use of slang, “text-messaging speak”, poor grammar, incorrect spelling, inaccurate punctuation, and poor sentence structure.

THE LIST OF TECHNIQUES

Formulas including AutoSum, SUM, and AVERAGE

AutoFit

Charts and Graphs

Working with Sheet Names

The Fill Handle

Freeze Panes

Inserting and deleting Rows and Columns

Absolute vs. Relative addressing

Merge and Center

Hiding Rows and Columns

Sorting