Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 44 of 51 pages
Question 431. . Grid-lines may be turned off for display but turned on for printing.
  1.    1
  2.    0
 Discuss Question
Answer: Option A. -> 1
Question 432. . A function inside another function is known as ?
  1.    Round function
  2.    Sandwich function
  3.    Switch function
  4.    Nested function
 Discuss Question
Answer: Option D. -> Nested function
Question 433. . You can activate a cell by ?
  1.    Pressing the Tab key
  2.    Clicking the cell
  3.    Pressing an arrow key
  4.    All of above
 Discuss Question
Answer: Option D. -> All of above
Question 434. . What excel feature can you use if you want to work with one record at a time ?
  1.    Auto Complete
  2.    Data Form
  3.    Set Form
  4.    Auto Text
 Discuss Question
Answer: Option B. -> Data Form
Question 435. . Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.
  1.    1
  2.    0
 Discuss Question
Answer: Option A. -> 1
Question 436. . Which function is used for creating a data table ?
  1.    Sum
  2.    Table
  3.    Add
  4.    Count
 Discuss Question
Answer: Option B. -> Table
Question 437. . Which among following wildcard characters are recognized by excel ?
  1.    + and -
  2.    ! and ^
  3.    * and ?
  4.    < and >
 Discuss Question
Answer: Option C. -> * and ?
Question 438. . The accounting style shows negative numbers in ?
  1.    Bold
  2.    Italics
  3.    Parentheses
  4.    Quotes
 Discuss Question
Answer: Option C. -> Parentheses
Question 439. . 3-D reference in a formula ?
  1.    Spans worksheets
  2.    Can not be modified
  3.    Only appears on summary worksheets
  4.    Limits the formatting options
 Discuss Question
Answer: Option A. -> Spans worksheets
Question 440. . Which among following is divide symbol in excel ?
  1.    /
  2.    D
  3.    Div
  4.    \
 Discuss Question
Answer: Option A. -> /

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