Introduction to Ms-Excel and Excel Features
- Microsoft Excel is a general-purpose electronic spreadsheet used to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, or managing a complex accounting ledger for a medium size business.
Excel Features
- There are a number of features that are available in Excel to make your task easier. Some of the main features are:
AutoFormat – lets you to choose many preset table formatting options.
- AutoSum – helps you to add the contents of a cluster of adjacent cells.
- List AutoFill – automatically extends cell formatting when a new item is added to the end of a list.
- AutoShapes toolbar- will allow you to draw a number of geometrical shapes, arrows, flowchart elements, stars and more. With these shapes you can draw your own graphs.
- Drag and Drop – feature will help you to reposition the data and text by simply dragging the data with the help of mouse.
- Charts – features will help you in presenting a graphical representation of your data in the form of Pie, Bar, Line charts and more.
- PivotTable – flips and sums data in seconds and allows you to perform data analysis and generating reports like periodic financial statements, statistical reports, etc. You can also analyse complex data relationships graphically.
- Shortcut Menus – commands that are appropriate to the task that you are doing appear by clicking the right mouse button.
Latest Computer Post :- Click Here
Basic Computer Questions and Answers
1. Who is the father of Computers?
a) James Gosling
b) Charles Babbage
c) Dennis Ritchie
d) Bjarne Stroustrup
View Answer
Click to show/hide
Answer :- { B }
2. Which of the following is the correct abbreviation of COMPUTER?
a) Commonly Occupied Machines Used in Technical and Educational Research
b) Commonly Operated Machines Used in Technical and Environmental Research
c) Commonly Oriented Machines Used in Technical and Educational Research
d) Commonly Operated Machines Used in Technical and Educational Research
View Answer
Click to show/hide
Answer :- { D }
3. Which of the following is the correct definition of Computer?
a) Computer is a machine or device that can be programmed to perform arithmetical or logic operation sequences automatically
b) Computer understands only binary language which is written in the form of 0s & 1s
c) Computer is a programmable electronic device that stores, retrieves, and processes the data
d) All of the mentioned
View Answer
Click to show/hide
Answer :- { D }
4. What is the full form of CPU?
a) Computer Processing Unit
b) Computer Principle Unit
c) Central Processing Unit
d) Control Processing Unit
View Answer
Click to show/hide
Answer :- { C }
5. Which of the following language does the computer understand?
a) Computer understands only C Language
b) Computer understands only Assembly Language
c) Computer understands only Binary Language
d) Computer understands only BASIC
View Answer
Click to show/hide
Answer :- { C }
6. Which of the following computer language is written in binary codes only?
a) pascal
b) machine language
c) C
d) C#
View Answer
Click to show/hide
Answer :- { B }
7. Which of the following is the brain of the computer?
a) Central Processing Unit
b) Memory
c) Arithmetic and Logic unit
d) Control unit
View Answer
Click to show/hide
Answer :- { A }
8. Which of the following is not a characteristic of a computer?
a) Versatility
b) Accuracy
c) Diligence
d) I.Q.
View Answer
Click to show/hide
Answer :- { D }
9. Which of the following is the smallest unit of data in a computer?
a) Bit
b) KB
c) Nibble
d) Byte
View Answer
Click to show/hide
Answer :- { A }
10. Which of the following unit is responsible for converting the data received from the user into a computer understandable format?
a) Output Unit
b) Input Unit
c) Memory Unit
d) Arithmetic & Logic Unit
Answer ⇒ ??