Microsoft Excel Q/a(Computer ) Questions and Answers

Question 1. Which of the following is not a valid data type in Excel?
  1.    Number
  2.    Character
  3.    Label
  4.    Date/Time
  5.    None of these
Explanation:-
Answer: Option B. -> Character
Answer: (b)
Question 2. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life
  1.    DB (fixed-declining balance)
  2.    SLN (straight line)
  3.    DDB (double-declining)
  4.    All of above
Explanation:-
Answer: Option B. -> SLN (straight line)
Answer: (b)
Question 3. Which of the following is not true about Find and Replace in Excel
  1.    You can search for bold and replace with italics
  2.    You can decide whether to look for the whole word or not
  3.    You can search in formula too
  4.    You can search by rows or columns or sheets
  5.    None of these
Explanation:-
Answer: Option D. -> You can search by rows or columns or sheets
Answer: (d)
Question 4. A worksheet range is a
  1.    A command used for data modeling
  2.    A range of values such as from 23 to 234
  3.    A group of cells
  4.    A group of worksheets
Explanation:-
Answer: Option C. -> A group of cells
Answer: (c)
Question 5. Which of the following is not a way to complete a cell entry?
  1.    Pressing enter
  2.    Pressing any arrow key on the keyboard
  3.    Clicking the Enter button on the Formula bar
  4.    Pressing spacebar
  5.    None of these
Explanation:-
Answer: Option D. -> Pressing spacebar
Answer: (d)
Question 6. All formula In Excel start with
  1.    .>
  2.    +
  3.    =
  4.    -
  5.    None of these
Explanation:-
Answer: Option C. -> =
Answer: (c)
Question 7. Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc can be applied from
  1.    from Format » Cells
  2.    from Format > > Auto format
  3.    from Table > > Auto format
  4.    All of above
  5.    None of these
Explanation:-
Answer: Option B. -> from Format > > Auto format
Answer: (b)
Question 8. To activate the previous cell in a pre-selected range, press
  1.    The Alt key
  2.    The Tab key
  3.    The Enter key
  4.    All of the above
  5.    None of these
Explanation:-
Answer: Option E. -> None of these
Answer: (e)
Question 9. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  1.    Option buttons
  2.    List boxes
  3.    Text boxes
  4.    Combo boxes
Explanation:-
Answer: Option C. -> Text boxes
Answer: (c)
Question 10. Tab scrolling buttons
  1.    Allow you to view a different worksheet
  2.    Allow you to view additional worksheet row down
  3.    Allow you to view additional worksheet columns to the right
  4.    Allow you to view additional sheet tabs
  5.    None of these
Explanation:-
Answer: Option D. -> Allow you to view additional sheet tabs
Answer: (d)
© Lakshya_Education.com, All Right Reserved.
Contact Us services