Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.
Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
Task 3: List the customer ID, first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.
![CUST ID
FIRST NAME
LAST_NAME
ADDRESS
CITY
STATE
POSTAL
EMAIL
BALANCE
CREDIT_LIMIT
REP_ID
125
Joey
Smith
17 Fourth St
Cody
WY
82414
jsmith17@example.com
80.68
500.00
05
182
Billy
Rufton
21 Simple Cir
Garland
WY
82435
billyruff@example.com
43.13
750.00
10
227
Sandra
Pincher
53 Verde Ln
Powell
WY
82440
spinch2@example.com
156.38
500.00
15
294
Samantha
Smith
14 Rock Ln
Ralston
WY
82440
ssmith5@example.com
58.60
500.00
10
314
Tom
Rascal
1 Rascal Farm Rd
Cody
WY
82414
trascal3@example.com
17.25
250.00
15
375
Melanie
Jackson
42 Blackwater Way
Elk Butte
WY
82433
mjackson5@example.com
252.25
250.00
05
435
James
Gonzalez
16 Rockway Rd
Wapiti
WY
82450
jgonzo@example.com
230,40
1000.00
15
492
Elmer
Jackson
22 Jackson Farm Rd
Garland
WY
82435
ejackson4@example.com
45.20
500.00
10
543
Angie
Hendricks
27 Locklear Ln
Powell
WY
82440
ahendricks7@example.com
315.00
750.00
05
616
Sally
Cruz
199 18th Ave
Ralston
WY
82440
scruz5@example.com
8.33
500.00
15
721
Leslie
Smith
123 Sheepland Rd
Elk Butte
WY
82433
Ismith12@example.com
166.65
1000.00
10
795
Randy
Blacksmith
75 Stream Rd
Cody
WY
82414
rblacksmith6@example.com
61.50
500.00
05](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0985f779-e099-4707-8f72-7eb4444fa04d%2F62394e64-9eb7-440c-b4bc-2d38666312f6%2Fbq0xa9o_processed.png&w=3840&q=75)
Transcribed Image Text:CUST ID
FIRST NAME
LAST_NAME
ADDRESS
CITY
STATE
POSTAL
EMAIL
BALANCE
CREDIT_LIMIT
REP_ID
125
Joey
Smith
17 Fourth St
Cody
WY
82414
jsmith17@example.com
80.68
500.00
05
182
Billy
Rufton
21 Simple Cir
Garland
WY
82435
billyruff@example.com
43.13
750.00
10
227
Sandra
Pincher
53 Verde Ln
Powell
WY
82440
spinch2@example.com
156.38
500.00
15
294
Samantha
Smith
14 Rock Ln
Ralston
WY
82440
ssmith5@example.com
58.60
500.00
10
314
Tom
Rascal
1 Rascal Farm Rd
Cody
WY
82414
trascal3@example.com
17.25
250.00
15
375
Melanie
Jackson
42 Blackwater Way
Elk Butte
WY
82433
mjackson5@example.com
252.25
250.00
05
435
James
Gonzalez
16 Rockway Rd
Wapiti
WY
82450
jgonzo@example.com
230,40
1000.00
15
492
Elmer
Jackson
22 Jackson Farm Rd
Garland
WY
82435
ejackson4@example.com
45.20
500.00
10
543
Angie
Hendricks
27 Locklear Ln
Powell
WY
82440
ahendricks7@example.com
315.00
750.00
05
616
Sally
Cruz
199 18th Ave
Ralston
WY
82440
scruz5@example.com
8.33
500.00
15
721
Leslie
Smith
123 Sheepland Rd
Elk Butte
WY
82433
Ismith12@example.com
166.65
1000.00
10
795
Randy
Blacksmith
75 Stream Rd
Cody
WY
82414
rblacksmith6@example.com
61.50
500.00
05
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage