Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 8 of 51 pages
Question 71. You can convert existing excel worksheet data an charts to an HTML document by using
  1.    FTP wizard
  2.    Internet assistant wizard
  3.    Intranet wizard
  4.    Import wizard
 Discuss Question
Answer: Option B. -> Internet assistant wizard
Question 72. A circular reference is
  1.    Geometric modeling tool
  2.    A cell that points to a drawing object
  3.    A formula that either directly or indirectly depends on itself
  4.    Always erroneous
 Discuss Question
Answer: Option C. -> A formula that either directly or indirectly depends on itself
Question 73. Which of following is Not one of Excel's what-if function?
  1.    Goal seek
  2.    Solver
  3.    Scenario manager
  4.    Auto Outline
 Discuss Question
Answer: Option D. -> Auto Outline
Question 74. Which of the following is not information you can specify using the solver?
  1.    Input cells
  2.    Constraints
  3.    Target cell
  4.    Changing cells
 Discuss Question
Answer: Option A. -> Input cells
Question 75. When you insert an excel file into a word document. The data are
  1.    Hyperlinked placed in a word table
  2.    Linked
  3.    Embedded
  4.    Use the word menu bar and toolbars
 Discuss Question
Answer: Option B. -> Linked
Question 76. Each excel file is called a workbook because
  1.    It can contain text and data
  2.    It can be modified
  3.    It can contain many sheets including worksheets and chart sheets
  4.    You have to work hard to create it
 Discuss Question
Answer: Option C. -> It can contain many sheets including worksheets and chart sheets
Question 77. Excel probably considers the cell entry January 1, 2020 to be a
  1.    Label
  2.    Value
  3.    Formula
  4.    Text string
 Discuss Question
Answer: Option B. -> Value
Question 78. You can enter which types of data into worksheet cells?
  1.    Labels, values, and formulas
  2.    Labels and values but not formulas
  3.    Values and formulas but not labels
  4.    Formulas only
 Discuss Question
Answer: Option A. -> Labels, values, and formulas
Question 79. All worksheet formula
  1.    Manipulate values
  2.    Manipulate labels
  3.    Return a formula result
  4.    Use the addition operator
 Discuss Question
Answer: Option C. -> Return a formula result
Question 80. Which of the following is a correct order of precedence in formula calculation?
  1.    Multiplication and division exponentiation positive and negative values
  2.    Multiplication and division, positive and negative values, addition and subtraction
  3.    Addition and subtraction, positive and negative values, exponentiation
  4.    None of above
 Discuss Question
Answer: Option D. -> None of above

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