Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Microsoft Excel Q/a(Computer Aptitude ) Questions and Answers
Home
Topic
Computer Aptitude
Microsoft Excel Q/a
Question 1.
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
None of these
Explanation:-
Answer: Option B. ->
Character
Question 2.
In Excel the function calculates depreciation at the same amount each year over an asset’s useful life
DB (fixed-declining balance)
SLN (straight line)
DDB (double-declining)
All of above
Explanation:-
Answer: Option B. ->
SLN (straight line)
Question 3.
Which of the following is not true about Find and Replace in Excel
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
None of these
Explanation:-
Answer: Option D. ->
You can search by rows or columns or sheets
Question 4.
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Explanation:-
Answer: Option C. ->
A group of cells
Question 5.
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
None of these
Explanation:-
Answer: Option D. ->
Pressing spacebar
Question 6.
All formula In Excel start with
.>
+
=
-
None of these
Explanation:-
Answer: Option C. ->
=
Question 7.
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from
from Format » Cells
from Format > > Auto format
from Table > > Auto format
All of above
None of these
Explanation:-
Answer: Option B. ->
from Format > > Auto format
Question 8.
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
Explanation:-
Answer: Option C. ->
Text boxes
Question 9.
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
All of the above
None of these
Explanation:-
Answer: Option E. ->
None of these
Question 10.
Tab scrolling buttons
Allow you to view a different worksheet
Allow you to view additional worksheet row down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheet tabs
None of these
Explanation:-
Answer: Option D. ->
Allow you to view additional sheet tabs
1
2
3
4
5
6
7
...
63
64
Next →
One click Login
Login With Google
Old way of Login
Login With Email