Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 5 of 64 pages
Question 41. In Excel Multiple calculations can be made in a single formula using
  1.    array formula
  2.    standard formulas
  3.    smart formula
  4.    complex formulas
 Discuss Question
Answer: Option A. -> array formula
Question 42. In Excel if you press …….., the cell accepts your typing as its contents.
  1.    TAB
  2.    Enter
  3.    Insert
  4.    Ctrl + Enter
 Discuss Question
Answer: Option B. -> Enter
Question 43. In Excel you can use the formula palette to
  1.    Copy a range of cells
  2.    Enter assumptions data
  3.    Create and edit formulas containing functions
  4.    Format cells containing numbers
 Discuss Question
Answer: Option C. -> Create and edit formulas containing functions
Question 44. In Excel to select an individual data marker or data label, you must
  1.    Click once to select the series markers or labels and click the desired marker or label again
  2.    Double click the data series
  3.    Double click the marker or label
  4.    Double click the data series
 Discuss Question
Answer: Option C. -> Double click the marker or label
Question 45. In Excel default header for a worksheet is
  1.    None
  2.    Your name
  3.    The sheet tab name
  4.    The date and time
 Discuss Question
Answer: Option A. -> None
Question 46. Which of the following types of tables constraints will prevent the entry of duplicate rows?
  1.    Primary key
  2.    Unique
  3.    Null
  4.    Foreign key
  5.    None of these
 Discuss Question
Answer: Option B. -> Unique
Question 47. Which types of charts can excel produce?
  1.    Line graphs and pie charts only
  2.    Only line graphs
  3.    Bar charts, line graphs and pie charts
  4.    Bar charts and line graphs only
  5.    None of these
 Discuss Question
Answer: Option C. -> Bar charts, line graphs and pie charts
Question 48. In Excel to access the Go To Special feature, you can press
  1.    Ctrl + G
  2.    Ctrl + O
  3.    Ctrl + Shift + G
  4.    Ctrl + 1
 Discuss Question
Answer: Option A. -> Ctrl + G
Question 49. We can save and protect 1he workbook by
  1.    Write Reservation Password
  2.    Protection Password
  3.    Read-only Recommended
  4.    Any of the above
  5.    None of these
 Discuss Question
Answer: Option D. -> Any of the above
Question 50. Merge cells option can be applied from
  1.    Format Cells dialog box Alignment Tab
  2.    Formatting toolbar
  3.    Both of above
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option A. -> Format Cells dialog box Alignment Tab

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

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0