Assume that you enter data in cell a6 and press tab then...

Name: assume that you enter data in cell a6 and press tab then enter data in cell b6 and press tab then enter data in cell c6 and press enter which cell will you find yourself in sports store inve 83378
Uploaded: 2024-01-18T07:33:44-08:00
Duration: 1 min 29 s
Channel: Robin Corrigan
Description: assume that you enter data in cell a6 and press tab then enter data in cell b6 and press tab then enter data in cell c6 and press enter which cell will you find yourself in sports store inve 83378

Robin Corrigan and 65 other subject Intro Stats / AP Statistics educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Key Concept

Premium Feature

Explore the core concept behind this problem.

Key Concept

Premium Feature

Explore the core concept behind this problem.

Recommended Videos

ge-132tables-and-spreadsheets-13448qx3zqy7-jump-to-level-1-what-are-the-next-three-values-if-a-user-drags-the-autofill-sguare-down-three-cells-a-1-21-2-22-3-23-4-5-6-ex50-ex50-ex50-3-31303

Jump to level 1 What are the next three values if a user drags the autofill square down three cells? A 1 21 2 22 3 23 4 5 6

Robin C.

texts-i-need-help-starting-this-excel-problem-format-cell-styles-insert-delete-format-clear-note-this-worksheet-covers-text-in-sequence-and-sort-functions-tables-and-the-use-of-sum-function-00707

I need help starting this Excel problem. Note: This worksheet covers Text in Sequence and Sort functions, Tables, and the use of SUM function and structured references. Instructions: 1. Type your first name in M2. 2. Enter your full name in D4. 3. Type the following data on this worksheet, starting with A4: - First Name - Last Name - Grade - Income 4. Enter the formula in E4. 5. Enter the following data in rows A5 to A8: - John Doe - Jane Doe - BW Smith - Bree Smith - Cary Williams 6. Create (calculate) the full name in D4 using the TextJoin function. Use a space between the first and last name (e.g. John Doe). 7. Use Autofill to complete the rest of the rows in column D (D5 to D8). 8. In cells E3 to E8, insert the income using the Sequence function. Start with a value of 50000 and increase by 1000 for each person. 9. In cell A10, use the Sort function to sort the data by first name in ascending order. 10. Copy cells A3 to E8 and paste them as values only in cell A17. 11. Calculate the total income using the SUM formula in cell E24. Use the range E18 to E22 for the income values. 12. Calculate the total income using structured references in cell E25. Refer to the Excel Help for more details on structured references. 13. Check if the income values in E24 and E25 are the same. If not, review the earlier steps for any errors. 14. Compare the formulas in E24 and E25 to ensure they are similar. Check the formula bar for both cells. 15. The formula in E5 is a structured reference. Refer to the Excel Help for more explanation. Using structured references with Excel tables: When you create an Excel table, Excel assigns a name to the table and each column header in the table. When you add formulas to an Excel table, these names can appear automatically as you enter the formula and select the cell references in the table, instead of manually entering them. Here's an example: Instead of using explicit cell references (e.g. =SUM(E18:E22)), Excel uses table and column names (e.g. SUM(Table Name[Column Name to Sum])). That combination of table and column names is called a structured reference. Answers: Looks like this. It is a screenshot from the correctly completed steps.

Akash M.

Instructions: 1) In the "credit Status" column, build a formula that can be copied down that indicates of account is "approved" or "declined" for credit. If they have a balance that is 90-days past due, they are declined. (HINT: Use IF) 2) In the penalty amount column, build a formula that can be copied that calculates the amount of a penalty, if any. If the account is 90 days late, the penalty is $200. If the account is only 60-days past due, the penalty is $50. A company should receive only one penalty. (HINT: Use nested IF formulas) 3) Complete the table at the right, based on the data in the aging. (HINT: Use COUNTIF, SUMIF, and AVERAGEIF) 4) Apply blue data bars to the total past due balance column. 5) Use conditional formatting to colour the background of the Total Balance of any customer if the Total Past Due Balance if it is greater than 20% of the Total Balance. You can choose the colour. (HINT: Remember to un-anchor the row). Sports Customer Aging Customer Name Customer Type Current Balance Due 30-Days Past Due 60-Days Past Due 90-Days Past Due Total Past Due Balance Total Balance Credit Status Penalty Amount Athletic Gear Corp. A $ 8,612 $ 0 $ 0 $ 0 $ 0 $ 8,612 Baltimore O's B 0 0 0 0 0 0 Baseball & More A 2,345 3,473 5,557 4,862 13,892 $ 16,237 Canadian Ski Club C 0 345 0 150 495 $ 495 Everything Golf B 0 0 2,000 899 2,899 $ 2,899 Sports & Stuff A 0 14,000 383 0 14,383 $ 14,383 Athletic Gear Corp. A $ 8,612 $ 0 $ 0 $ 0 $ 0 $ 8,612 Baltimore O's B 0 0 0 0 0 0 Athletic Gear Corp. A 2,345 3,473 5,557 4,862 13,892 $ 16,237 Baltimore O's C 0 345 0 150 495 $ 495 Baseball & More A 0 0 2,000 899 2,899 $ 2,899 Canadian Ski Club A 0 14,000 383 0 14,383 $ 14,383 Concord Pro Shop A $ 8,612 $ 0 $ 0 $ 0 $ 0 $ 8,612 Everything Golf B 0 0 0 0 0 0 Lake Pro Shops A 2,345 3,473 5,557 4,862 13,892 $ 16,237 Mars Dept. Store C 0 345 0 150 495 $ 495 RG Bradley A 0 0 2,000 899 2,899 $ 2,899 RX for Sports A 0 14,000 383 0 14,383 $ 14,383 School Sports Supply A $ 8,612 $ 0 $ 0 $ 0 $ 0 $ 8,612 Ski World B 0 0 0 0 0 0 Sneaker Kingdom A 2,345 3,473 5,557 4,862 13,892 $ 16,237 Sports & Stuff C 0 345 0 150 495 $ 495 Toy Kingdom A 0 0 2,000 899 2,899 $ 2,899 Under the Sea A 0 14,000 383 0 14,383 $ 14,383 Customer Type # of Customers Total Balance Average Balance A B C

Akash M.

Transcript

00:01 Here we are asked, what are the next three values if the user drags the autofill square down three cells? so we have three cells that are highlighted, or that are selected in the box, 21, 22, and 23.

00:17 And we have the autofill square at the bottom right of the selection.

00:21 And so this will be dragged down over the next three rows.

00:26 So what values will end up in these three cells? cells.

00:31 So it looks at these three cells and sees increments of one across the cells.

00:37 So it would go from 21, add one to 22, add one to 23...

Question

Please give Ace some feedback