18. Customize options and views, configure content for collaboration, and manipulate data.

V E S R N TECHNOLOGIES


To customize MS Excel options and worksheet views, configure content for collaboration, and perform data manipulation operations.

System / Software Required:
Computer System
MS Excel
Procedure:
Open MS Excel and create a new workbook.
Customize Excel settings using File → Options.
Change worksheet views such as Normal and Page Layout.
Configure worksheet for collaboration by protecting sheet and workbook.
Manipulate data using sort, filter, and basic formulas.
Save the workbook with a proper file name.
Safety / Precautions:
Save work frequently to prevent data loss.
Apply protection and sharing options carefully.
Check data accuracy after manipulation.
Result:
The practical was completed successfully. Excel options and views were customized, collaboration settings were applied, and data was manipulated as required.
I practiced all under my trainer Venugopal Sir.

Popular posts from this blog

Install Windows 7 Operating System - Practical

Image
COPA  Install Windows  -7  Operating System I have learned basically these steps to install windows operating system on Personal Computer(PC) The three basic types of clean installation procedures are as follows: Install on a brand new disk or computer system Erase the disk, format it, and install Install into a new directory I am using  first two methods, be sure my computer can boot from a DVD (most newer computers support booting from a DVD drive). Doing so might require changing the drive boot order in the BIOS or CMOS. The Windows 7 DVD is bootable and should run the Setup program automatically. Clean Install from DVD, Step by Step A typical clean installation (on a blank hard disk) step-by-step procedure is as follows: 1. Insert the Windows 7 DVD into your computer’s DVD-ROM drive, and restart the computer. Windows 7 Setup should start automatically. If Setup does not start automatically, ensure that your computer is configured to boot from the DVD drive. 2. In...
Read more

COPA Bits for Computer Based Test (CBT) by Venugopal Vanjarapu

  Computer Operator and Programming Assistant 1st Semester - Module 1 & 2: Safe Working Practice & Introduction to Computer Components 1 Which is the sequence, in which computer operates?  A Input, output, process  B Input, process, output  C Process, input, output  D Output, process, input  2 Which is the first general purpose programmable electronic computer?  A ENIAC B EDVAC  C EDSAC  D UNIVAC  3 What type of device is computer?   A Electrical device  B Electronic device  C Electro magnetic  D Electro mechanical  4 Who is considered as father of computer?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  5 Who invented Analytical engine?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  6 What is the main electronic component of the first generation computer?  A Integrated circuit  B Microprocess  C Transisto...
Read more

COPA

COPA Computer Operator and Programming Assistant (COPA) Exp No Trade Practical Trade Theory CBT Exam Study Material Video Lesson 1 1 1 Study Material Video Lesson 2 2 2 3 3 3 4 Installing Window Operating System Operating System 5 MS-DOS Commands Operating System 6 Linux Commands Operating System 7 Create new document, open existing document, edit document and save the documents Ms Word 8 Formatting text, inserting objects, tables, hyperlinks, autocorrect features, thesaurus, spelling and grammar Ms Word 9 ...
Read more