Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

excel training minimal data, Exercises of MS Microsoft Excel skills

Makerere UniversityMS Microsoft Excel skills

practical qns for excel to train

Typology: Exercises

2021/2022

Uploaded on 07/20/2023

buloba-medical-centre
buloba-medical-centre 🇺🇬

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Excel Final Exam
Open Excel to a blank worksheet.
Part A
Create a spreadsheet like the one below. Enter all the numbers.
oChange the formatting of the numbers to dollars.
oMake the grid around the cells visible.
oInsert the title “Monthly Budget” and center and merge it.
Change the font to Baker Signet, size 18.
Make the text white and the fill black.
oInsert the subtitle “January 2005 – June 2005.”
Change the font to Baker Signet, size 10
Make text white and fill black.
Center and merge it.
oTotal the expenses at the bottom of each month.
Widen columns if necessary so numbers can be seen.
oPut a dark border around the edges of the document.
oChange the amount for gasoline in June from $60 to $70.
oFigure out the average for each row. You must know the formula on your
own!
oCenter and bold the headings (months and average)
Change the font to BakerSignet on the headings
Bold the headings in column A.
Change the font to BakerSignet.
oAdd a header with your name, period, and FINAL PART A.
oPrint
pf2

Partial preview of the text

Download excel training minimal data and more Exercises MS Microsoft Excel skills in PDF only on Docsity!

Excel Final Exam

Open Excel to a blank worksheet.

Part A

Create a spreadsheet like the one below. Enter all the numbers. o Change the formatting of the numbers to dollars. o Make the grid around the cells visible. o Insert the title “Monthly Budget” and center and merge it.  Change the font to Baker Signet, size 18.  Make the text white and the fill black. o Insert the subtitle “January 2005 – June 2005.”  Change the font to Baker Signet, size 10  Make text white and fill black.  Center and merge it. o Total the expenses at the bottom of each month.  Widen columns if necessary so numbers can be seen. o Put a dark border around the edges of the document. o Change the amount for gasoline in June from $60 to $70. o Figure out the average for each row. You must know the formula on your own! o Center and bold the headings (months and average)  Change the font to BakerSignet on the headings  Bold the headings in column A.  Change the font to BakerSignet. o Add a header with your name, period, and FINAL PART A. o Print

$- $500.00 $1,000.00 $1,500.00 $2,000.00 $2,500. January February March April May June Income & Expenses Income Expenses

Part B

Keep the work from Part A open. You will be making two graphs from this information.

Graph 1 – Pie Chart

This graph will show the total amount of money spent on each category over a six month period. To do this, you must total the amount spent on each item in column I. Do not include the average in your equation. Next, highlight the expenses (house payment, gasoline, etc). Hold down the ctrl key and highlight your new totals. Create a pie chart. Go to data labels and show the percentages. Cut and paste all the information you need and the graph to a new sheet.

Graph 2. – Bar Chart

This will be a bar chart for income and expenses. Below your total column, type Income in A12. Enter the income for each month. They are as follows: January: 2, February: 2, March: 2, April: 1, May: 2, June: 2, Create a bar chart that looks like the one below. Include the chart you make and the date for the chart on the page you print. This page should include the two data sets and the two charts. Print preview to make sure it all prints on one page.