ASSIGNMENT CONTENTIn this assignment, you will practice using AND and OR functions in Excel.Create a table with columns: Name, Math...
Practical Task: Applying Advanced Functions
Assignment ContentEmployee NameDepartmentSalesTargetAlice JohnsonHR120100Bob SmithIT95100Chidi OkoroSales110100Damilola AdeFinance8790Esther GeorgeHR102100Farouk BelloIT9895Grace LiuSales115110👉 This dataset will help you practice logical, lookup, text, and...
Practical Task: Working with Cells
Assignment ContentIn this assignment, you will practice how to work with cells in Excel. Follow the steps below carefully:First, open...
Practical Task: Applying Excel Efficiency Tools
Assignment Content : In this assignment, you will apply what you have learned about the Excel environment, including data entry,...
Hands-On Project
Project InstructionsDownload Data SetDownload the provided data set,unzip and import into your SQL environment.Write and Validate QueriesUse the imported data...
MODULE 5: Hands-On Project Questions
Project InstructionsDownload and Import DataDownload the provided CSV files and import them into your SQL environment.Write and Validate QueriesUse the...
Conditional & Logical Statements
AssignmentOpen Microsoft Excel.Enter the dataset of Bags and Prices shown in the lesson.Use the IF function to categorize bags as...
Using VLOOKUP to Retrieve Data
AssignmentOpen Microsoft Excel.Enter the employee dataset shown in the lesson.Create a new table with Full Name, Department, and Salary.Use VLOOKUP...
Page Layout and Printing Practice
AssignmentOpen Microsoft Excel.Enter a small dataset in a worksheet.Go to Page Layout and change the page orientation.Set a Print Area...
Using the TEXT Function in Microsoft Excel
Assignment TitleDisplaying Numbers as PercentageInstructionsUse the TEXT function to change how numbers appear in Excel.TasksOpen Microsoft Excel.Enter the following data:StudentScoreJohn0.85Mary0.72David0.90Grace0.65Create...