Menu
Popular Courses
Search

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

Share this page with your friends!

Share this page with your friends!

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDI 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)
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Chapter 3.1 : Overview of Finance & Acco Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024