Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 49 of 51 pages
Question 481. . To convert a column of data into row, which command will you choose
  1.    Edit -> Paste Special -> Transpose
  2.    Cut and Paste
  3.    Both of above
  4.    None of above
 Discuss Question
Answer: Option A. -> Edit -> Paste Special -> Transpose
Question 482. . In Paste Special dialog box, which of the following option is not available ?
  1.    Divide
  2.    Add
  3.    Subtract
  4.    Square root
 Discuss Question
Answer: Option D. -> Square root
Question 483. What is the intersection of a column and a row on a worksheet called ?
  1.    Column
  2.    Value
  3.    Address
  4.    Cell
 Discuss Question
Answer: Option D. -> Cell
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 484. Which functionin Excel tells how many numeric entries are there ?
  1.    NUM
  2.    COUNT
  3.    SUM
  4.    CHKNUM
 Discuss Question
Answer: Option B. -> COUNT
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 485. What type of chart is useful for comparing values over categories ?
  1.    Pie Chart
  2.    Column Chart
  3.    Line Chart
  4.    Dot Graph
 Discuss Question
Answer: Option B. -> Column Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 486. Functions in MS Excel must begin with ___
  1.    An () sign
  2.    An Equal Sign
  3.    A Plus Sign
  4.    A > Sign
 Discuss Question
Answer: Option B. -> An Equal Sign
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 487. Statistical calculations and preparation of tables and graphs can be done using
  1.    Adobe Photoshop
  2.    Excel
  3.    Notepad
  4.    Power Point
 Discuss Question
Answer: Option B. -> Excel
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 488. Which one is not a Function in MS Excel ?
  1.    SUM
  2.    AVG
  3.    MAX
  4.    MIN
 Discuss Question
Answer: Option B. -> AVG
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 489. What type of chart will you use to compare performance of two employees in the year 2016 ?
  1.    Column Chart
  2.    Line Chart
  3.    Pie Chart
  4.    Dot Chart
 Discuss Question
Answer: Option B. -> Line Chart
NO EXPLANATION IS AVAILABLE FOR THIS QUESTION!
Question 490. A features that displays only the data in column (s) according to specified criteria
  1.    Formula
  2.    Sorting
  3.    Filtering
  4.    Pivot
 Discuss Question
Answer: Option C. -> Filtering
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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0