Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 12 of 51 pages
Question 111. Which symbol must all formula begin with?
  1.    =
  2.    +
  3.    (
  4.    @
 Discuss Question
Answer: Option A. -> =
Question 112. Which of the following formulas will Excel not be able to calculate?
  1.    =SUM(Sales)-A3
  2.    =SUM(A1:A5)*.5
  3.    =SUM(A1:A5)/(10-10)
  4.    =SUM(A1:A5)-10
 Discuss Question
Answer: Option A. -> =SUM(Sales)-A3
Question 113. Which of the following formulas is not entered correctly?
  1.    =10+50
  2.    =B7*B1
  3.    =B7+14
  4.    10+50
 Discuss Question
Answer: Option D. -> 10+50
Question 114. A typical worksheet has ________ number of columns.
  1.    128
  2.    256
  3.    1024
  4.    16384
 Discuss Question
Answer: Option D. -> 16384
Question 115. How many characters can be typed in a single cell in Excel?
  1.    256
  2.    1024
  3.    32767
  4.    65535
 Discuss Question
Answer: Option C. -> 32767
Question 116. A worksheet can have a maximum of ________ number of rows.
  1.    256
  2.    1024
  3.    65535
  4.    1048576
 Discuss Question
Answer: Option D. -> 1048576
Question 117. Which of the following is not an example of a value?
  1.    350
  2.    May 10, 2001
  3.    0.57
  4.    Serial Number 50771
 Discuss Question
Answer: Option D. -> Serial Number 50771
Question 118. The chart wizard term data series refers to
  1.    A chart legend
  2.    A collection of chart data markers
  3.    A set of values you plot in a chart
  4.    A data label
 Discuss Question
Answer: Option B. -> A collection of chart data markers
Question 119. The Chart wizard term data categories refers to;
  1.    A chart plot area
  2.    A horizontal axis
  3.    The organization of individual values with a chart’s data series
  4.    The data range that supply chart data
 Discuss Question
Answer: Option B. -> A horizontal axis
Question 120. A worksheet range is a
  1.    A command used for data modeling
  2.    A range of values such as from 23 to 234
  3.    A group of cells
  4.    A group of worksheets
 Discuss Question
Answer: Option C. -> A group of cells

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