Question

1. How should Excel categorize telephone numbers: as text, numbers, or dates and times? Why? 2....

1. How should Excel categorize telephone numbers: as text, numbers, or dates and times? Why?

2. How should Excel identify social security numbers?

3. When does Flash Fill work best?
Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

1.

Answer

Text

Explanation

Excel categorize telephone numbers as text
The reason is that telephone numbers they have some special characters in them that is dash(-) but it cannot be used in calculation

--

2.

Answer

Text

Explanation

Excel categorize social security numbers as text
The reason is that social security numbers they have some special characters in them that is parentheses() and dash(-) but it cannot be used in calculation

3.

When there is certain kinds of pattern is obviously recognized from the values in the Excel

Example

--

all the best

please upvote

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How should excel categorize your name? As text, numbers or dates & times? How should excel...
How should excel categorize your name? As text, numbers or dates & times? How should excel identify social security number? How should excel categorize dates like April 15, 2017?
1. NPV According to the text, the NPV rule states that "An investment should be accepted...
1. NPV According to the text, the NPV rule states that "An investment should be accepted if the NPV is positive and rejected if it is negative." What does an NPV of zero mean? If you were a decision-maker faced with a project with a zero NPV (or very close to zero) what would you do? Why? 2. FORECASTING ERROR (RISK) What is a "forecasting error"? Why is it important to the analysis of capital expenditure projects? please, original work.
If you were to roll 3 die, how many even numbers should you expect to show...
If you were to roll 3 die, how many even numbers should you expect to show up? Perform this experiment 16 times where you roll 3 die and record the number of evens that show up in each trial. Then answer the following questions: 1) How does this game satisfy a binomial distribution? 2) Determine the probability of each outcome based on the results of your experiment and then determine what the actual probability should be using the binomial probability...
In Chapter 1 of the text we looked at calculating a monthly payment for a loan....
In Chapter 1 of the text we looked at calculating a monthly payment for a loan. A related formula is to calculate the amount accruing when regular payments are made into an interest bearing account - often called the Savings Plan formula. (A is the accrued amount after t years of making regular payments, PMT, into an account at interest rate, r%, compounded n times each year.)         A(t) = PMT·((1 + r/N)N·t - 1)/(r/N)                  = PMT*((1 + r/N)^(N*t) -...
1. How does Gandhi perceive self-sustained "village"? Why should it function as a republic? 2. How...
1. How does Gandhi perceive self-sustained "village"? Why should it function as a republic? 2. How could globalization be a special "developmental measure" for India? Who could benefit from it? 3. How is India's process of globalization different from the Gandhian model of national development?
1) If you are a creditor, should you perfect your security interest and why? 2) What...
1) If you are a creditor, should you perfect your security interest and why? 2) What if there are two perfected security interests on the same property?  Which interest comes first? 3) What is the automatic stay in bankruptcy?
1.     Prompt 1: How does social referencing work? Can you give an example? When is social referencing...
1.     Prompt 1: How does social referencing work? Can you give an example? When is social referencing useful and when is it not? Why would you not want to use social referencing when responding to a toddler who has just taken a spill? 2.     Prompt 2: Can you give an example of a cultural script? Do you have any cultural scripts? What are they? 3.     Prompt 3: Make up a scene involving the RERUN process of problem solving.
1- How hard should Instagram, or any other social media company, work to eliminated bots? 2-...
1- How hard should Instagram, or any other social media company, work to eliminated bots? 2- Suppose a social media startup decides to become a publicly traded company? It hasn't been profitable yet. a) Does it have a legal and ethical obligation to find out how many of its users are bots? b) Is there a way for investors to determine how many users are bots? How?
1. Should Pi Day, March 14, be a national holiday? A telephone poll of 1058 adults...
1. Should Pi Day, March 14, be a national holiday? A telephone poll of 1058 adults ages 18 and older Americans living in all 50 states and the District of Columbia found that 149 said yes to this question. What is the populations for the sample of this survey? What is the sample? 2. A poll called 2500 random phone numbers and asked to speak to an adult member of the household. The pollster asks “How many times in the...
1. What is the competitive balance argument for why student-athletes should not be paid? 2. How...
1. What is the competitive balance argument for why student-athletes should not be paid? 2. How does the ceiling on the pay to student-athletes impact competitive balance in college sports?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT