How many types of data is used in MS Excel?
Data is entered in cells in a worksheet which is used for calculation and for label in a table. There are four types of data in spreadsheet.
1) Numeric Data: Number (0 -9) comes under numeric data which is aligned toward right side of the cell. Numeric data is called operand in a formula.
--------------------------------------------------
Other Topic of this Chapter
2) Text Data: Alphanumeric data in which letters, space, and digits come in this category. Text data is aligned at left side in a cell.
3) Data & Time: Data and time are values which can be added and subtracted in a worksheet. They are aligned at right side in a cell.
4) Formula: A formula is an arithmetic expression which performs calculation. It has operands and operator and it always begin with equal to (=) sign.
What are the common shortcut keys in MS Excel?
|
Shortcut Keys |
Uses |
|
Ctrl + S |
Save |
|
Ctrl + N |
New File |
|
Ctrl + O |
Open File |
|
Ctrl + C |
Copy |
|
Ctrl + V |
Past |
|
Ctrl + X |
Cut |
|
Ctrl + P |
|
|
Ctrl + F |
Find |
|
Ctrl + A |
Select All |
|
Ctrl + Z |
Undo |
|
Ctrl + Y |
Redo |
|
|
|
|
|
|
How use Undo and Redo in MS Excel?
While working on worksheet, undo command reverse the series action. On the other hand redo command brings back series of actions which have been undone by mistake.
1) Using Undo: Press Ctrl + Z or click Undo icon near office button.
2) Using Redo: Press Ctrl + Y or click Redo icon near office button.
--------------------------------------------------
Chapter 1 – Introduction to IT - ITeS Industries
Chapter 2– Data Entry & Keyboard Skills
Chapter 3 – Digital Documentation
Chapter 4 – Electronic Spreadsheet
Chapter 5 – Electronic Presentation
What are the common errors in MS Excel?
|
Errors |
Reasons |
|
#### |
Value wider than cell |
|
#VALUE |
Wrong Operand |
|
#NAME |
Doesn’t recognize text in formula |
|
#NUM |
Problem with number in formula |
|
#REF! |
Wrong cell reference |
|
#DUV/0! |
Division by Zero in formula |
--------------------------------------------------
What is the use of Auto fill in MS Excel?
In Auto fill feature MS Excel generates predefined series such as days of a week, months of a year, and predefined series automatically when a user gives initial values.
Steps to use Auto Fill:
1) Type initial values like day of a week.
2) Select both cells. An Auto fill handle appears at bottom-right corner.
3) Click the Auto fill handle and drag it down.
No comments:
Post a Comment