Explain the following 16 tasks shown below
Microsoft Excel:
Task 1. Remove Extra Spaces In Front
(L3/V#27/120 "trim" 27.)/h2>
Instructions:
Look at the image below.
Look at the words in column A.
Notice some words in column A have empty spaces before the word.
You will click on cell d2 and create a formula to show the same
data in column a without the empty spaces.
Explain with formula and how you would do it. (20)
Task 2. Fix The Error Message
7/19/53 "value" 19.
Instructions:
Look at the image below.
You have completed 1 (above).
Explain the error message in column C
and how you would fix it. If necessary,
click the image below to make it larger.
Image opens in a new window. (25)
Task 3. Separate Columns
1/19/58 "separate" 19.
Instructions:
Look at the image below.
Explain the steps you would take to
separate the city, state, and zip
into their own column. (58)
If necessary, click the image below
to make it larger. Image opens in a new window.
Task 4. Gantt
8/9/39 "gantt" 9.
Instructions:
Look at the image below.
Explain the steps you would take
to open a new workbook and create
this Gantt chart. (24)
If necessary, click the image below
to make it larger. Image opens in a new window.
Task 5. Loan
8/13/32 "loan" 13.
Instructions:
Look at the image below.
Explain the steps you would
take to open a new workbook and
create this loan table. (20)
If necessary, click the image
below to make it larger. Image
opens in a new window.
Task 6. Mark, Sort, Remove
mark 2/11/39
"duplicate" 11.
sort 7/8/46
"duplicate" 8.
remove 7/10/29
"duplicate" 10.
Instructions:
Look at the image below.
In column A there are over
5,000 entries and over 1,000 duplicates.
Explain the steps you would take to:
(1) Mark duplicates in red
(2) Sort red to the top
(3) Remove duplicates (45)
If necessary, click the image below
to make it larger. Image opens in a new window.
Task 7. Make It Vertical
3/23-24/58 "transpose" 24.
Instructions:
Look at the image below.
Explain how you would change the
data in A2 through F7 so it appears
in A12 through F17 (16)
If necessary, click the image
below to make it larger. Image
opens in a new window.
Task 8. Top 10 and then Top 3
7/22/51 "top" 22.
Instructions:
Look at the image below.
Explain how to mark the top 10 sales
values using “Light Red Fill with Dark
Red Text,” then change it to show only the top 3. (14)
If necessary, click the image below
to make it larger. Image opens in a new window.
Task 9. Less Zeros… only “B”
2/24/93 "billions" 24.
Instructions:
Look at the image below.
Explain how to format numbers so
only the first three digits appear,
followed by a B. (23)
If necessary, click the image below
to make it larger. Image opens in a new window.
'
Task 10. Protect Cells
8/7/183 "protect" 7.
Instructions:
Look at the image below.
Explain how to protect cells E4 through E11 so
they cannot be changed or deleted. (41)
Task 11. Empty Rows
3/25-26/80 "delete" 26.
Instructions:
Look at the image below.
Explain how to delete all empty rows
and move remaining rows up at the same time. (40)
Task 12. Join Columns/mark>
7/17/57 "join" 17.
Instructions:
Look at the image below.
Explain the formula used in cell E2 to
join First Name (Column B) and
Last Name (Column A) with a space.
After copying the formula, explain
what happens when Columns A and B are
deleted and how to fix it. (65)
Task 13. Macro Create
4/14/66 "macro" 14.
Instructions:
Look at the image below.
Explain how to create a macro named
ten_sheetsthat works in the
current and future workbooks. (65)
Task 14. Macro Run It
4/15/31 "macro" 15.
Instructions:
You have a blank Excel workbook open on your screen
Run the macro and explain whether it
created ten worksheet tabs. (15)
Task 15. Macro on QAT
4/18/61 "macro" 18.
Instructions:
Look at the image below.
Explain how to add the macro to
the Quick Access Toolbar. (30)
Task 16. Macro Icon
4/19/40 "macro" 19.
Instructions:
Look at the image below.
Explain how to change the macro on
the QAT to a custom icon. (30)
Tim Owens – Admin Professional Consultant
Saving staffing agency owners millions in revenue since 2006
Hero to the modern-day Admin Professional
Contact Tim Owens
Phone: 1-(310)-625-7711
Unfortunately no texting
Los Angeles office
Email: tvowens@outlook.com
To return to the top of this page, hold CTRL and press HOME.
Instructions:
Look at the image below.
Look at the words in column A.
Notice some words in column A have empty spaces before the word.
You will click on cell d2 and create a formula to show the same
data in column a without the empty spaces.
Explain with formula and how you would do it. (20)
7/19/53 "value" 19.
Instructions:
Look at the image below.
You have completed 1 (above).
Explain the error message in column C
and how you would fix it. If necessary,
click the image below to make it larger.
Image opens in a new window. (25)
1/19/58 "separate" 19.
Instructions:
Look at the image below.
Explain the steps you would take to
separate the city, state, and zip
into their own column. (58)
If necessary, click the image below
to make it larger. Image opens in a new window.
8/9/39 "gantt" 9.
Instructions:
Look at the image below.
Explain the steps you would take
to open a new workbook and create
this Gantt chart. (24)
If necessary, click the image below
to make it larger. Image opens in a new window.
8/13/32 "loan" 13.
Instructions:
Look at the image below.
Explain the steps you would
take to open a new workbook and
create this loan table. (20)
If necessary, click the image
below to make it larger. Image
opens in a new window.
mark 2/11/39
"duplicate" 11. sort 7/8/46
"duplicate" 8. remove 7/10/29
"duplicate" 10.
Instructions:
Look at the image below.
In column A there are over
5,000 entries and over 1,000 duplicates.
Explain the steps you would take to:
(1) Mark duplicates in red
(2) Sort red to the top
(3) Remove duplicates (45)
If necessary, click the image below
to make it larger. Image opens in a new window.
3/23-24/58 "transpose" 24.
Instructions:
Look at the image below.
Explain how you would change the
data in A2 through F7 so it appears
in A12 through F17 (16)
If necessary, click the image
below to make it larger. Image
opens in a new window.
7/22/51 "top" 22.
Instructions:
Look at the image below.
Explain how to mark the top 10 sales
values using “Light Red Fill with Dark
Red Text,” then change it to show only the top 3. (14)
If necessary, click the image below
to make it larger. Image opens in a new window.
2/24/93 "billions" 24.
Instructions:
Look at the image below.
Explain how to format numbers so
only the first three digits appear,
followed by a B. (23)
If necessary, click the image below
to make it larger. Image opens in a new window.
'
8/7/183 "protect" 7.
Instructions:
Look at the image below.
Explain how to protect cells E4 through E11 so
they cannot be changed or deleted. (41)
3/25-26/80 "delete" 26.
Instructions:
Look at the image below.
Explain how to delete all empty rows
and move remaining rows up at the same time. (40)
7/17/57 "join" 17.
Instructions:
Look at the image below.
Explain the formula used in cell E2 to
join First Name (Column B) and
Last Name (Column A) with a space.
After copying the formula, explain
what happens when Columns A and B are
deleted and how to fix it. (65)
4/14/66 "macro" 14.
Instructions:
Look at the image below.
Explain how to create a macro named
ten_sheetsthat works in the
current and future workbooks. (65)
4/15/31 "macro" 15.
Instructions:
You have a blank Excel workbook open on your screen
Run the macro and explain whether it
created ten worksheet tabs. (15)
4/18/61 "macro" 18.
Instructions:
Look at the image below.
Explain how to add the macro to
the Quick Access Toolbar. (30)
4/19/40 "macro" 19.
Instructions:
Look at the image below.
Explain how to change the macro on
the QAT to a custom icon. (30)
Hero to the modern-day Admin Professional
Phone: 1-(310)-625-7711
Unfortunately no texting
Los Angeles office
Email: tvowens@outlook.com