Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 23 of 51 pages
Question 221. A worksheet range is a
  1.    A group of worksheets
  2.    A range of values such as from 23 to 234
  3.    A group of cells
  4.    A command used for data modeling
 Discuss Question
Answer: Option C. -> A group of cells
Question 222. Which symbol must all formula begin with?
  1.    +
  2.    (
  3.    =
  4.    @
 Discuss Question
Answer: Option C. -> =
Question 223. A typical worksheet has ___ number of columns.
  1.    1024
  2.    128
  3.    256
  4.    16384
 Discuss Question
Answer: Option D. -> 16384
Question 224. 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 225. Concatenation of text can be done using
  1.    Exclamation (!)
  2.    Hash (#)
  3.    Ampersand (&)
  4.    Apostrophe (')
 Discuss Question
Answer: Option C. -> Ampersand (&)
Question 226. You can check the conditions against ____ when applying conditional formatting
  1.    Cell value
  2.    Formula
  3.    None
  4.    Both
 Discuss Question
Answer: Option D. -> Both
Question 227. When a range is selected, how can you activate the previous cell ?
  1.    None
  2.    Press the Alt key
  3.    Press Enter
  4.    Press Tab
 Discuss Question
Answer: Option A. -> None
Question 228. How can you remove borders applied in cells ?
  1.    Both
  2.    None
  3.    Open the list on Border tool in Format Cell toolbar then choose first tool (none))
  4.    Choose None on Border tab of Format cells
 Discuss Question
Answer: Option A. -> Both
Question 229. Excel uniquely identifies cells within a worksheet with a cell name
  1.    Column numbers and row letters
  2.    Cell names
  3.    Cell locator coordinates
  4.    Column latters and row numbers
 Discuss Question
Answer: Option D. -> Column latters and row numbers
Question 230. Which of the following option is not available in paste Special dialog box ?
  1.    SQRT
  2.    Divide
  3.    Add
  4.    Subtract
 Discuss Question
Answer: Option A. -> SQRT

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