Expert answer:Basic Word and Excel Functions & Microsoft Office

  

Solved by verified expert:Bsaically have to follow the rubric titled lab 1 and then use those instructions to finish the assignments
lab_one___basic_word_and_excel_functions__1_.docx

word_exercise_1__1_.docx

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:Basic Word and Excel Functions & Microsoft Office
Just from $10/Page
Order Essay

excel_exercise_1__1_.xlsx

Unformatted Attachment Preview

Lab One – Basic Word and Excel Functions
Microsoft Office consists of a suite of productivity software packages (applications). This lab
illustrates two of the Microsoft Office software package. An exercise for each of the packages is
to be completed for:
1. Word.
2. Excel.
Each exercise demonstrates your basic knowledge and ability to use the fundamental functions
and features of the software package. If you have previously been exposed to the application
software, the exercises may seem elementary in which case, they should refresh your knowledge.
If this is your first exposure and time using the software, the exercises are rather simple and will
provide you the basic knowledge you will need to work and complete the other lab assignments
for this course. If you have any difficulty doing the assignments, use the Microsoft Help (?)
available or the Internet to search for examples that might assist you.
ASSIGNMENTS: Word and Excel.
WORD:
Purpose: To use various fundamental Word functions such as Spell Check, formatting a
document, setting up bullet item lists, inserting header and footer information, and correcting
erroneous punctuation and grammar.
Files needed:
Word_Exercise_1.
Save your file as:
LastName_FirstName_Word1.
1. Start Word.
a. Locate the file “Word_Exercise_1“ and open the file.
b. Rename the file as indicated above.
c. Save the renamed file in a location of your choice.
NOTE: You should save your work periodically on either a Flash Drive or on the
“H” drive assigned to you to avoid having to re-enter work if a problem is
encountered. If a problem occurs, you will only have to recover from the last
time you saved your work.
2. Set the top margin to 1 inch.
COSC – 111 Word Lab One – Basic Word and Excel Functions – Page 1
Copyright © June, 2015 Dominic M. Mezzanotte, Sr.
3. Set the left and right margins to 1.3 inches.
4. Position your cursor to the top of the page.
a.
b.
c.
d.
Highlight the entire document.
Set the font to “Times New Roman”
Set the font size to 12.
Set the Line Spacing to Single.
5. Position the cursor at the top of the page.
NOTE: This can be done easily by depressing the CTRL + HOME key.
a. Set the font size to 16.
b. Set the font for the three paper heading lines to BOLD.
c. Center the cursor for data entry of the document heading information.
6. Type the paper title centered– PROJECT MANAGEMENT
7. Enter a blank line by pressing the ENTER key.
8. Type the paper second line of heading centered – Your Name and Section Number.
9. Enter a blank line by pressing the ENTER key.
10. Type today’s date centered in the third line of paper heading.
11. Enter a blank line by pressing the ENTER key.
12. Position the cursor at the left margin.
13. Find the list of Project Management activities and make a bulleted list of the items.
NOTE: The list can be found immediately after the sentence ending with
…activities:”
a.
b.
c.
d.
e.
Enter a blank line after the line containing the colon.
Indent the list 0.3” and align the bullet items
Do not enter a blank line after the last bullet item.
Left justify the next sentence containing “fifty cents.”
Enter a blank line after the sentence containing “fifty cents” and (P/M) at the end of
the sentence.
14. Use Find and Replace feature to change all references in the document from (P/M) to
(PM).
15. Indent the first line of new paragraph 0.3”. (You can set the tab accordingly for all new
paragraphs).
16. Enter a blank line after the sentence ending with “…could be devastating.”
COSC – 111 Word Lab One – Basic Word and Excel Functions – Page 2
Copyright © June, 2015 Dominic M. Mezzanotte, Sr.
17. Indent the first line of the next new paragraph 0.3”.
18. Enter a blank line before the sentence beginning with “The process is simple…”
19. Indent the first line of the next new paragraph 0.3”.
20. Spell Check the document correcting any and all misspelled words.
21. Carefully Proof Read and check and correct any and all punctuation and/or grammar
errors in the paper.
22. Add a Footer with a page number after the paper footer labeled – Project Management
Page 1
EXCEL:
Purpose: To use fundamental Excel functions such as formatting header and footer information,
calculating columnar totals and cross foot row totals, and formulas such as “Average.”
Files Needed:
Excel_Exercise_1.
Save your file as:
LastName_First)Name_Excel1.
1. Start Excel.
d. Locate the file “Excel_Exercise_1“ and open the file.
e. Rename the file as indicated above.
HOTE: Be sure to save this file AFTER completing this assignment. You will
need this file as one of the input files for Excel Lab Four.
f. Save the renamed file in a location of your choice.
NOTE: You should save your work periodically on either a Flash Drive or on the
“H” drive assigned to you to avoid having to re-enter work if a problem is
encountered. If a problem occurs, you will only have to recover from the last
time you saved your work.
2. Make sure the worksheet view is set to 100%.
3. Center and bold all header lines.
4. Enter the Company Name – The Latest Fashion Trends, Inc. – at the top of the
worksheet. (You must insert header, Times New Roman, size 18, bold. After inserting the
header you can see it in print preview mode or page layout mode. Make sure you switch
back to normal view, go to View then click on Normal)
COSC – 111 Word Lab One – Basic Word and Excel Functions – Page 3
Copyright © June, 2015 Dominic M. Mezzanotte, Sr.
5. Position the cursor to make the “active cell” A11.
6. In this cell, A11, type Total Revenue.(Adjust Column width if needed)
7. In cell B11, sum cells B3 through B10. You must type =SUM(B3:B10) this will
automatically add the cells.
8. In cell C11, Sum cells C3 through C10. (Similar to step 7, instead of B type C)
9. In cell D11, sum cells D3 through D10. (Similar to step 7, instead of B type D)
10. Position the cursor in cell H2 and type “Item Total”.
11. In cell H3, sum cells B3, C3, D3, E3, F3, and G3. Here is the formula: =SUM(B3:G3)
12. Complete totals for rows 4 through 10. (Similar to step 11)
13. In cell H11, sum cells H3 through H10.
14. Position the cursor in cell J2 and type “Monthly Average”.
15. In cell J3, calculate the monthly average dividing cell H3 by 6 or use the Average
function. Here is the formula: =AVERAGEA(B3:G3)
16. Complete the same calculation for rows 4 through 10.
17. Enter footer with your name centered in the footer. ( You must go to INSERT menu on
the top, then click on Heather & Footer, next scroll down to the bottom of the page click
on the footer box and type)
HOTE: Be sure to save this file AFTER completing this assignment. You will need
this file as one of the input files for Excel Lab Four.
Remember: All assignment material is to be submitted electronically via Blackboard. Make sure
your name, course number, section, and date is included.
COSC – 111 Word Lab One – Basic Word and Excel Functions – Page 4
Copyright © June, 2015 Dominic M. Mezzanotte, Sr.
Project Managnent (PM) provides the mechanisms for developing and implementing many different kinds
of applications and systems. It typically revolves around performing five activities:
Planning
Organizing
Coordinating
Controlling
Ddirecting.
Sometimes referred to as POCCD, this acronym makes this activity easy to remember. This document is
my fifty cent Harvard MBA degree program for Project Managers (P/M).
In this capacity, PMs usually work with various tools such as Gantt Charts, PERT diagrams, etc. to plan,
organize, and coordinate work. Control is how they monitor, govern, and manage work with direction how
they monitor, govern, and manage work. In many cases, software can assist in doing the POC phases of
PM. However, most software packages are rather complex and difficult to learn as they are generic
having to satisfy a wide-range of potential users stand-alone in that they do not easily interface or
integrate with other software packages, represent a compromise solution requiring you to either accept
the way the software works, and perhaps changing the way your orgaization does work, and as a
consequence, requires extensive training and education in how to make the software fit your needs.
Needless to say, staff turnover could be devastating.
I believe Project Management is an exclent management tool and would be best served by implementing
and using a simple Gantt chart for keeping track of work. This can be planned for if new application
software is to be designed developed and implemente.
The process is simple and once learned, snd, mplemented shuld make work easier to control. Initially,
this can be implemented as a manual process until the new software is fond and implemented. In fact, the
manual processallows staff to be trained and educated in how to better progress work in a planned and
orderly manner. For example, P/Ms, would develop and maintain an overall Master Schedule of all active
projects. The level of detail needed to monitor, govern, and manage work to be determined by
management. Each division shuld develop and maintain their own respective Gantt Chart predicated on
the P/M’s Master Schedule. Sample forms of each kind of document needed is enclosed. Staff should be
trained in their use and an overall strategic plan developed for implementation.
Projected 1st Quarter Sales
Revenue
Shirts
Pants
Sport Coats
Socks
Shoes
Dresses
Skirts
Blouses
January
February
125000
210000
75000
95000
75000
100000
150000
175000
170000
175000
225000
225000
250000
275000
175000
200000
March
200000
100000
110000
175000
185000
240000
275000
210000
April
200000
110000
115000
150000
200000
250000
200000
215000
May
200000
120000
130000
125000
195000
260000
175000
220000
June
210000
125000
150000
150000
220000
240000
190000
250000

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP