Menu
Popular Courses
Sail E0 20253 months
Fast Math Tricks165 videos
Quantitative Aptitude645 Videos
Reasoning Aptitude161 Videos
CLASS 8 MATHS(CBSE)417 Videos
CLASS 9 MATHS(CBSE)40 hours, 647 questions
Check All Courses
Search

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!

Share this page with your friends!

Share this page with your friends!

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDI 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

Chapter 3.1 : Overview of Finance & Acco Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024