Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 60 of 64 pages
Question 591. In Excel Chart wizard term data categories refers to
  1.    A chart plot area
  2.    A horizontal axis
  3.    The organization of individual values with a chart’s data series
  4.    The data range that supply chart data
 Discuss Question
Answer: Option B. -> A horizontal axis
Answer: (b)
Question 592. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
  1.    On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign,
  2.    On the tools menu, click Add-ins, and select the Euro Currency Tools check box
  3.    Apply a selected background color
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option B. -> On the tools menu, click Add-ins, and select the Euro Currency Tools check box
Answer: (b)
Question 593. In Excel which of the following is an absolute cell reference?
  1.    !A!1
  2.    $A$1
  3.    #a#1
  4.    A1
 Discuss Question
Answer: Option B. -> $A$1
Answer: (b)
Question 594. 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 these
 Discuss Question
Answer: Option D. -> With the copy and paste buttons on the standard toolbar.
Answer: (d)
Question 595. When you group worksheets
  1.    You can enter variable data on multiple worksheets at one time
  2.    You can print more than*one worksheet at a time
  3.    You can enter common data, formats, and formulas on multiple worksheets at one time
  4.    b, and c
  5.    None of these
 Discuss Question
Answer: Option D. -> b, and c
Answer: (d)
Question 596. To copy formatting from one area in a worksheet and apply it to another area you would use
  1.    The Edit>Copy Format and Edit>Paste Format commands form the menu.
  2.    The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
  3.    There is no way to copy and apply formatting in Excel – You have to do it manually
  4.    The Format Painter button on the standard toolbar
 Discuss Question
Answer: Option D. -> The Format Painter button on the standard toolbar
Answer: (d)
Question 597. The name box
  1.    Shows the location of the previously active cell
  2.    Appears to the left of the formula bar
  3.    Appears below the status bar
  4.    Appears below the menu bar
  5.    None of these
 Discuss Question
Answer: Option B. -> Appears to the left of the formula bar
Answer: (b)
Question 598. A numeric value can be treated as label value If...... precedes It.
  1.    Apostrophe (')
  2.    Exclamation (!)
  3.    Hash (#)
  4.    Tilde(~)
  5.    None of these
 Discuss Question
Answer: Option A. -> Apostrophe (')
Answer: (a)
Question 599. You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?
  1.    & (ampersand)
  2.    = (equal sign)
  3.    (space)
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option A. -> & (ampersand)
Answer: (a)
Question 600. The spelling dialog box can be involved by choosing spelling from ___ menu.
  1.    Insert
  2.    file
  3.    tools
  4.    view
  5.    None of these
 Discuss Question
Answer: Option C. -> tools
Answer: (c)

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