BIS 221T Wk 3 Discussion – Microsoft® Excel®

Post a total of 3 substantive responses over 2 separate days for full participation credit.

Due Thursday

Select your group and please post a good, substantive reply with at least 100 words to one of the following questions (please copy the question’s short title at the top of your reply so we all know what you are replying to) or, on the other hand, post substantive, 100-word replies to our classmates (it’s your choice to post a new reply to the following questions or reply to a classmate instead) The total number of posts in either case must be three 100-word posts for full credit – the first post must be done by Thursday and the other two must be done at most by Monday:

SUM: How is the SUM() function used?

COPY: How is the fill handle used to copy cells? What other ways to copy cells do we have?

FORMAT: How can the contents of a cell be formatted?

CHART: How can we decide which chart type to create?

FUNCTIONS: How would you use functions MAX, MIN, or AVERAGE in a spreadsheet?

TEMPLATE: What is a spreadsheet “template” and how do we use them?

CONDITIONAL FORMAT: How do we apply conditional formatting to a cell? How would YOU use it in a spreadsheet of your own?

WIDTH-HEIGHT: How do you change the size of columns (width) and rows (height)?

MARGINS: How are printing margins, headers, and footers adjusted?

SEMI-SELECTION: How is “semi-selection”: used to create a formula?

ABSOLUTE-RELATIVE: How are relative and absolute cell references used in formulas? When should we use absolute references? When should we use relative references?

IF: How is the powerful IF() functions used? Use an example.

VLOOKUP: How is the VLOOKUP() function used? Use an example.

PMT: How is the PMT() function used to calculate payments? Use an example.

RANGE NAMES: What are range names in Excel? How are they created and maintained? How are they used?

Please remember to post at least three (3) 100-word posts for full credit. Be constructive and professional in your responses.