Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 16 of 51 pages
Question 151. Which of the following option is not available in Paste Special dialog box?
  1.    Add
  2.    Subtract
  3.    Divide
  4.    SQRT
 Discuss Question
Answer: Option D. -> SQRT
Question 152. Which command will you choose to convert a column of data into row?
  1.    Cut and Paste
  2.    Paste Special > Transpose
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option B. -> Paste Special > Transpose
Question 153. It is acceptable to let long text flow into adjacent cells on a worksheet when
  1.    Data will be entered in the adjacent cells
  2.    No data will be entered in the adjacent cells
  3.    There is no suitable abbreviation for the text
  4.    There is not time to format the text
 Discuss Question
Answer: Option B. -> No data will be entered in the adjacent cells
Question 154. Which of the cell pointer indicates that you can fill series?
  1.    Doctor’s symbol (Big Plus)
  2.    Small thin plus icon
  3.    Mouse Pointer with anchor at the tip
  4.    None of above
 Discuss Question
Answer: Option B. -> Small thin plus icon
Question 155. You can auto fit the width of column by
  1.    Double clicking on the column name on column header
  2.    Double click on the cell pointer in worksheet
  3.    Double clicking on column right border on column header
  4.    Double clicking on the column left border of column header
 Discuss Question
Answer: Option C. -> Double clicking on column right border on column header
Question 156. Long text can be broken down into many lines within a cell. You can do this through
  1.    Wrap Text in Format > Cells
  2.    Justify in Edit > Cells
  3.    Text Wrapping in Format > Cells
  4.    All of above
 Discuss Question
Answer: Option A. -> Wrap Text in Format > Cells
Question 157. MS Excel provides the default value for step in Fill Series dialog box
  1.    0
  2.    1
  3.    5
  4.    10
 Discuss Question
Answer: Option B. -> 1
Question 158. Ctrl + D shortcut key in Excel will
  1.    Open the font dialog box
  2.    Apply double underline for the active cell
  3.    Fill down in the selection
  4.    None of above
 Discuss Question
Answer: Option C. -> Fill down in the selection
Question 159. When a row of data is to be converted into columns
  1.    Copy the cells in row, select the same number of cells in row and paste
  2.    Copy the cells in column then choose Paste Special, then click Transpose and OK
  3.    Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK
  4.    Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK
 Discuss Question
Answer: Option D. -> Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK
Question 160. The shortcut key Ctrl + R is used in Excel to
  1.    Right align the content of cell
  2.    Remove the cell contents of selected cells
  3.    Fill the selection with active cells to the right
  4.    None of above
 Discuss Question
Answer: Option C. -> Fill the selection with active cells to the right

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