Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 50 of 51 pages
Question 491. Which functionin Excel checks whether a condition is true or not ?
  1.    SUM
  2.    COUNT
  3.    IF
  4.    AVERAGE
 Discuss Question
Answer: Option C. -> IF
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 492. In Excel, Columns are labelled as ___
  1.    A, B, C, etc
  2.    1,2,3 etc
  3.    A1, A2, etc.
  4.    $A$1, $A$2, etc.
 Discuss Question
Answer: Option A. -> A, B, C, etc
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 493. What type of chart is useful for showing trends or changes over time ?
  1.    Pie Chart
  2.    Column Chart
  3.    Line Chart
  4.    Dot Graph
 Discuss Question
Answer: Option C. -> Line Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 494. The Greater Than sign (>) is an example of _____ operator.
  1.    Arithmatic
  2.    Logical
  3.    Conditional
  4.    Greater
 Discuss Question
Answer: Option B. -> Logical
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 495. How will you graphically represent expenditure in different departments ?
  1.    Column Chart
  2.    Line Chart
  3.    Pie Chart
  4.    Dot Chart
 Discuss Question
Answer: Option C. -> Pie Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 496. What type of chart is good for single series of data ?
  1.    Column Chart
  2.    Line Chart
  3.    Pie Chart
  4.    Cone Chart
 Discuss Question
Answer: Option C. -> Pie Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 497. In Excel, Rows are labelled as ______
  1.    A, B, C, etc
  2.    1,2,3 etc
  3.    A1, A2, etc.
  4.    $A$1, $A$2, etc.
 Discuss Question
Answer: Option B. -> 1,2,3 etc
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 498. What type of chart is useful for comparing parts of a whole ?
  1.    Pie Chart
  2.    Column Chart
  3.    Line Chart
  4.    Dot Graph
 Discuss Question
Answer: Option A. -> Pie Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 499. The ____ feature of MS Excel quickly completes a series of data
  1.    Auto Complete
  2.    Auto Fill
  3.    Fill Handle
  4.    Sorting
 Discuss Question
Answer: Option B. -> Auto Fill
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 500. The process of arrenging the items of a column in some sequence or order is known as :
  1.    Arrengin
  2.    Autofill
  3.    Sorting
  4.    Filtering
 Discuss Question
Answer: Option C. -> Sorting
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!

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