Exam (elaborations)
Core Skill Training 2 and 3
- Course
- Institution
Core Skill Training 2 and 3
[Show more]
Seller
Follow
learnsphere
Content preview
QCORE SKILL TRAINING 2 AND 3COMPLETE DETAILED CASE STUDY
change the options on this worksheet so that gridlines are visible - click the page layout tab
locate sheet options group
click view gridlines
move the entire loan amortization schedule worksheet in the EXCEL07.XLSX worbook located in the
GMetrix Templates folder and insert it after the Time Card worksheet in the EXCEL06.xlsx workbook - 1.
in the file tab, click on open, select computer, and click browse. in the dialog window go to your
documents folder, in the GMETRIXtemplates folder select EXCEL07.XLSX and click open
2. in the EXCEL07.xlsx worbook right click the loan amotixation schedule worksheet, select move or copy
3. in the move or copy window, in the to book drop down select EXCEL06. xlsx, in the before sheet
section move to end an click ok
In the Time Card worksheet, add a header that uses the Current Date format in the left header field and
Page Number in the right header field. Add the Sheet Name to the left footer field. - 1. in the time card
ws, in the insert tab, go to the text group and click header and footer
2. in the header click into the left field, in the design tab, go to the header and footer elements and click
current date
3. in the header click into the right field, in the design tab, go to header and footer elements, and click
page number
4. in the footer click into the left field, in the design tab, go to the header and footer elements and click
sheet name and click out of the header and footer and into the sheet
In the Excel Options change the Formulas to not Enable background error checking - 1. in the file tab
select options to launch the excel options dialog box
2. in the formulas tab locate the error checking group, uncheck the enable background error checking
option and click ok
in excel options, change the save autorecover information to every 5 minutes - 1. in the file tab, select
the options to launch the excel options dialog box
, 2. in the save tab, locate the save workbooks group, and change the save autorecover information option
to 5 minutes. click ok
freeze the top row of the loan amortization schedule worksheet - 1. in the view tab, locate the window
group, click freeze panes, and select freeze top row
modify the title style to use 20 pts - 1. in the home tab, go to the styles group, select the cell styles
button (the drop down arrow) on the styles, right click on the title style and click modify
2. in the style dialog window, click format, in the font group, go to the size section, select 20, and click ok
twice.
In the marketing budget plan worksheet, edit the cell reference Research; have it only refer to the
research types under the heading - 1. in the marketing budget plan worksheet, in the formulas tab, go to
the defined names group and click name manager
2. in the name manager window, scroll down, in the name column look and highlight research and click
edit
3. in the edit name window, int he refers to field, delete the data in the field and highlight cells A5:A8
4. Click Ok and click close
In the Budget Plan Chart worksheet, apply a Round Bevel (or Circle) to the illustration - 1. select image
above chart
2. picture tools/format tab, locate the picture styles group, and select picture effects
3. in the dropdown menu, locate bevel, and select round bevel, (or circle) from the bevel group
In the Budget Plan Chart worksheet insert the values from the chart into the Budget row of the table
below - 1. in cell B41, insert the number 0 from the research section of the chart above
2. in cell c41, insert the number 0 from the communications section of the chart above
3. continue inserting the information in the chart to the rest of the columns in the "budget" row
In the Marketing Budget Plan worksheet, cell E51, insert a COUNTIF formula to count the data in cell
range D43:D51 that is greater than 0 - 1. select cell E51
2. in the formula tab, locate the formula library, and click insert function
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller learnsphere. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.35. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
50843 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now