Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 19 of 51 pages
Question 181. Concatenation of text can be done using
  1.    Apostrophe ( ‘ )
  2.    Exclamation ( ! )
  3.    Hash ( # )
  4.    Ampersand ( & )
 Discuss Question
Answer: Option D. -> Ampersand ( & )
Question 182. Which area in an Excel window allows entering values and formulas?
  1.    Title Bar
  2.    Menu Bar
  3.    Formula Bar
  4.    Standard Tool Bar
 Discuss Question
Answer: Option C. -> Formula Bar
Question 183. Multiple calculations can be made in a single formula using ________
  1.    Standard Formulas
  2.    Array Formula
  3.    Complex Formulas
  4.    Smart Formula
 Discuss Question
Answer: Option B. -> Array Formula
Question 184. An Excel Workbook is a collection of ________
  1.    Workbooks
  2.    Worksheets
  3.    Charts
  4.    Worksheets and Charts
 Discuss Question
Answer: Option D. -> Worksheets and Charts
Question 185. What do you mean by a Workspace?
  1.    Group of Columns
  2.    Group of Worksheets
  3.    Group of Rows
  4.    Group of Workbooks
 Discuss Question
Answer: Option D. -> Group of Workbooks
Question 186. MS-EXCEL is based on ________
  1.    WINDOWS
  2.    DOS
  3.    UNIX
  4.    OS/2
 Discuss Question
Answer: Option A. -> WINDOWS
Question 187. In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.
  1.    AutoFill
  2.    Auto correct
  3.    Auto sum
  4.    Auto format
 Discuss Question
Answer: Option C. -> Auto sum
Question 188. To select an entire column in MS-EXCEL, press?
  1.    CTRL + C
  2.    CTRL + Arrow key
  3.    CTRL + S
  4.    None of the above
 Discuss Question
Answer: Option D. -> None of the above
Question 189. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  1.    ROUND ( )
  2.    FACT ( )
  3.    MOD ( )
  4.    DIV ( )
 Discuss Question
Answer: Option C. -> MOD ( )
Question 190. Which is not the function of "Edit, Clear" command?
  1.    Delete contents
  2.    Delete notes
  3.    Delete cells
  4.    Delete formats
 Discuss Question
Answer: Option C. -> Delete 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