ADVANCED EXCEL LAB @ HOME 2

1.

Fit-n-Fine Health Club decides to open a new branch in Washington. For this, Jijo Louise, the
owner of the club, needs to create the various projections and plans. Before creating these
strategies, he needs to analyze the status of the club in the past two years. For this, he needs to
present the required data in a format that enables him to analyze the current status of the club 
and take important decisions easily. To accomplish this, he decides to use Microsoft Excel. 
However, the CR Executives at the club have never worked on this tool. Therefore, they decide 
to perform the following tasks:

Enter the details, such as the member ID, name, address, and contact number of five members
and the plan type subscribed by each member, in the worksheet, as shown in the following 
figure.
Check the data for correct spelling.
Insert the club logo in the worksheet.
Insert a comment for the Member ID column header.
Insert a worksheet named NewSheet.

Create a copy of the MemberDetails worksheet and move the copy before the NewSheet
worksheet.
Delete the NewSheet worksheet.
Help the Executives in exploring Microsoft Excel.

ANS:

CLICK HERE

2.

Joy Thomas, the CR Executive atFit-n-Fine Health Club, wants to customize the interface 
of Microsoft Excel tosuit his future requirements. For this, he decides to apply the 
following settings on Microsoft Excel:

Add a shortcut on the QuickAccess toolbar to open the recent files.
Add a new tab to Ribboncontaining a group of two buttons, calculator and camera.
Help Joy Thomasaccomplish the required task.

Note: After performing this exercise, take the screen grab of Excel window and upload the 
same.

ANS:

CLICK HERE

3.

Joy Thomas needs to create a registration form for the club. He needs to provide the various
details, such as the member's name, address, contact number registration date, member 
type, plan type, registration fees, and subscription fees, in the form. Joy decides to use 
Microsoft Excel to create the registration form.

He wants that the appearance of the registration form should be similar to the appearance of the
registration form in the following figure.
Help Joy Thomas create the form.

ANS:

CLICK HERE

4.

Joy Thomas does not know how to save a workbook in Microsoft Excel. Therefore, he 
decides to use the help feature toget the required information. Joy's computer system is 
not connected to the Internet. You need to help Joy Thomas to use the offline help feature 
in Microsoft Excel and to implement the information gathered from the help feature, for 
saving the workbook.

Note: Before performing this exercise, you need to ensure that your system is not connected 
to the Internet. Once, you have performed this exercise, you need to take the screen grab of 
the Excel window and upload the same.

ANS:

CLICK HERE