Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 10 of 64 pages
Question 91. How are data organized in a spreadsheet?
  1.    Lines and spaces
  2.    Layers and planes
  3.    Rows and columns
  4.    Height and width
  5.    None of these
 Discuss Question
Answer: Option C. -> Rows and columns
Answer: (c)
Question 92. Got functions? No? You need the insert function dialog box. How do you get it?
  1.    Right click a cell and then click insert
  2.    Click the insert menu and then click function
  3.    Type - in a cell
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option B. -> Click the insert menu and then click function
Answer: (b)
Question 93. Excel files have a default extension of
  1.    Xls
  2.    Xlw
  3.    Wk1
  4.    123
 Discuss Question
Answer: Option A. -> Xls
Answer: (a)
Question 94. Data can be arranged in a worksheet in a easy to understand manner using
  1.    auto formatting
  2.    applying styles
  3.    changing fonts
  4.    all of above
  5.    None of these
 Discuss Question
Answer: Option D. -> all of above
Answer: (d)
Question 95. In Excel when you copy a formula
  1.    Excel erases the original copy of the formula
  2.    Excel edits cell references in the newly copied formula
  3.    Excel adjusts absolute cell references
  4.    Excel doesn’t adjust relative cell references
 Discuss Question
Answer: Option B. -> Excel edits cell references in the newly copied formula
Answer: (b)
Question 96. You can not link excel worksheet data to a word document
  1.    With the right drag method
  2.    With a hyperlink
  3.    With the copy and paste special commands
  4.    With the copy and paste buttons on the standard toolbar.
  5.    None of these
 Discuss Question
Answer: Option A. -> With the right drag method
Answer: (a)
Question 97. Which of the following is not the correct method of editing the cell content?
  1.    Press the Alt key
  2.    Press the F2 key
  3.    Click the formula bar
  4.    Double click the cell
  5.    None of these
 Discuss Question
Answer: Option A. -> Press the Alt key
Answer: (a)
Question 98. In Excel you can create hyperlinks from the Excel workbook to
  1.    A webpage on company internet
  2.    A web page on the internet
  3.    Other Office application documents
  4.    All
 Discuss Question
Answer: Option D. -> All
Answer: (d)
Question 99. In Excel to activate the previous cell in a preselected range, press
  1.    The Alt key
  2.    The Tab key
  3.    The Enter key
  4.    None of above
 Discuss Question
Answer: Option D. -> None of above
Answer: (d)
Question 100. You want to set such that when you type Baishakh and drag the fill .handle. Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
  1.    Fill Across Worksheet
  2.    Custom List
  3.    Auto Fill Options
  4.    Fill Series
  5.    None of these
 Discuss Question
Answer: Option B. -> Custom List
Answer: (b)

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0