[PDF] [PDF] MS Excel Exercises - Mahaweli National College of Education





Previous PDF Next PDF



Microsoft Excel 2013 Step by Step

28-Mar-2013 and worksheets make workbooks easier to find



Microsoft Excel 2013 Level 1

Contains worksheets which are collections of cells on a single “sheet” where the data is for how Excel 2013 will calculate the data in a workbook.



Microsoft Excel 2013 Fundamentals Manual

03-Mar-2015 worksheet fundamentals working with basic formulas



Microsoft Excel for Beginners

16-Jan-2018 Microsoft Excel is a spreadsheet program. We use it to ... Worksheet navigation buttons Worksheet tabs. - Sheet1. 6. Status bar. - Excel ...



Untitled

popular business applications such as word 2013 Excel 2013



Microsoft® Excel® 2013 Step by Step

and worksheets make workbooks easier to find



Word and Excel Practice Exercise

This practice exercise can be completed on both PCs and Macs. You will need the following software and plug-ins: 1. Microsoft Excel - Ensure the “Analysis 







Exercise 1

Use the Excel file Exercise 1.xlsx for this exercise e) On the Table worksheet delete the column for the City of London.



Microsoft Excel Exercises For Beginners (PDF) - m.central.edu

23-Jun-2022 Suitable for: Microsoft Excel 2013 and Excel 2010 Windows 8.1 7 and ... Includes practice exercises and keyboard shortcuts.



Microsoft Excel 2013 Fundamentals Manual

Mar 3 2015 · A Launch Excel To launch Excel for the first time: Click on the Start button Click on All Programs Select Microsoft Office from the menu options and then click on Microsoft Excel 2013 Note:After Excel has been launched for the first time the Excelicon will be located on the Quick Launch pane



EXCEL BASICS: MICROSOFT OFFICE 2013 - University of North

EXCEL BASICS: MICROSOFT OFFICE 2013 GETTING STARTED PAGE 02 Prerequisites What You Will Learn USING MICROSOFT EXCEL PAGE 03 Opening Microsoft Excel Microsoft Excel Features Keyboard Review Pointer Shapes MICROSOFT EXCEL BASICS PAGE 10 Typing in Cells Formatting Cells Inserting Rows and Columns Sorting Data Basic Formulas



Microsoft Excel 2013 - pearsoncmgcom

These practice files can be downloaded from the following page: http://www microsoftpretore com/title/9780735681019 IMPORTANTThe Excel 2013 program is not available from this website You should purchase and install that program before using this book The following table lists the practice files for this book Chapter File



Excel Formulas and Functions Exercises - Queens Public Library

Excel Formulas and Functions Exercises This computer class was developed through NYC-Connected Communities a program coordinated by the NYC Department of Information Technology and Telecommunications with funding from the American Recovery and Reinvestment Act’s Broadband Technology Opportunities Program Worksheets 1



Searches related to excel 2013 practice exercises pdf filetype:pdf

Beginners Excel Practice Exercise: Data Entry and Tables This computer class was developed through NYC-Connected Communities a program coordinated by the NYC Department of Information Technology and Telecommunications with funding from the American Recovery and Reinvestment Act’s roadband Technology Opportunities Program 1 )



Excel 2013: Exercises and Solutions - Computer-PDF

Maximize your IT skills with Excel 2013 Download free PDFs learn tips and tricks practice exercises and solutions For beginners and advanced



Microsoft Excel 2013: Exercises and Solutions - Computer-PDF

Maximize your IT skills with Microsoft Excel 2013 Download free PDFs learn tips and tricks practice exercises and solutions For beginners and advanced



[PDF] lab assignments (ms excel 2013) - HCMRIPA

Practice moving around in the worksheet using Arrow Movement Keys Page Up Page Down Home Ctrl + Home etc Press To DOWN ARROW (?) Move to the next row



[PDF] Microsoft Excel 2013 Level 1 - University of Regina

Contains worksheets which are collections of cells on a single “sheet” where the data is for how Excel 2013 will calculate the data in a workbook



[PDF] Microsoft Excel 2013 Step by Step - Pearsoncmgcom

28 mar 2013 · Identifying the different Excel 2013 programs PRACTICE FILES To complete the exercises in this chapter you need the practice files



[PDF] Excel® 2013 In Depth - Pearsoncmgcom

1 Staying Connected Using Excel 2013 5 16 Connecting Worksheets Workbooks and External Data 627 Opening Excel 2013 Files in Excel 2002 or



[PDF] MS Excel Exercises - Mahaweli National College of Education

Introduction to MS Excel files Workbooks Worksheets Columns and Rows 1 Open a new workbook and save the file with the name “Payroll”



[PDF] Excel 2013

The width of each selected column will be changed in your worksheet Note: Select AutoFit Column Width from the format drop-down menu and Excel will



[PDF] Microsoft Excel 2013 Fundamentals Workshop - Pitt IT

5 déc 2012 · worksheet fundamentals working with basic formulas and creating Open Excel Practice File xlsx and then click on the Budget sheet



[PDF] EXCEL BASICS: MICROSOFT OFFICE 2013

When you press “OK” your spreadsheet will be sorted in the order that you specified PRACTICE: Select all the data on your worksheet (cells A1 through B7) and 

How do I use Microsoft Excel 2013?

    Excel is designed to perform calculations, analyze information, and visualize data in a spreadsheet. Also this application includes database and charting features. Click on the Start button. Click on All Programs. Select Microsoft Office from the menu options, and then click on Microsoft Excel 2013.

What is Excel & how does it work?

    III. Microsoft Excel is an electronic spreadsheet that automates manual calculations involved in accounting and bookkeeping. After you have typed the basic text and number entries in a spreadsheet cell, Excel can perform the math calculations for you.

How to insert manual page breaks in Excel?

    If the pages are not separated at the location you desire, then you can insert both vertical and horizontal manual page breaks. Excel provides a Page Break Preview for managing page breaks. Select View tab, and click on the Page Break Preview button. The Page Break Preview window will appear.

University of Bahrain

College of Information Technology

Department of Information Systems

MS Excel Exercises

BIS202 Exercises

2 | P a g e

Exercise 1

Objectives:

` Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows. ` Formatting Worksheets. ` AutoFill, Numeric formats, previewing worksheets.

2. Enter the labels and values in the exact cells locations as desired.

3. Use AutoFill to put the Employee Numbers into cells A6:A8.

4. Set the columns width and rows height appropriately.

5. Set labels alignment appropriately.

6. Use warp text and merge cells as desired.

7. Apply borders, gridlines and shading to the table as desired.

8. Format cell B2 to Short Date format.

9. Format cells E4:G8 to include dollar sign with two decimal places.

10. Calculate the Gross Pay for employee; enter a formula in cell E4 to multiply Hourly

Rate by Hours Worked.

11. Calculate the Social Security Tax (S.S Tax), which is 6% of the Gross Pay; enter a

formula in cell F4 to multiply Gross Pay by 6%.

12. Calculate the Net Pay; enter a formula in cell G4 to subtract Social Security Tax from

Gross Pay.

13. Set the work sheet vertically and horizontally on the page.

14. Save your work.

BIS202 Exercises

3 | P a g e

Exercise 2

Objectives:

` Using Formulas. ` Header and Footers.

2. Delete Sheet 2 & 3, and rename Sheet 1 to (Call Statistics).

3. Enter the labels and values in the exact cells locations as desired.

4. Set the row height of rows 1 & 3 to size 30; and rows 4 until 10 to size 20.

5. Set labels alignment appropriately.

6. Use Warp Text, Orientation and merge cells as desired.

7. Apply border, gridlines and shading to the table as desired.

9. Format cell B12 to include % sign with 0 Decimal places.

10. Calculate the Calls per Hour, enter a formula in cell D4 to divide numbers of calls by

Hours worked. Using AutoFill, copy the formula to the remaining cells. fixed Bonus Rate in cell B12. Using AutoFill, copy the formula to the remaining cells.

13. Set the worksheet vertically and horizontally on the page.

14. Create a header that includes your name in the left section, and your ID number in

the right section. Create the footer that includes the current Date in the center.

BIS202 Exercises

4 | P a g e

Exercise 3

Objectives:

` Number, Commas and Decimal numeric formats. ` Working with Formulas (Maximum, Minimum, Average, Count and Sum). ` Percentage Numeric Formats.

1. Create the worksheet shown above.

2. Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15,

Columns E & F: 14.

3. Enter the formula to find COMMISSION for the first employee.

The commission rate is 2% of sales, COMMISSION = SALES * 2%

Copy the formula to the remaining employees.

4. Enter the formula to find TOTAL SALARY for the first employee where:

TOTAL SALARY = SALARY + COMMISSION

Copy the formula to the remaining employees.

5. Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values.

Copy the formula to each column.

6. Format numeric data to include commas and two decimal places.

7. Align all column title labels horizontally and vertically at the center.

8. Create a Header that includes your name in the left section, page number in the

center section, and your ID number in the right section.

9. Create footer with DATE in the left section and TIME in the right section.

10. Save the file with name Exercise 3.

BIS202 Exercises

5 | P a g e

Exercise 4

Objectives:

` Working with the IF Statement.

For the above table find the following:

1. TAX (If ITEM PRICE is less than 100, TAX is 50, otherwise it should be 100).

2. TOTAL PRICE BEFORE TAX =NO. OF ITEMS * ITEM PRICE.

3. TOTAL PRICE AFTER TAX = TOTAL PRICE BEFORE TAX + TAX.

4. RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is Dz

REASONABLE.

5. Find Count of Items, Average of Taxes, Min Item PRICE and Max Item PRICE.

6. Save file as Exercise 4.

BIS202 Exercises

6 | P a g e

Exercise 5

Objectives:

Working with Sum IF and Count IF statements.

Inserting Charts.

1. Create the worksheet shown above.

2. Set the Text alignment, Columns width and high appropriately.

3. Use AutoFill to put the Series Numbers into cells A5:A7.

4. Format cells C3:G7, C8:E11, C13:E13 to include dollar sign with two decimal places.

5. Find the Average Sales and Maximum Sales for each City.

6. Find the Total Sales for each Month.

7. Calculate the Profit for each month , where profit = Total Sales Ȃ Cost

8. Calculate the 10% Bonus, which is 10% of the Profit.

9. Find the Total Sales for each Month; only for sales greater than 30,000.

10. Find the No of Sales for each Month; only for sales greater than 30,000.

11. Create the following Charts:

BIS202 Exercises

7 | P a g e

Exercise 6

Objectives:

Working with Sum IF and Count IF statements.

Inserting Charts.

1. Open a new workbook and create the above worksheet.

2. Make sure that your worksheet looks like the picture (Alignment, Shedding,

3. Find the entire customer IDs.

4. Format Colum E & D to Currency with dollar sign and two decimal places.

5. Find the Total Annual Purchases for each City.

BIS202 Exercises

8 | P a g e

6. Find the Average Annual Purchases for each Education.

7. Find the total number of customers from each gender.

8. Find the total annual salary for each gender in each city.

9. Create the following Chart:

quotesdbs_dbs14.pdfusesText_20
[PDF] excel 2013 statistical analysis

[PDF] excel 2013 tutorial

[PDF] excel 2016 advanced tutorial pdf

[PDF] excel 2016 bible pdf

[PDF] excel 2016 charts and graphs pdf

[PDF] excel 2016 interface

[PDF] excel 2016 manual

[PDF] excel 2016 pdf

[PDF] excel 2016 power programming with vba download

[PDF] excel 2016 practice

[PDF] excel 2016 practice exercises pdf

[PDF] excel 2016 tutorial

[PDF] excel 2019 power programming with vba example files

[PDF] excel advanced book pdf khmer

[PDF] excel advanced course pdf myanmar