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:
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:
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:
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:
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:
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:
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:
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:
No comments:
Post a Comment