Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 4 of 64 pages
Question 31. In Excel the drag and drop method of copying or moving
  1.    Can be used between workbooks but not worksheets
  2.    Can be used between worksheets but not workbooks
  3.    Can be used between workbooks but not worksheets
  4.    None
 Discuss Question
Answer: Option C. -> Can be used between workbooks but not worksheets
Question 32. In Excel to activate the previous cell in a preselected range, press
  1.    The Enter key
  2.    The Alt key
  3.    The Tab key
  4.    None of the above
 Discuss Question
Answer: Option D. -> None of the above
Question 33. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu
  1.    Format
  2.    Edit
  3.    View
  4.    Tools
 Discuss Question
Answer: Option A. -> Format
Question 34. In Excel using the F11 shortcut key to create a chart on chart sheet creates
  1.    A 2-dimensional column chart
  2.    A default chart
  3.    A 3-dimensional line chart
  4.    A 2-dimensional bar chart
 Discuss Question
Answer: Option A. -> A 2-dimensional column chart
Question 35. In Excel you can convert existing excel worksheet data an charts to an HTML document by using
  1.    Import wizard
  2.    Intranet wizard
  3.    Internet assistant wizard
  4.    FTP wizard
 Discuss Question
Answer: Option C. -> Internet assistant wizard
Question 36. In Excel which of the following is not a worksheet design criterion
  1.    Auditability
  2.    Efficiency
  3.    Clarity Correct Answer:
  4.    Description
 Discuss Question
Answer: Option C. -> Clarity Correct Answer:
Question 37. In Excel you can edit a cell by
  1.    Selecting Edit>Edit Cell from the menu
  2.    Clicking the formula button
  3.    Double clicking the cell to edit it in-place
  4.    None of above
 Discuss Question
Answer: Option C. -> Double clicking the cell to edit it in-place
Question 38. In Excel when you use the fill effects in the format data series dialog box, you cannot
  1.    Select a fore ground color
  2.    Select a pattern
  3.    Select a background color
  4.    Rotate text on the chart
 Discuss Question
Answer: Option D. -> Rotate text on the chart
Question 39. In Excel when you group worksheets
  1.    You can enter common data, formats, and formulas on multiple worksheets at one time
  2.    You can print more than one worksheet at a time
  3.    You can enter variable data on multiple worksheets at one time
  4.    (B) and (C)
 Discuss Question
Answer: Option D. -> (B) and (C)
Question 40. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
  1.    Click page setup on the file menu, click the page tab, click the options button, then enter your choices.
  2.    Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.
  3.    Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles
  4.    All of above
 Discuss Question
Answer: Option C. -> Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles

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