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
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

Chapter 3.1 : Overview of Finance & Accounts Department 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 overview 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