Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 7 of 64 pages
Question 61. To remove the content of selected cells you must issue _____ command
  1.    Edit» Delete
  2.    Edit » Clear » Contents
  3.    Edit »> Clear» All
  4.    Data » Delete
  5.    None of these
 Discuss Question
Answer: Option B. -> Edit » Clear » Contents
Answer: (b)
Question 62. In Excel, a Data Series is defined as what?
  1.    A type of chart.
  2.    A eel I reference.
  3.    A collection of related data
  4.    Division of results
  5.    None of these
 Discuss Question
Answer: Option C. -> A collection of related data
Answer: (c)
Question 63. Which of the following action removes a sheet from workbook?
  1.    Select the sheet, then choose Edit > > Delete Sheet
  2.    Select the sheet then choose Format » Sheet » Hide
  3.    Press Insert
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option A. -> Select the sheet, then choose Edit > > Delete Sheet
Answer: (a)
Question 64. 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
  5.    None of these
 Discuss Question
Answer: Option B. -> Freeze panes command on the window menu
Answer: (b)
Question 65. You can use the formula palette to
  1.    Format cells containing numbers
  2.    Create and edit formulas containing functions
  3.    Enter assumptions data
  4.    Copy a range of cells
  5.    None of these
 Discuss Question
Answer: Option B. -> Create and edit formulas containing functions
Answer: (b)
Question 66. You can quickly change the appearance of your work by choosing Auto Format from the .... Menu
  1.    Edit
  2.    View
  3.    Format
  4.    Tools
  5.    None of these
 Discuss Question
Answer: Option C. -> Format
Answer: (c)
Question 67. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
  1.    Square
  2.    Percentage
  3.    Goal Seek
  4.    Divide
  5.    None of these
 Discuss Question
Answer: Option D. -> Divide
Answer: (d)
Question 68. In the formula, which symbol specifies the fixed columns or rows?
  1.    A.S
  2.    *
  3.    %
  4.    &
  5.    None of these
 Discuss Question
Answer: Option A. -> A.S
Answer: (a)
Question 69. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
  1.    Rows and columns
  2.    Headings
  3.    Speed
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> Speed
Answer: (c)
Question 70. The Name box
  1.    Shows the location of the previously active cell
  2.    Appears t the left of the formula bar
  3.    Appears below the status bar
  4.    Appears below the menu bar
  5.    None of these
 Discuss Question
Answer: Option B. -> Appears t the left of the formula bar
Answer: (b)

Latest Videos

Latest Test Papers