Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 20 of 51 pages
Question 191. Which function is not available in the Consolidate dialog box?
  1.    Pmt
  2.    Average
  3.    Max
  4.    Sum
 Discuss Question
Answer: Option A. -> Pmt
Question 192. Microsoft Excel is a powerful ________
  1.    Word processing package
  2.    Spreadsheet package
  3.    Communication S/W Package
  4.    DBMS package
 Discuss Question
Answer: Option B. -> Spreadsheet package
Question 193. How do you rearrange the data in ascending or descending order?
  1.    Data, Sort
  2.    Data, Form
  3.    Data, Table
  4.    Data Subtotals
 Discuss Question
Answer: Option A. -> Data, Sort
Question 194. Which Chart can be created in Excel?
  1.    Area
  2.    Line
  3.    Pie
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 195. What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?
  1.    5430
  2.    5436.80
  3.    5436.8
  4.    6.8
 Discuss Question
Answer: Option C. -> 5436.8
Question 196. 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 197. 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 198. 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 199. 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 200. 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

Latest Videos

Latest Test Papers