Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 21 of 51 pages
Question 201. How do you wrap the text in a cell?
  1.    Format, cells, font
  2.    Format, cells, protection
  3.    Format, cells, number
  4.    Format, cells, alignment
 Discuss Question
Answer: Option D. -> Format, cells, alignment
Question 202. In the formula, which symbol specifies the fixed columns or rows?
  1.    $
  2.    *
  3.    %
  4.    &
 Discuss Question
Answer: Option A. -> $
Question 203. What does COUNTA () function do?
  1.    Counts cells having alphabets
  2.    Counts empty cells
  3.    Counts cells having number
  4.    Counts non-empty cells
 Discuss Question
Answer: Option D. -> Counts non-empty cells
Question 204. What is the short cut key to highlight the entire column?
  1.    Ctrl + C
  2.    Ctrl + Enter
  3.    Ctrl + Page Up
  4.    Ctrl + Space Bar
 Discuss Question
Answer: Option D. -> Ctrl + Space Bar
Question 205. A circular reference is
  1.    A formula that either directly or indirectly depends on itself
  2.    A cell that points to a drawing object
  3.    Geometric modeling tool
  4.    Always erroneous
 Discuss Question
Answer: Option A. -> A formula that either directly or indirectly depends on itself
Question 206. When you insert an excel file into a word document. The data are
  1.    Hyperlinked placed in a word table
  2.    Embedded
  3.    Use the word menu bar and toolbars
  4.    Linked
 Discuss Question
Answer: Option D. -> Linked
Question 207. All worksheet formula
  1.    Manipulate values
  2.    Use the addition operator
  3.    Manipulate labels
  4.    Return a formula result
 Discuss Question
Answer: Option D. -> Return a formula result
Question 208. The Paste Special command lets you copy and paste:
  1.    Cell comments
  2.    The resulting values of a formula instead of the actual formula
  3.    Multiply the selection by a copied value
  4.    Formatting options
 Discuss Question
Answer: Option B. -> The resulting values of a formula instead of the actual formula
Question 209. Excel probably considers the cell entry January 1, 2020 to be a
  1.    Text string
  2.    Label
  3.    Formula
  4.    Value
 Discuss Question
Answer: Option D. -> Value
Question 210. Which of the following options is not located in the page setup dialog box ?
  1.    Page Orientation
  2.    Headers and Footers
  3.    Margins
  4.    Page Break Preview
 Discuss Question
Answer: Option D. -> Page Break Preview

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