Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 58 of 64 pages
Question 571. In Excel which of the following is not an option in the spelling dialog box
  1.    Edit
  2.    Ignore
  3.    Ignore all
  4.    Change
 Discuss Question
Answer: Option A. -> Edit
Answer: (a)
Question 572. To return the remainder after a number Is divided by a divisor In EXCEL we use the function?
  1.    ROUND ( )
  2.    FACTQ
  3.    MODQ
  4.    DIV()
  5.    None of these
 Discuss Question
Answer: Option C. -> MODQ
Answer: (c)
Question 573. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
  1.    Unfreeze panes command on the window menu
  2.    Freeze panes command on the window menu
  3.    Hold titles command on the edit menu
  4.    Split command on the window menu
  5.    None of these
 Discuss Question
Answer: Option B. -> Freeze panes command on the window menu
Answer: (b)
Question 574. When working in the page break preview, you can
  1.    view exactly where each page break occurs
  2.    add or remove page breaks
  3.    change the print area
  4.    all of above
  5.    None of these
 Discuss Question
Answer: Option D. -> all of above
Answer: (d)
Question 575. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
  1.    Pie chart
  2.    Row chart
  3.    Line chart
  4.    Column chart
  5.    None of these
 Discuss Question
Answer: Option C. -> Line chart
Answer: (c)
Question 576. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
  1.    Point to speech on the tools menu, and then click show text to speech toolbar.
  2.    Click validation on the data menu
  3.    Point to speech on the tools menu, and then click speech recognition
  4.    All of above
  5.    None bf these
 Discuss Question
Answer: Option A. -> Point to speech on the tools menu, and then click show text to speech toolbar.
Answer: (a)
Question 577. There are three types of data found in a spreadsheet.
  1.    data, words, numbers
  2.    equations, data, numbers
  3.    words, numbers, labels
  4.    numbers formulas, labels
  5.    None of these
 Discuss Question
Answer: Option D. -> numbers formulas, labels
Answer: (d)
Question 578. To select several cells or ranges that are not touching each other, you would ... while selecting
  1.    hold down the Ctrl key
  2.    hold down the Shift key
  3.    hold down the Alt key
  4.    hold down Ctrl + Shin key
  5.    None of these
 Discuss Question
Answer: Option A. -> hold down the Ctrl key
Answer: (a)
Question 579. In Excel the auto fill feature
  1.    Extends a sequential series of data
  2.    Automatically adds a range of cell values
  3.    Applies a boarder around selected cells
  4.    None of above
 Discuss Question
Answer: Option D. -> None of above
Answer: (d)
Question 580. Hyperlinks can be
  1.    Text
  2.    Drawing objects
  3.    Pictures
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of above
Answer: (d)

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