Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 61 of 64 pages
Question 601. Which is not the function of "Edit, Clear" command?
  1.    Delete contents
  2.    Delete notes
  3.    Delete eel is
  4.    Delete formats
  5.    None of these
 Discuss Question
Answer: Option C. -> Delete eel is
Answer: (c)
Question 602. In Excel when you are typing an equation into a cell the first thing that must be entered is
  1.    the first cell referenced
  2.    parenthesis
  3.    quotation marks
  4.    an equal sign
 Discuss Question
Answer: Option D. -> an equal sign
Answer: (d)
Question 603. In Excel 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
Answer: (a)
Question 604. What does COUNTA ( ) function do?
  1.    counts cells having alphabets
  2.    counts empty eel is
  3.    counts cells having number
  4.    counts non-empty cells
  5.    None of these
 Discuss Question
Answer: Option D. -> counts non-empty cells
Answer: (d)
Question 605. Lt is acceptable of let long text flow into adjacent cells on a worksheet when
  1.    Data will be entered in the adjacent cells
  2.    No data will be entered in the adjacent cells
  3.    There is not suitable abbreviation of the text
  4.    There is not time to format the next
  5.    None of these
 Discuss Question
Answer: Option B. -> No data will be entered in the adjacent cells
Answer: (b)
Question 606. In Excel to move to the previous worksheet, press
  1.    Alt + PgUp
  2.    Ctrl + PgUp
  3.    Ctrl + PgDn
  4.    Shift + Tab
 Discuss Question
Answer: Option D. -> Shift + Tab
Answer: (d)
Question 607. 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 608. 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
  5.    None of these
 Discuss Question
Answer: Option C. -> It can contain many sheets including worksheets and chart sheets
Answer: (c)
Question 609. The default header for a worksheet is
  1.    Your name
  2.    The date and time
  3.    None
  4.    The sheet tab name
 Discuss Question
Answer: Option C. -> None
Answer: (c)
Question 610. If you press ..... the cell accepts your typing as its contents.
  1.    Enter
  2.    Ctrl + Enter
  3.    TAB
  4.    Insert
  5.    None of these
 Discuss Question
Answer: Option A. -> Enter
Answer: (a)

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