[PDF] Intermediate Microsoft Excel: Practice 1 - The Sanskaar Valley School PDF 2086.pdf

Microsoft Excel Practice Exercises Page 1 Intermediate Microsoft ® for the remaining cells Save the spreadsheet and name it: Excel Intermediate Practice 1

Click the Advanced Excel Exercises workbook to select it 6 Click the Open button 7 Double-click the Sheet2 tab 8 Rename the sheet 3

[PDF] Guide to Excel Proficiency Exercises - Duke Fuqua

includes practice exercises that illustrate features of Excel offers many ways to accomplish the same thing Paula Ecklund More advanced online help chart

[PDF] MS Excel Exercises

BIS202 Exercises 2 Page Exercise 1 Objectives: ▻ Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows ▻ Formatting Worksheets

[PDF] Essential Spreadsheets Exercises - University of York

Exercise files can be found on our Essential Spreadsheets practical guide at: 1 When using Google Sheets or Excel for Microsoft 365, you could auto-generate

[PDF] Intermediate Microsoft Excel: Practice 1 - The Sanskaar Valley School

Microsoft Excel Practice Exercises Page 1 Intermediate Microsoft ® for the remaining cells Save the spreadsheet and name it: Excel Intermediate Practice 1

[PDF] Excel Practice Exercises In Xls

26 déc 2020 · wiseowl co uk, ms excel exercises university of bahrain, excel practice xlsx best spreadsheet test xls sheet, excel formulas amp functions exercises, practice

[PDF] MS Excel Exercise 1: Formulas & Functions - Armstrong Twp High

2_yourname MS Excel Exercise 3: GPA Calculator 1 You will be constructing a spreadsheet that you can use to calculate your

[PDF] Training Microsoft Practice exercises

Training Microsoft Excel 2013 Practice exercises Working with MS Excel Project 4-3: Link to Data in other Worksheets within a Workbook

[PDF] Intermediate Microsoft Excel: Practice 1 - The Sanskaar Valley School

Comma ProductionsMicrosoft Excel Practice ExercisesPage1

IntermediateMicrosoft®Excel: Practice1RUBRIC035810Less than 25% ofitems completedcorrectly.More than 25%of itemscompletedcorrectlyMore than 50%of itemscompletedcorrectlyMore than 75%of itemscompletedcorrectlyAll itemscompletedcorrectlyEach step to complete is considered a single item, even if it is part of a larger string of steps.Objectives:The Learner will be able to1. Apply Currency formatting to cells in Excel2. Use the AutoSum tool to add cells3. Use the Function tool to calculate the average of a range of cells4. Insert an IF function5. Rename spreadsheetEnter the labelsandformat the labels big, bold, and centerediIn Cell A1 type: First NameiIn Cell B1 type: Last NameiIn Cell C1type: DepartmentiIn Cell D1 type: SalaryAdd the dataType at least fivesamplerecords. For example:ABCD1First NameLast NameDepartmentSalary2DeeterPoohbahTraining$34,000Format the ColumnsSelect column D and use the Currency toolCreating EquationsSelect Cell D7 and use AutoSum to add up the SUMof the Salaries in the D Column.Select Cell D8 and useInsertFunction tocalculatethe AVERAGEof the Salaries.Using IF functionsThis activity compares the employee"s salary withthe Average in Cell D8.Insert the label "Compare" into cell E1In E2, insert the IF function.In the Wizard, enter the following informationLogical Test: D2>D8Value_if_true: "Above"Value_if_false: "Below"Use the Insert Function wizard to put the correct formula for the remaining cells.Savethe spreadsheetand name it:Excel Intermediate Practice1

Comma ProductionsMicrosoft Excel Practice ExercisesPage2

IntermediateMicrosoft®Excel: Practice 2Objectives:The Learner will be able to:1.Explain what labels are2.Sort Excel data by using the labels in the header row3. Create a Custom Sort4. Modify the Custom Sort Order5.Change Page Orientation6. Create Custom headers and footers7. Save the spreadsheetWork with Sample DataType the given sample data in a new sheet.When prompted, SAVE toyourDocumentsfolderReview the DataABCDEF1MonthClientCategoryServiceClassDate2JanuaryRick TownerPrivateTrainingAccess1/12/20043JanuaryDarlene DavisPrivateTrainingAccess1/15/20044JanuaryHometown CommunityCollegeEducationalTrainingWord1/15/20045FebruaryHometown CommunityCollegeEducationalTrainingPowerPoint02/05/20046FebruaryHarmony Kitchen And BathCorporateTrainingExcel02/07/20047FebruaryDatabase ConsultantsCorporateTrainingAccess02/10/20048FebruaryBay CountyGovernmentTrainingOutlook02/12/2004Sort the DataSelect the entire spreadsheetand Sort the data byMonthDid the Months sort as expected or did they sort alphabetically?Try the Sort again: use the CUSTOM SORT and change the Order to Custom ListModify the Page LayoutFormat the following Page Layout Options:Make the orientation "Landscape"Create a Custom Header andtype a samplecompany a name in the centerCreate a Custom Footer with the current date on the rightSavethe spreadsheetand name it:Excel Intermediate Practice 2

Comma ProductionsMicrosoft Excel Practice ExercisesPage3

Intermediate Microsoft®Excel: Practice 3Objectives:The Learner will be able to:1.Enter data into a Spreadsheet2.Use AutoFill with labels, data and formulas3.Format CellBorders and Contents4.Calculate the total across the rows5.Calculate the total for each column6.Use Conditional FormattingABCDEFG1MondayTuesdayWednesdayThursdayFridaySaturdayTotal28888884834567888888488Overtime8Enter the Labels in the first rowIn Cell A1 type: MondayUse the AutoFill handle to add Tuesday through SaturdayCalculate the TotalIn Cell G1 type: TotalIn Cell G2 create the equation: =Sum(A2:F2)Use the AutoFill handle to fill down that equation to G6Calculate the Daily TotalEnter sample data in cell A2 through F2Select Cell A7 and AutoSum the totalUse the AutoFill handle to add this equation to Cells B7 throughG7Format the cellsMake the Labels BoldAlign all of the text Centered, in the middle of the cellsCalculate the overtime in Cell G8The equation in cell G8 would be: =G7-40Use Conditional Formatting on Cell G8Savethe spreadsheetand name it:Excel Intermediate Practice3

Comma ProductionsMicrosoft Excel Practice ExercisesPage4

Intermediate Microsoft®Excel: Practice4Objectives:The Learner will be able to:1. Enter data into an Excel Spreadsheetat least 75% of the time2. Use Data Validation to create a DropDown Controlat least 75% of the time3. Rename a sheet in an Excel workbookat least 75% of the time4. Apply Conditional Formattingat least 75% of the time5. Use the Fill Down command6. Enter data using Drop Down Controlsat least 75% of the timeCreate alist of employeesType in the following information in Column ABill SmithKaylee WildHelen PulaskiCorey HaasAngelique RiolSelect the data and name the range. In the Name Boxtype: EmployeesName the sheet: EmployeesCreate a list of locations on another spreadsheet in the same workbookEnter the following Locations in Column Aand sort them A-ZAnn ArborBrightonLansingFlintDetroitGrand RapidsPontiacSelect the names and name the range. In the Name Box type: LocationName the sheet: LocationCreate a schedule on another spreadsheet in the same workbookRename Sheet3: ScheduleIn Cell A1 Type: Employee NameIn Cell A2, use Data Validation to create a Drop Down control using the "Employees" source.Include an Input Message that says: "Select an employeefrom the list"Fill down Five rowsIn Cell B1 Type: LocationIn Cell B2, use Data Validation to create a Drop Down control using "Location" as the sourceInclude and Input Message that says: "Select a Location from the list."Fill Down five rowsApplyConditional FormattingFill in 3 rows of Employees with locations.If the Location is Pontiac, format the text to be GREEN.Does Pontiac show up Green?;-)Savethe spreadsheetand name it:Excel Intermediate Practice4

quotesdbs_dbs2.pdfusesText_2

[PDF] [PDF] Intermediate Microsoft Excel: Practice 1 - The Sanskaar Valley School