LakshyaEducation.in

VEDIC MATHS Video Series
  • Home
  • Video Series
    • Vedic Maths Videos
    • Quantitative Aptitude Videos
    • Class 8 Maths Videos
    • Class 9 Maths Videos
    • Class 10 Maths Videos
  • Quiz & Solutions
  • Blog
  • Store
  • Login
  • Contact Us
  • Home
  • Topic
  • Computer Aptitude
  • Ms Excel

Computer Aptitude

MS EXCEL MCQs

Total Questions : 194

Page 1 of 20 pages
Question 1. A circular reference is
  1.    A formula that either directly or indirectly depends on itself
  2.    A cell that points to a drawing object
  3.    Geometric modeling tool
  4.    Always erroneous
 Discuss Question
Answer is Option A. -> A formula that either directly or indirectly depends on itself
Question 2. When you insert an excel file into a word document. The data are
  1.    Hyperlinked placed in a word table
  2.    Embedded
  3.    Use the word menu bar and toolbars
  4.    Linked
 Discuss Question
Answer is Option D. -> Linked
Question 3. All worksheet formula
  1.    Manipulate values
  2.    Use the addition operator
  3.    Manipulate labels
  4.    Return a formula result
 Discuss Question
Answer is Option D. -> Return a formula result
Question 4. The Paste Special command lets you copy and paste:
  1.    Cell comments
  2.    The resulting values of a formula instead of the actual formula
  3.    Multiply the selection by a copied value
  4.    Formatting options
 Discuss Question
Answer is Option B. -> The resulting values of a formula instead of the actual formula
Question 5. Excel probably considers the cell entry January 1, 2020 to be a
  1.    Text string
  2.    Label
  3.    Formula
  4.    Value
 Discuss Question
Answer is Option D. -> Value
Question 6. Which of the following options is not located in the page setup dialog box ?
  1.    Page Orientation
  2.    Headers and Footers
  3.    Margins
  4.    Page Break Preview
 Discuss Question
Answer is Option D. -> Page Break Preview
Question 7. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?
  1.    Press Ctrl + Home
  2.    Press Home
  3.    Press Alt + Home
  4.    Press Shift + Home
 Discuss Question
Answer is Option A. -> Press Ctrl + Home
Question 8. Files created with Lotus 1-2-3 have an extension
  1.    XLS
  2.    123
  3.    Doc
  4.    WK1
 Discuss Question
Answer is Option B. -> 123
Question 9. You can edit a cell by
  1.    Selecting Edit > Edit cell from the menu
  2.    Clicking the formula button
  3.    Double clicking the cell to edit it in place
  4.    None of these
 Discuss Question
Answer is Option C. -> Double clicking the cell to edit it in place
Question 10. Which elements of worksheet can be protected from accidental modification
  1.    Contents
  2.    Scenarios
  3.    Objects
  4.    All of the listed here
 Discuss Question
Answer is Option D. -> All of the listed here
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • ...
  • 19
  • 20
  • Next →
  • Share on Facebook!
  • Share on Pinterest!

Sub Topics

  • Computer Knowledge Mixed
  • Basic Computer Knowledge
  • Basics Of Hardware And Software
  • Computer Acronyms And Abbreviation
  • Computer Basic Information
  • Computer Fundamental
  • Computer Hardware
  • Fundamental And Concepts Of Computer
  • Microsoft Access
  • Microsoft Excel Q/a
  • Microsoft Office
  • Microsoft Powerpoint Q/a
  • Microsoft Windows Keyboard Shortcuts
  • Microsoft Windows Operating System
  • Microsoft Word
  • Ms Excel
  • Ms Excel
  • Ms Power Point
  • Ms Word
  • Ms Word
  • Networking
  • Operating System
  • Operating System
  • Power Point
  • Software Concepts

Topics

  • Computer Aptitude
  • SAIL Junior Officer (E-0)
  • 10th Grade
  • 11th Grade
  • 12th Grade
  • 4th Grade
  • 5th Grade
  • 6th Grade
  • 7th Grade
  • 8th Grade
  • 9th Grade
  • NCERT
  • Cat
  • Commerce
  • Computer Science
  • Engineering
  • English
  • General Knowledge
  • Ias
  • Management
  • Quantitative Aptitude
  • Reasoning Aptitude
  • General Studies (Finance And Economics)
  • Analytical Instrumentation
  • Biochemistry
  • Bioinformatics
  • Biology
  • Biotechnology
  • Bitsat
  • Business Statistics
  • C Programming
  • C++ Programming
  • Cell Biology
  • Chemistry
  • Cost Accounting
  • Drug And Pharmaceutical Biotechnology
  • Electrical Measurement And Instrumentation
  • Environment Management
  • Environmental Biotechnology
  • Enzyme Technology
  • Financial Management And Financial Markets
  • Gate
  • General Science
  • Geography
  • Heat Transfer
  • History And National Movements
  • Human Anatomy And Physiology
  • Human And Cultural Diversity
  • Human Resource Management
  • Indian Economy
  • Indian Geography
  • Indian History
  • Indian Polity
  • Instrumentation Transducers
  • International Relations
  • Life Sciences
  • Marketing And Marketing Management
  • Mass Transfer
  • Mechanics Of Materials
  • Microbiology
  • Neet
  • Professional Communication
  • Renewable Energy
  • Sociology
  • Surveying
  • Total Quality Management
  • Uidai Aadhaar Supervisor Certification
  • Virology

Recent Questions

Q.   What Is 5's Occupation?

Q.   Statement: Should Workers/employees Be Allowed To Participa....

Q.   If ‘-‘ Stands For 'addition', '÷’&n....

Q.   Which Country Announced New Rules Under Which Profit Tutorin....

Q.   Who Was The First Sailor To Sail Around The World

Q.   Cellulose Content In Bomboo Fibre Is About __________ Percen....

Q.   The Phase Of Mitosis Which Is Associated With The Formation ....

Q.   In A Shell And Tube Heat Exchanger, The Flow Rate Of Heating....

Q.   A Polyclonal Antibody Response

Q.   International Children’s Peace Prize 2014 Was Won By–

Q.   Event (A):Pakistan Banks Began A Push Against Defaulters. Ev....

Q.   In Excel Default Style For New Data Keyed In A New Workbook ....

Q.   Empirical Formula Of Glucose Is

Q.   Who Is Honoured With Special Humanitarian Action Award By UN....

Q.   ....

Q.   Which One Of The Following Is Used As An Anti-freeze For The....

Q.   The Teams Are Going To Be Seeded Based On The Following Rule....

Q.   World Forest Day Is Celebrated On

Q.   The Process Of Converting Inputs Into Outputs In The Presenc....

Q.   Which Of The Following Houses The Process Of Solar Distillat....

LakshyaEducation.in
Lakshya Education
Bhilai,Chattisgarh,India
Email: admin@lakshyaeducation.in Phone: 07893519977 (WhatsApp)

Quick Links

  • Vedic Maths
  • Quantitative Aptitude
  • Class – IX Maths
  • Class – X Maths
  • YouTube Channel
  • Maths Fast Trick
  • Blog

Our Services

  • About us
  • Privacy
  • TOS
  • Refund / Cancellation
  • Contact
  • Affiliate Program
  • Copyright © 2022 All Right Reserved | Lakshya Education     ( )
    Login / Register

    Your Account will be created automatically when you click the below Google or Facebook Login Button.
    •   Login With Facebook
    •  Login With Google
     Login With Email/Password