Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 8 of 64 pages
Question 71. Excel displays the current cell address In the..........
  1.    Formula bar
  2.    Status Bar
  3.    Name Box
  4.    Title Bar
  5.    None of these
 Discuss Question
Answer: Option C. -> Name Box
Answer: (c)
Question 72. In Excel to hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
  1.    Unfreeze panes command on the window menu
  2.    Freeze panes command on the window menu
  3.    Hold titles command on the edit menu
  4.    Split command on the window menu
 Discuss Question
Answer: Option B. -> Freeze panes command on the window menu
Answer: (b)
Question 73. If you need a text to show vertically In a cell. How will you achieve this?
  1.    Choose Vertical on Text alignment In Format Cells dialog box
  2.    Choose 90 Degrees in Orientation of Format Cells dialog box
  3.    Choose Distributed from the Vertical drop down list of Format Cells dialog box
  4.    Choose Center Across Selection from Horizontal combo box In Format Cells dialog box
  5.    None of these
 Discuss Question
Answer: Option B. -> Choose 90 Degrees in Orientation of Format Cells dialog box
Answer: (b)
Question 74. In Excel 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
 Discuss Question
Answer: Option C. -> A group of cells
Answer: (c)
Question 75. You can copy data or formulas
  1.    With the copy, paste and cut commands on the edit menu
  2.    With commands on the shortcut menu
  3.    With buttons on the standard toolbars
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of the above
Answer: (d)
Question 76. To select an entire column in MS-EXCEL, press?
  1.    CTRL + C
  2.    CTRL + Arrow key
  3.    CTRL + S
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of the above
Answer: (d)
Question 77. What will be the output If you format the cell containing 5436.8 as '#,##0.00'?
  1.    5,430.00
  2.    5,436.80.
  3.    5,436.8
  4.    6.8
  5.    None of these
 Discuss Question
Answer: Option B. -> 5,436.80.
Answer: (b)
Question 78. Text formulas:
  1.    Replace cell references
  2.    Return ASCII values of characters
  3.    Concatenate and manipulate text
  4.    Show formula error value
  5.    None of these
 Discuss Question
Answer: Option C. -> Concatenate and manipulate text
Answer: (c)
Question 79. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
  1.    Edit
  2.    Insert
  3.    Format
  4.    Tools
 Discuss Question
Answer: Option D. -> Tools
Answer: (d)
Question 80. In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
  1.    Unfreeze panes command on the window menu
  2.    Freeze panes command on the window menu
  3.    Hold titles command on the edit menu
  4.    Split command on the window menu
 Discuss Question
Answer: Option B. -> Freeze panes command on the window menu
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

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0