Scribd
Upload
8 views2 pages

Index Computer

The document outlines a series of exercises focused on spreadsheet skills, including creating workbooks, entering data, formatting cells, and performing calculations. Each exercise contains a list of topics with corresponding page numbers and remarks for guidance. The exercises cover various functionalities such as tax calculations, sales analysis, and data formatting.

Uploaded by

kumarhks65252250
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views2 pages

Index Computer

The document outlines a series of exercises focused on spreadsheet skills, including creating workbooks, entering data, formatting cells, and performing calculations. Each exercise contains a list of topics with corresponding page numbers and remarks for guidance. The exercises cover various functionalities such as tax calculations, sales analysis, and data formatting.

Uploaded by

kumarhks65252250
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INDEX

EXERCISE 1
S. No. Topic Page No. Remarks
1 Create Workbook
2 Enter Data
3 Autofill Employee Numbers
4 Adjust Columns/ Rows
5 Set Alignment
6 Label Alignment
7 Wrap Text/ merge cells
8 Apply borders/shading
9 Date format
10 Currency format
11 Calculate gross pay
12 Calculate SS tax
13 Calculate net pay
14 Save workbook
Exercise 2
S NO. TOPICS PAGE NO. REMARKS
1 create workbook
2 Delete sheets
3 Enter labels
4 Set row heights
5 Set label alignment
6 Wrap text/merge cells
7 Apply borders
8 Format euro sign
9 Format percentage
10 Calculate calls per hour
11 Calculate bonus
12 Calculate total
13 Set worksheet orientation
14 Create header/ footer
EXERCISE 3
S NO. TOPICS PAGE NO. REMARKS
1 Create worksheet
2 Set column widths
3 Calculate commission
4 Calculate total salary
5 Find totals/averages
6 Format data
7 Align labels
8 Create header
9 Create footer
10 Save file
EXERCISE 4
S NO. TOPICS PAGE NO. REMARKS
1 Calculate TAX
2 Calculate TOTAL PRICE BEFORE TAX
3 Calculate TOTAL PRICE AFTER TAX
4 Determine RATE
INDEX
5 Find COUNT, AVERAGE, MIN, MAX
6 Save file
EXERCISE 5
S NO. TOPICS PAGE NO REMARKS
1 Create worksheet
2 Text alignment, columns width
3 Autofill series numbers
4 Format cells with dollar sign
5 Average and maximum sales
6 Total sales each month
7 Monthly profit calculation
8 10% bonus calculation
9 Total sales > 30,000
10 Count sales > 30,000
11 Create charts

You might also like