Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 48 of 51 pages
Question 471. . When you press Ctrl + X after selecting some cells in Excel, what will happen then
  1.    The cell content of selected cells disappear from cell and stored in clipboard
  2.    The selected cells are deleted and cells are shifted up
  3.    The selected cells are deleted and the cells are shifted left
  4.    The cells selected are marked for cutting
 Discuss Question
Answer: Option D. -> The cells selected are marked for cutting
Question 472. . Choose from the following, which is not the correct method of editing the cell content ?
  1.    Press the Alt key
  2.    Press the F2 key
  3.    Double click the cell
  4.    Click the formula bar
 Discuss Question
Answer: Option A. -> Press the Alt key
Question 473. . In Paste Special dialog box, which of the following option is not available ?
  1.    Divide
  2.    Add
  3.    Subtract
  4.    Square root
 Discuss Question
Answer: Option D. -> Square root
Question 474. . To convert a column of data into row, which command will you choose
  1.    Edit -> Paste Special -> Transpose
  2.    Cut and Paste
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option A. -> Edit -> Paste Special -> Transpose
Question 475. . Using Paste Special command which of the following you can paste selectively
  1.    Formulas
  2.    Validation
  3.    Formats
  4.    All of above
 Discuss Question
Answer: Option D. -> All of above
Question 476. . On Excel screen, Tab scroll buttons are
  1.    towards the top left corner
  2.    towards the top right corner
  3.    towards the bottom right corner
  4.    towards the bottom left corner
 Discuss Question
Answer: Option D. -> towards the bottom left corner
Question 477. . Choose from the following, which is not the correct method of editing the cell content ?
  1.    Press the Alt key
  2.    Press the F2 key
  3.    Double click the cell
  4.    Click the formula bar
 Discuss Question
Answer: Option A. -> Press the Alt key
Question 478. . In Excel Worksheet how can you show or hide the grid-lines ?
  1.    Click Grid-line tool on Forms toolbar
  2.    Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option C. -> Both of above
Question 479. . When you press Ctrl + X after selecting some cells in Excel, what will happen then
  1.    The cell content of selected cells disappear from cell and stored in clipboard
  2.    The selected cells are deleted and cells are shifted up
  3.    The selected cells are deleted and the cells are shifted left
  4.    The cells selected are marked for cutting
 Discuss Question
Answer: Option D. -> The cells selected are marked for cutting
Question 480. . Using Paste Special command which of the following you can paste selectively
  1.    Formulas
  2.    Validation
  3.    Formats
  4.    All of above
 Discuss Question
Answer: Option D. -> All of above

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