Moving the data
MOVING THE DATA
Moving the data means transferring data from one location to another location by removing it from its original place.
Unlike copying, moving data does not create a duplicate; the data is shifted to a new position.
What is Moving the Data?
Moving data is the process of selecting text, numbers, cells, rows, columns, files, or folders and placing them at a different location while removing them from the original location.
This operation helps in organizing and restructuring data efficiently.
Why is Moving the Data Important?
Moving data is important because it:
Helps organize information properly
Corrects data placement errors
Improves document structure
Saves time and effort
Makes data presentation clear
Methods of Moving the Data
1. Cut and Paste Method
This is the most commonly used method.
Steps:
Select the data
Press Ctrl + X (Cut)
Move the cursor to the new location
Press Ctrl + V (Paste)
The data is removed from the original place and pasted to the new location.
2. Drag and Drop Method
This method uses the mouse.
Steps:
Select the data
Click and hold the mouse button
Drag the data to the new location
Release the mouse button
3. Using Menu Options
Many software applications provide menu commands:
Edit → Cut
Edit → Paste
Moving Data in Different Applications
Moving Data in MS Word
Used to rearrange paragraphs, sentences, or images.
Moving Data in MS Excel
Used to move cells, rows, columns, or tables.
Moving Files and Folders
Used in file management to reorganize data on a computer.
Difference Between Moving and Copying Data
Moving Data
Copying Data
Data is removed from original place
Data remains in original place
No duplicate created
Duplicate is created
Uses Ctrl + X
Uses Ctrl + C
Common Shortcut Keys
Ctrl + X – Cut
Ctrl + V – Paste
Ctrl + Z – Undo
Advantages of Moving the Data
Improves data organization
Reduces clutter
Makes documents professional
Saves storage space
Enhances workflow efficiency
Common Mistakes While Moving Data
Cutting wrong data
Pasting at the wrong location
Forgetting to paste after cut
Importance of Moving the Data
Moving data is essential for:
Editing documents
Organizing spreadsheets
Managing files and folders
Creating well-structured reports
DELETING THE DATA
Deleting the Data means removing unwanted, incorrect, or unnecessary information from a computer system, software application, or spreadsheet. Proper data deletion helps keep data clean, accurate, and well-organized.
Deleting data is commonly used in:
Microsoft Excel
Databases
Office documents
Computer systems
Data management tasks
What is Deleting the Data?
Deleting the Data is the process of permanently or temporarily removing data entries such as text, numbers, formulas, or records from a file or system.
In simple words:
“Deleting data means removing data that is no longer required.”
Importance of Deleting the Data
Deleting unnecessary data is important because it:
Improves data accuracy
Reduces storage usage
Removes duplicate records
Prevents confusion
Enhances system performance
Types of Data Deletion
1. Temporary Deletion
Data can be restored using Undo (Ctrl + Z).
2. Permanent Deletion
Data is completely removed and cannot be recovered easily.
Deleting Data in Microsoft Excel
1. Deleting Cell Content
Select the cell
Press Delete key
Only the content is removed, not the cell.
2. Deleting Entire Cell
Select the cell
Right-click → Delete
Choose Shift cells up / left
3. Deleting Rows
Select the row number
Right-click → Delete
Entire row will be removed
4. Deleting Columns
Select the column letter
Right-click → Delete
Entire column will be removed
5. Deleting Multiple Cells
Select multiple cells
Press Delete
All selected data will be removed
Deleting Data Using Clear Options
Excel provides Clear options:
Clear Contents
Clear Formats
Clear Comments
Clear All
Path: Home → Clear → Select option
Deleting Data Using Keyboard Shortcuts
Action
Shortcut
Delete content
Delete
Delete row
Ctrl + –
Undo delete
Ctrl + Z
Deleting Duplicate Data
Duplicate data can be deleted using:
Remove Duplicates tool
Manual deletion
Path: Data → Remove Duplicates
Deleting Data in Database Systems
In databases, data is deleted using DELETE command.
Example:
DELETE FROM students WHERE roll_no = 101;
Common Mistakes While Deleting Data
Deleting without backup
Deleting wrong rows or columns
Permanent deletion by mistake
Not using Undo option
Best Practices for Safe Data Deletion
Always take backup
Double-check selected data
Use filters before deleting
Use Undo immediately if mistake occurs
Difference Between Deleting and Clearing Data
Deleting Data
Clearing Data
Removes cells/rows
Removes content only
Structure changes
Structure remains
Permanent
Can be temporary
SEO Keywords for Google Ranking
Deleting the Data
How to Delete Data in Excel
Data Deletion in Computer
Remove Data in Excel
Data Management Delete
INSERTING ROWS AND COLUMNS
Inserting Rows and Columns in Microsoft Excel is a basic yet very important data management task. It allows users to add new rows or columns in a worksheet without deleting existing data. This feature is widely used while updating, organizing, and expanding data tables.
Inserting rows and columns is commonly used in:
Office work
Accounting sheets
Student records
Business reports
Data analysis
What is Inserting Rows and Columns?
Inserting Rows and Columns means adding new empty rows or columns at a specific position in an Excel worksheet to enter additional data.
In simple words:
“Inserting rows and columns helps you add more data space in Excel.”
Importance of Inserting Rows and Columns
This feature is important because it:
Keeps data organized
Prevents data loss
Allows easy data updates
Improves worksheet structure
Saves time during editing
Inserting Rows in Microsoft Excel
Method 1: Insert Row Using Right Click
Select the row number
Right-click on it
Click Insert
A new row is added above the selected row.
Method 2: Insert Row Using Home Tab
Select a row
Go to Home → Insert → Insert Sheet Rows
Method 3: Insert Row Using Shortcut Key
Select the row
Press:
Ctrl + Shift + +
Inserting Columns in Microsoft Excel
Method 1: Insert Column Using Right Click
Select the column letter
Right-click
Click Insert
A new column is added to the left of the selected column.
Method 2: Insert Column Using Home Tab
Select a column
Go to Home → Insert → Insert Sheet Columns
Method 3: Insert Column Using Shortcut Key
Select the column
Press:
Ctrl + Shift + +
WORKING WITH WORKSHEETS
By default, Microsoft Office Excel provides three worksheets in a workbook, but you can insert additional worksheets or delete them as needed. The name (or title) of a worksheet appears on its sheet tab at the bottom of the screen. By default, the name is Sheet1, Sheet2, and so on. but you can give any worksheet a more appropriate name.
Inserting a New Worksheet
To insert a new worksheet, do one of the following:
To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen.
To insert a new worksheet before an existing worksheet, select that worksheet, and then click Home tab→ Cells group → Insert button and then click Insert Sheet.
Press SHIFT + 11 shortcut key.
The default name that Excel gives to the worksheet is the word Sheet, followed by a number.
Renaming a Worksheet
By default, Excel names its worksheets Sheet1, Sheet2, and so on. Providing more meaningful names helps you identify a particular sheet. To change a sheet's name:
1. Double-click the Sheet tab. The existing name of the sheet gets selected.
This can also be done by right clicking the Sheet tab and choose Rename from the menu that appears.
2. Type the new sheet name directly on the tab.
Deleting a Worksheet
The two common procedures to delete an existing worksheet are given below:
Right-click the Sheet tab and choose Delete from the shortcut menu that appears.
Click Home tab→ Cells group → Delete button and then click Delete sheet.
CELL REFERENCES
In Excel, a cell reference identifies the location a cell or group of cells in the spreadsheet. Sometimes referred to as a cell address, a cell reference consists of the column letter and row number that intersect at the cell's location. Note that when listing a cell reference, the column letter is always listed first. Cell references are used in formulas, functions, charts, and other Excel commands.
There are three ways to reference a cell. These are: Relative reference, Absolute reference and Mixed reference.
Relative Reference
In Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group of cells. By default, a spreadsheet cell reference is relative. What this means is that as a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the function's new location.
An example of a relative cell reference would be A1, D99, or AB125.
Absolute Reference
An absolute cell reference consists of the column letter and row number surrounded by dollar signs ($). An absolute cell reference is used when you want a cell reference to stay fixed on a specific cell. This means that as a formula or function is copied and pasted to other cells, the
cell references in the formula or function do not change.
An easy way to add the dollar signs to a cell reference is to click on a cell reference and then press the F4 key on the keyboard.
An example of an absolute cell reference would be $A$1, $D$99, or $AB$125
Mixed Reference
A mixed cell reference is a combination of relative and absolute cell references.
As with absolute cell references, the dollar sign ($) is used in mixed cell references to indicate that a column letter or row number is to remain fixed when it is a copied from one cell to another.
Examples of a mixed cell reference would be $A1 or D$99.
For $A1, the column letter is fixed while the row number is allowed to change when copied to other cells. For D$99, the row number is fixed while the column letter changes.
Using Formulas in Excel
Formulas are mathematical equations that combine operators, values and cell references with operators to calculate a result. In Excel 2007, a formula can consist of up to 8,192 characters.
After you enter a formula into a cell, the cell displays the result of the formula. You see the formula itself in the formula bar as the cell activates.
You create formulas by either entering or referencing values. The character that tells Excel to perform a calculation is the equal sign (=) and must precede any combination of values, cell references, and operators. Excel formulas are calculated from left to right according to operator precedence (priority of an operator).
The following table provides the list of operators that you can use in formulas and indicates each operator's precedence.
You by use of parentheses: Excel performs the calculation within the innermost parentheses first
The process of entering a formula is quite simple. This is demonstrated below:
1. Select a blank cell.
2. Type an Equal to sign (=). The Equal to sign displays in the cell and the Formula bar simultaneously.
3. Without moving out of the cell, type 50+ 20
4 Complete this entry by pressing ENTER or TAB key. You will see that the result is displayed in the cell. When you make this cell active, you will see the formula in the Formula bar also.
You can also mention the cell addresses in formulas. For e.g., formula A5+50 will add 50 in the value stored in the cell A5.
Using Formulas in Excel
Functions are prewritten formulas that you can use to perform specific tasks. A function is comprised of three components:
(1) Formula identifier, the equal sign (=), is required when a function is at the beginning of the formula.
(2) Function name identifies the function.
(3) Arguments are the values acted upon by functions to derive a result. They can be numbers, cell references, constants, logical (True or False) values, or a formula. Arguments are separated by commas and enclosed in parentheses..
A function is written in the following format:
= function_name (arg1, arg2, arg3,........
You can directly place the formula in the cell or it can be inserted using the Insert Function button() on the Formula bar. Clicking on this button opens the Insert Function dialog box as given below:
You have to select an appropriate function from the list given in the dialog box. Select a function and click OK. A dialog box named Insert Function appears on the screen. In our example, we have chosen the ROUND() function. It gives the complete details of the function.
Mathematical Functions
(a)
ABS()
Returns the absolute value of a number.
Example
-ABS (-13.4)
[Ans: 13.4]
(b)
INT()
Rounds a number down to the nearest integer.
Example
-INT (8.9)
[Ans: 8]
- INT (-8.9)
[Ans:-9]
(c)
MOD()
Returns the remainder from a division.
Example
=MOD(13, 3)
[Ans: 1]
(d)
SUM()
Returns the total of its arguments.
Example
=SUM(4,5,13,3)
[Ans: 25]
(e)
SQRT()
Returns a positive square root.
Example
=SQRT (49)
[Ans: 7]
(f)
POWER ()
Returns the result of a number raised to a power.
Example
=POWER (2, 5)
[Ans: 32]
(g) ROUND ()
Rounds a number to a specified number of digits.
Example
ROUND (8.23, 1)
[Ans: 8.2]
=ROUND (8.29, 1)
[Ans: 8.3]
=ROUND (1234.5672,3)
[Ans: 1234.567]
=ROUND (1234.28,-2)
[Ans: 1200]
ROUND (50.25,-2)
[Ans: 100]
=ROUND (49.55,-2)
[Ans: 0]
Statistical Functions
(a)
MAX()
Returns the maximum value in a list of arguments.
Example
[Ans: 25]
(b) MIN ()
-MAX (5, 25, 15, 20, 18, 2)
Returns the minimum value in a list of arguments.
Example
MIN (5, 25, 18, 20, 15, 1, 3, 7)
[Ans: 1]
(c) AVERAGE()
Returns the average of its arguments.
Example
= AVERAGE (51, 20, 25, 29, 15)
[Ans: 28]
MS-Excel 2007
(d) COUNT ()
Example
Counts how many numbers are in the list of arguments.
COUNT (5, 10, 20, "XYZ", "ABC")
[Ans: 3]
Text Functions
(a) UPPER ()
Converts text to uppercase.
Example
UPPER ("Pawan Gupta")
[Ans: PAWAN GUPTA]
(b) LOWER()
Converts text to lowercase.
Example
- LOWER ("ABCDE")
[Ans: abcde]
(c)
CONCATENATE
() Joins several text items into one text item.
Example
-CONCATENATE("soft", "ware")
[Ans: software]
(d)
EXACT()
Checks to see if two text values are identical.
Example
= EXACT("Color", "Colour")
[Ans: False]
= EXACT("Market", "Market")
[Ans: True]
(e)
LEFT ()
Example
Returns the leftmost characters from a text value.
RIGHT ()
= LEFT ("Software", 4)
[Ans: Soft]
(f)
Example
Returns the rightmost characters from a text value.
LEN ()
Retruns the number of characters in a text value.
= RIGHT ("Software", 4)
[Ans: ware]
(g)
Example
= LEN ("Software")
[Ans: 8]
(h)
PROPER ()
Capitalizes the first letter in each word of a text value.
Example
= PROPER ("the high QUALITY")
[Ans: The High Quality]
(i)
TRIM()
Removes space from the text value.
Example
= TRIM("... Microsoft Excel")[
Ans: Microsoft Excel]
Date & Time Functions
(a)
DATE ()
Example
Returns the serial number of a particular date.
[Ans: 6/20/1994]
(b) TODAY ()
= DATE(94,6,20)
Example
Returns the serial number of a today's date.
= TODAY()
[Ans: System Date]
(c)
NOW()
Returns the current date and time.
Example
-NOW()
(Ans: Current date & time)
(d)
YEAR ()
Returns the year of a date.
Example
-YEAR(3/11/2002")
MONTH ()
[Ans: 2002]
(e)
Example
Returns the month of a date.
-MONTH("3/11/2002")
[Ans: 11]
(f)
DAY ()
Returns the day of the month.
Example
DAY("3/11/2002")
[Ans: 3]
(g)
HOUR ()
Returns the hour part as a number from 0 to 23.
Example
-HOUR (12:15:35 PM)
[Ans: 12]
(h)
MINUTE ()
Returns the minute, a number from 0 to 59.
Example
-MINUTE (12:15:35 PM")
[Ans: 15]
(i)
SECOND ()
Returns the second part, a number from 0 to 59.
Example
=SECOND ("12:15:35 PM")
[Ans: 35]
Logical Functions
( a) AND ()
Returns True if all arguments are True otherwise returns False.
Example
-AND(15-20, 2-2)
[Ans: False]
( b) OR ()
Returns True if any one of the arguments is True else False.
Example
=OR(15>20, 2-2)
[Ans: True]
(c) NOT ()
Changes False to True and True to False.
Example
=NOT(8>2)
[Ans: False]
(d) IF ()
Checks the condition. Returns 2nd argument if True and 3rd if False.
Example
=IF(35<50, "Welcome", "Good bye")
[Ans: Welcome]
Creating Charts
The Excel 2007 Chart (also known as graph) is a visual representation of numeric values. Displaying data in a well-conceived chart can make your numbers more understandable. The Excel 2007 charts have a great new look. That is why today Excel is one of the most commonly used application for creating charts.
Before you can create a chart, you must have some numbers (data) that stored in the cells in an Excel worksheet. Normally, the data that a chart uses can delete reside in a single worksheet.
The steps involved in creating a chart are given below:
1. Click on any cell within the data containing the information that you wish to display as a chart, or highlight the exact data area that you wish to display as a chart.
2. Click Insert menu Charts group.
3. From the available charts in the Ribbon, click the chart type of your choice. A gallery of thumbnail images for the related chart subtypes will appear.
4. Click the required chart subtype to create the chart, or click All Chart Types to open the Insert Chart dialog box and choose from all available chart types.
5. When you have selected a subtype, a chart will be created as an object in the worksheet. Chart Tools will appear on the Ribbon incorporating Design, Layout, and Format tabs.
For example, when you choose the Clustered Column subtype, a chart is created as follows:
NOTE: To quickly create a chart of the selected data (based on the default chart type) as an object in the current worksheet, press Alt+F1. To create a chart of the selected data as a new sheet, press F11.
https://www.youtube.com/@KrishnaDubaiMotivation
https://www.facebook.com/share/1H9PPi8tMX/
https://www.instagram.com/officialkrishnadubai?igsh=MXY1eDJiY3owOGtiYQ==
https://wa.me/message/ONUZUUV4Q2YGO1
For corporate Inquiries:
Call Us: +91 9262835223
Comments
Post a Comment