Sail E0 Webinar

Computer Aptitude

APPLICATION SOFTWARE MCQs

Total Questions : 95 | Page 5 of 10 pages
Question 41.

Cell address A$4 in a formula means it is a

  1.    mixed cell reference
  2.    absolute cell reference
  3.    relative cell reference
  4.    All of these
  5.    None of these
 Discuss Question
Answer: Option A. -> mixed cell reference
Question 42.

Using the F11 shortcut key to create a chart on chart sheet creates

  1.    A default chart
  2.    A 2-dimensional column chart
  3.    A 2-dimensional bar chart
  4.    A 3-dimensional line chart
  5.    None of the above
 Discuss Question
Answer: Option B. -> A 2-dimensional column chart
Question 43.

You can print

  1.    a range of cells by range name
  2.    an entire worksheet
  3.    a single worksheet
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 44.

You can create only a horizontal page break by first selecting

  1.    a row below the row where you want the page break to occur
  2.    a cell in row 1
  3.    a cell in column A
  4.    ‘1’ and ‘3’
  5.    None of the above
 Discuss Question
Answer: Option D. -> ‘1’ and ‘3’
Question 45.

You can create hyperlinks from the Excel work book to

  1.    a web page on company internet
  2.    a web page on the internet
  3.    other office 97 application documents
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 46.

The advantage of using a spreadsheet is

  1.    calculations can be done automatically
  2.    changing data automatically updates      calculations
  3.    more flexibility
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 47.

You can not link excel worksheet data to a word document

  1.    with the right drag method
  2.    with a hyperlink
  3.    with the copy and paste special commands
  4.    with the copy and paste buttons on the standard toolbar
  5.    None of the above
 Discuss Question
Answer: Option D. -> with the copy and paste buttons on the standard toolbar
Question 48.

Which of the following is a popular DOS based spreadsheet package?

  1.    Word
  2.    Smart cell
  3.    Excel
  4.    Lotus 1-2-3
  5.    Power point
 Discuss Question
Answer: Option D. -> Lotus 1-2-3
Question 49.

Which file format can be added to a PowerPoint show?

  1.    .jpg
  2.     .giv
  3.    .wav
  4.    All of these
  5.    None of these
 Discuss Question
Answer: Option D. -> All of these
Question 50.

In Microsoft Power Point two kind of sound effects files that can be added to the presentation are

  1.    .wav files and .mid files
  2.    .wav files and .gif files
  3.    .wav files and .jpg files
  4.    .jpg files and .gif files
  5.    None of these
 Discuss Question
Answer: Option A. -> .wav files and .mid files

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