Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 24 of 51 pages
Question 231. Which of the following Excel screen components can NOT be turned on or off ?
  1.    None
  2.    Tool Bar
  3.    Status Bar
  4.    Formula Bar
 Discuss Question
Answer: Option A. -> None
Question 232. Tab scroll buttons are place on Excel screen
  1.    Towards the top right corner
  2.    Towards the bottom right corner
  3.    Towards the bottom left corner
  4.    Towards the top left corner
 Discuss Question
Answer: Option C. -> Towards the bottom left corner
Question 233. Which of the cell pointer indicates that you can fill series ?
  1.    None of the listed here
  2.    Doctor's symbol (Big Plus)
  3.    Small thin plus icon
  4.    Mouse pointer with anchor at the tip
 Discuss Question
Answer: Option C. -> Small thin plus icon
Question 234. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ?
  1.    F9
  2.    F8
  3.    F10
  4.    F11
 Discuss Question
Answer: Option A. -> F9
Question 235. MS Excel provides the default value for step in fill Series dialog box
  1.    1
  2.    10
  3.    O
  4.    5
 Discuss Question
Answer: Option A. -> 1
Question 236. Paste special allows some operation while you paste to new cell. Which of the following operation is valid ?
  1.    Goal seek
  2.    Square
  3.    Divide
  4.    Percentage
 Discuss Question
Answer: Option C. -> Divide
Question 237. Ctrl+ D shortcut key in Excel will
  1.    None of the listed here
  2.    Open the font dialog box
  3.    Fill down in the selection
  4.    Apply double underline for the active cell
 Discuss Question
Answer: Option C. -> Fill down in the selection
Question 238. To remove the content of selected cells you must issue ___ command
  1.    Clear Delete
  2.    Clear Contents
  3.    Clear All
  4.    Delete
 Discuss Question
Answer: Option B. -> Clear Contents
Question 239. Which of the following series type is not valid for Fill Series dialog box ?
  1.    Time
  2.    Linear
  3.    Growth
  4.    Autofill
 Discuss Question
Answer: Option A. -> Time
Question 240. The Delete key of keyboard is assigned to which command in Excel ?
  1.    Edit > Delete
  2.    Edit > Clear > Contents
  3.    Edit > Clear >All
  4.    All of the listed here
 Discuss Question
Answer: Option B. -> Edit > Clear > Contents

Latest Videos

Latest Test Papers