Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 43 of 51 pages
Question 421. . Protection and the Protect Sheet options can be selected from ?
  1.    Data
  2.    Tools
  3.    Edit
  4.    Format
 Discuss Question
Answer: Option B. -> Tools
Question 422. . Which function calculates your monthly mortage payment ?
  1.    PV
  2.    NPER
  3.    PMT
  4.    All of above
 Discuss Question
Answer: Option C. -> PMT
Question 423. . How can we set Page Border in Excel ?
  1.    From Edit menu
  2.    From Home
  3.    You can not set page border in Excel
  4.    From Tools menu
 Discuss Question
Answer: Option C. -> You can not set page border in Excel
Question 424. . You can check the conditions against ____ when applying conditional formatting ?
  1.    Cell Value
  2.    Formula
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option C. -> Both of above
Question 425. . How is data organized in a spreadsheet ?
  1.    Rows and columns
  2.    Layers and planes
  3.    Lines and spaces
  4.    Height and width
 Discuss Question
Answer: Option A. -> Rows and columns
Question 426. . Which types of charts can excel produce ?
  1.    Line graphs and pie charts only
  2.    Bar charts, line graphs and pie charts
  3.    Bar charts and line graphs only
  4.    Only line graphs
 Discuss Question
Answer: Option B. -> Bar charts, line graphs and pie charts
Question 427. . To insert three columns between columns A and B you would
  1.    Select column A
  2.    Select A and B
  3.    Select B
  4.    All of above
 Discuss Question
Answer: Option C. -> Select B
Question 428. . To drag a selected range of data to another worksheet in the same workbook, use the ?
  1.    Ctrl key
  2.    Shift key
  3.    Alt key
  4.    Tab key
 Discuss Question
Answer: Option A. -> Ctrl key
Question 429. . V-LOOKUP function used to ?
  1.    Finds related records
  2.    Looks up text that contain "v"
  3.    Check if two cells are identical
  4.    None of above
 Discuss Question
Answer: Option A. -> Finds related records
Question 430. . How do you change column width to fit the contents ?
  1.    Single-click the boundary to the left to the column heading
  2.    Double click the boundary to the right of the column heading
  3.    Press Alt and single click anywhere in the column
  4.    All of above
 Discuss Question
Answer: Option B. -> Double click the boundary to the right of the column heading

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

GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant SAIL E0 - GPOE/GPA 2024
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant SAIL E0 - GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set 1 Chapter 2 : Coke Ovens and Coal Chemicals SAIL E0 - GPOE/GPA 2024