Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 63 of 64 pages
Question 621. When you work with large worksheets, you may need to
  1.    size the worksheet to fit on the specific number of pages
  2.    add and remove page breaks
  3.    specify only certain print areas
  4.    all of above
  5.    None of these
 Discuss Question
Answer: Option D. -> all of above
Answer: (d)
Question 622. In Excel the following is not a basic step in creating a worksheet
  1.    Save workbook
  2.    Modifiy the worksheet
  3.    Enter text and data
  4.    Copy the worksheet
 Discuss Question
Answer: Option D. -> Copy the worksheet
Answer: (d)
Question 623. Data marker on a chart are linked to data points in a . worksheet therefore,
  1.    You can automatically apply formatting to a data series
  2.    You can change the position of a data marker and automatically change the data point value in the worksheet
  3.    You can change a data print value and automatically are draw the chart
  4.    a and b
  5.    None of these
 Discuss Question
Answer: Option B. -> You can change the position of a data marker and automatically change the data point value in the worksheet
Answer: (b)
Question 624. In Excel the auto calculate feature
  1.    Can only add values in a range of cells
  2.    Provides a quick way to view the results of an arithmetic operation on a range of cells
  3.    Automatically creates formulas and adds them to a worksheet
  4.    None of the above
 Discuss Question
Answer: Option B. -> Provides a quick way to view the results of an arithmetic operation on a range of cells
Answer: (b)
Question 625. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  1.    Option buttons
  2.    List boxes
  3.    Text boxes
  4.    Combo boxes
  5.    None of these
 Discuss Question
Answer: Option C. -> Text boxes
Answer: (c)
Question 626. In Excel Comments put in cells are called
  1.    Smart tip
  2.    Cell tip
  3.    Web tip
  4.    Soft tip
 Discuss Question
Answer: Option B. -> Cell tip
Answer: (b)
Question 627. In Excel the cell labeled F5 refers to
  1.    row F column 5
  2.    column F row 5
  3.    function available in cells
  4.    function key F4
 Discuss Question
Answer: Option B. -> column F row 5
Answer: (b)
Question 628. In Excel which of the following special function keys allow the content in cell
  1.    Esc
  2.    Shift
  3.    Return
  4.    Tab
 Discuss Question
Answer: Option C. -> Return
Answer: (c)
Question 629. Which of the cell pointer indicates that you can fill series?
  1.    Doctor's symbol (Big Plus)
  2.    small thin plus icon
  3.    Mouse Pointer with anchor at the tip
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option B. -> small thin plus icon
Answer: (b)
Question 630. You can open the Sort dialog box by choosing Sort from the .... menu
  1.    View
  2.    Format
  3.    Tools
  4.    Data
  5.    None of these
 Discuss Question
Answer: Option D. -> Data
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