Quickbooks Online Accounting
3rd Edition
ISBN: 9780357391693
Author: Owen
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Related questions
Question
Transcribed Image Text:A42
☑✓ fx
A
1 TASK
2 Name data to proper case
3 Number of characters in a text string
4 Find first 4 characters of a text string
B
C
D
E
FUNCTION TO LEARN DATA
PRACTICE
FORMULAS
PROPER
hayden anderson
#N/A
LEN
Hayden
#N/A
LEFT
Anderson
#N/A
RIGHT
Anderson
#N/A
MID
Hayden
#N/A
CONCAT
C3 and C4
#N/A
CONCAT
C3 and C4
#N/A
C3 and C4
#N/A
51085
4033
#N/A
#N/A
handerson@nowhere.edu
handerson@nowhere.edu
#N/A
#N/A
5 Find final 3 characters of a text string
6 Get three characters from a text string starting on the third character
7 Concatenate (bring together) text strings
8 Concatenate (bring together) text strings adding a space,
9 Concatenate (with space) using ampersands
10 Convert a number (like a zip code) to text
""
11 Convert a number (like a zip code) to text adding back leading zero
12 Search for the location of the text string "@" within an email address
13 Split off username from email address. Hint: search for @ symbol
14
TEXT
TEXT
SEARCH
LEFT and SEARCH
15
Raw name data
Zip Codes as Numbers
Proper Name
First Name
36446
29857
2319
31579
4132
66747
27734
35681
31556
2605
16 Putting it all together
17
18 Try to use the functions above to obtain what is being asked in
19 each column.
20
21 There may be more than one way to complete each task.
22
23 When you complete a function, you will notice a link underneath.
24 Follow that link if you need help with the function use and syntax.
25
26 Tip: Use trial and error at first. Build complex formulas in pieces.
kallie cuadrado
blair tindall
jovanni rhodes
olivia bradley
mya brown
samantha ward
nadene senger
ella byrne
rose williamson
val elliott
28
29
30
31
35
38
39
40
41
45
222222≈≈≈3236ERIFF4444747
48
49
50
51
<
Sheet1
+
Workbook Statistics
LL
F
G
H
Last Name
Short Name (First L.)
New Zip
Proper Name
First Name
Last Name
Short Name
New Zip
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Give Feedback to Microsoft
100% +
Transcribed Image Text:Text Data Cleaning and Manipulation
Beginning in row 16, columns B and C contain raw names and numeric zip codes. In columns D through H, you are asked to clean and manipulate that data in specific ways. Good thing is that you only have to create formulas for
first row then you can fill down. Enter the values for the last row below.
Note: These are meant to be challenging. So just take your time and work thought each column logically using trial and error if necessary.
Hint: The last column for zip code, will require a nested IF function to first see if the numeric zip code is 5 or 4 characters long so you then know which formatting to apply.
Proper Name
First Name
Last Name
Short Name (First L.) New Zip Code
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Similar questions
- Searching and Splitting Sometimes you need to search for the location of the first occurrence of a character or sub-string within a larger string. A common example is to find the location of the "@" symbol in an email address so you can isolate the username of the address. In cell D12, find the location of the "@" symbol in the email address in cell C12. Search for the location of the text string "@" within an email address: Finally, you can combine SEARCH and LEFT to isolate the username of the email address. SEARCH tells you where the "@" symbol is located and LEFT needs to know how many characters on the left you want to keep; which SEARCH can provide. Try combining SEARCH and LEFT in cell D13 to isolate the email username from cell C13. Note: there is one slight modification you will need to make to the SEARCH part of the formula to get just the username. See if you can figure it out. Split off username from email address. Hint: search for @ symbol:arrow_forwardJasmine Thompson AutoSave Document4 Word O Search B Share Comment File Insert Draw Design Layout References Mailings Review View Help Home O Find X Cut Calibri (Body) A A Aa A EE v E EE T AaBbCcDd AaBbCcDd AaBbC AABBCCC AaB AaBbCcD AaBbCcDd AaBbCcDd v 12 S Replace Dictate Editor Copy Paste Emphasis BIU ab x, x' A ~ A EEEE E - 1 Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em... A Select V Format Painter Styles Editing Voice Editor Clipboard Font Paragraph 3 4 5. 6. 1 2. In Year 2, Chalon Company records the payment of $450 cash for an expense accrued in Year 1 and records the accrual of $425 for another expense. Additionally, Chalon Company pays $475 for supplies that were purchased in Year 1 on account. The impact of these three entries on Year 2 total expenses and total liabilities is: Total Expenses Liabilities a. increase by $425 decrease by $500 b. increase by $450 decrease by $25 c. increase by $425 increase by $25 d. increase by $900 decrease by $500 e. increase…arrow_forwardmatsApp. File Edit View Chat Call Window Help MInbox (229) - abigailo XM Gmail xiConnect - Home x M Question 11 - Mid-Tern x Connect Getting to k × wiL47 ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fbb.mwcc.edu%252Fwe... Mid-Term Exam i 11 Skipped Saved The following unadjusted trial balance contains the accounts and balances of Dylan Delivery Company as of December 31. 1. Use the following information about the company's adjustments to complete a 10-column work sheet. a. Unrecorded depreciation on the trucks at the end of the year is $5,761. b. Total amount of accrued interest expense at year-end is $8,000. c. Cost of unused supplies still available at year-end is $1,800. Help Ask 2a. Prepare the year-end closing entries for Dylan Delivery Company as of December 31. 2b. Determine the capital amount to be reported on its year-end balance sheet. Note: The S. Dylan, Capital account balance was $295,929 on December 31 of the prior year.…arrow_forward
- AI - E H E AutoSave Normal Document1 - Word Search badiya aldujaili ff BА EN File Home Insert Draw Design Layout References Mailings Review View Help A Share O Comments X Cut Calibri (Body) 11 - A A Aav A E E AaBbCcDc AaBbCcDc AaBbC AABBCCC AaB AAB6CCC AaBbCcDa O Find - A Copy Paste S Replace В IUvab х, х* А I Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. A Select v Dictate Editor Format Painter Clipboard Font Paragraph Styles Editing Voice Editor 1. 2 4 7 Use the following information to answer the next 3 questions Kite Corp. manufactures custom cabinets and uses a job-order costing system. The company had two jobs in process at the beginning of October: Job No. 64 with a total beginning cost of $56,700 and Job No. 65 with a total beginning cost of $83,300. The company applies manufacturing overhead on the basis of machine hours. Budgeted overhead and machine activity for the year were anticipated to be $3,021,000 and 57,000 machine hours. The company worked on four…arrow_forwardAI - E H E AutoSave Normal Document1 - Word Search badiya aldujaili ff BА EN File Home Insert Draw Design Layout References Mailings Review View Help A Share O Comments X Cut Calibri (Body) 11 - A A Aav A E E AaBbCcDc AaBbCcDc AaBbC AABBCCC AaB AAB6CCC AaBbCcDa O Find - A Copy Paste S Replace В IUvab х, х* А I Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. A Select v Dictate Editor Format Painter Clipboard Font Paragraph Styles Editing Voice Editor 1. 2 4 7 Use the following information to answer the next 3 questions Kite Corp. manufactures custom cabinets and uses a job-order costing system. The company had two jobs in process at the beginning of October: Job No. 64 with a total beginning cost of $56,700 and Job No. 65 with a total beginning cost of $83,300. The company applies manufacturing overhead on the basis of machine hours. Budgeted overhead and machine activity for the year were anticipated to be $3,021,000 and 57,000 machine hours. The company worked on four…arrow_forwardAI - E H E AutoSave Normal Document1 - Word Search badiya aldujaili ff BА EN File Home Insert Draw Design Layout References Mailings Review View Help A Share O Comments X Cut Calibri (Body) 11 - A A Aav A E E AaBbCcDc AaBbCcDc AaBbC AABBCCC AaB AAB6CCC AaBbCcDa O Find - A Copy Paste S Replace В IUvab х, х* А I Normal 1 No Spac. Heading 1 Heading 2 Title Subtitle Subtle Em.. A Select v Dictate Editor Format Painter Clipboard Font Paragraph Styles Editing Voice Editor 1. 2 4 7 Use the following information to answer the next 3 questions Kite Corp. manufactures custom cabinets and uses a job-order costing system. The company had two jobs in process at the beginning of October: Job No. 64 with a total beginning cost of $56,700 and Job No. 65 with a total beginning cost of $83,300. The company applies manufacturing overhead on the basis of machine hours. Budgeted overhead and machine activity for the year were anticipated to be $3,021,000 and 57,000 machine hours. The company worked on four…arrow_forward
- I need typing clear urjent no chatgpt used i will give 5 upvotes pls full explainarrow_forwardheducation.com/ext/map/index.htmi?_con=con&ex nacbrowser30&launchuri%=Dnttps%253A %252Fbbhosted.cuny.edu%252Fwebapps%252Fportal%252Fframes. ooks Login H Module 5 Chap 1 8 H Office templates & t.. Il - Chapter 8 Saved Help Save & Exit Subr Northwest Fur Co. started 2021 with $105,000 of merchandise inventory on hand. During 2021, $540,000 in merchandise was purchased on account with credit terms of 2/15, n/45. All discounts were taken. Purchases were all made f.o.b. shipping point. Northwest paid freight charges of $8,500. Merchandise with an invoice amount of $3,400 was returned for credit. Cost of goods sold for the year was $378,000. Northwest uses a perpetual inventory system. Assuming Northwest uses the gross method to record purchases, what is the cost of goods available for sale? Multiple Choice $650,100. $639,368.arrow_forwardHomework help starts here! title: "HW1" author: "TESHWANI GOGINENI" date: "2023-09-20" output: html_document: df_print: paged pdf_document: default word_document: default {r setup, include-FALSE} knitr::opts_chunk$set(echo = TRUE) (r) PartI # # 1.1 Vector # 1. Create 2 vector, each containing 10 random numbers. # First vector vector1 <- sample(1:50, 10, replace = F) # Second vector vector2 <- sample (51:100, 10, replace = F) # Printing the vectors print (vector1) print (vector2) {r} # 2. Append the second vector to the first one. vector_12 <-c(vector1, vector2) print (vector_12) (r) # 3. Calculate the mean of the new combined vector. vector_mean <- mean (vector_12) RUE'S TEIX 27 ROGRAERUGBOGBO GROLOGROGROG SECO BERO GROGRGUR NOGNDGRE UGNEGRU ERUGR ROGEOLOarrow_forward
- I need do fast typing clear urjent no chatgpt used i will give 5 upvotes pls full explain ationarrow_forwardGlasgow Corporation has the following inventory transactions during the year. Unit Number of Units 53 133 Cost $ 45 47 Total Cost $ 2,385 6,251 10,150 5,763 Date Transaction Jan. 1 Beginning inventory Purchase Purchase Purchase Apr. 7 Jul.16 203 50 Oct. 6 113 51 502 $24,549 For the entire year, the company sells 433 units of inventory for $63 each.arrow_forward× M Question 3 - Chap File Edit View History Google Search Bookmarks Profiles Tab Window Help x Inbox (234) - abigailof x | Verify Your Email Addr x The following unadjust xiConnect - Home ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fbb.mwcc.edu%252Fwe... r 4 Homework i Saved Help Save & Exit ok t ces On April 1, Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company's first month. April 2 Nozomi invested $34,000 cash and computer equipment worth $35,000 in the company. April 3 The company rented furnished office space by paying $2,700 cash for the first month's (April) rent. April 4 The company purchased $1,100 of office supplies for cash. April 10 The company paid $2,900 cash for a 12-month insurance policy. Coverage begins on April 11. April 14 The company paid $1,800 cash for two weeks' salaries earned by employees." April 24 The company collected $10,500 cash for…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you