Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 9 of 51 pages
Question 81. The Paste Special command lets you copy and paste:
  1.    Multiply the selection by a copied value
  2.    Cell comments
  3.    Formatting options
  4.    The resulting values of a formula instead of the actual formula
 Discuss Question
Answer: Option D. -> The resulting values of a formula instead of the actual formula
Question 82. The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this?
  1.    You have to retype everything and manually add the dollar signs, commas, and decimals
  2.    Select Format > Money from the menu
  3.    Click the Currency Style button on the formatting toolbar
  4.    None of these
 Discuss Question
Answer: Option C. -> Click the Currency Style button on the formatting toolbar
Question 83. 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
 Discuss Question
Answer: Option C. -> Text boxes
Question 84. Which of the following options is not located in the Page Setup dialog box?
  1.    Page Break Preview
  2.    Page Orientation
  3.    Margins
  4.    Headers and Footers
 Discuss Question
Answer: Option A. -> Page Break Preview
Question 85. 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
 Discuss Question
Answer: Option C. -> Line chart
Question 86. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  1.    Press Ctrl + Home
  2.    Press Home
  3.    Press Shift + Home
  4.    Press Alt + Home
 Discuss Question
Answer: Option A. -> Press Ctrl + Home
Question 87. If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:
  1.    Press the Erase key
  2.    Press Esc
  3.    Press the Enter button
  4.    Press the Edit Formula button
 Discuss Question
Answer: Option B. -> Press Esc
Question 88. Which of the following methods can not be used to edit the contents of a cell?
  1.    Press the Alt key
  2.    Clicking the formula bar
  3.    Pressing the F2 key
  4.    Double clicking the cell
 Discuss Question
Answer: Option A. -> Press the Alt key
Question 89. To view a cell comment
  1.    Click the edit comment command on the insert menu
  2.    Click the display comment command on the window menu
  3.    Position the mouse pointer over the cell
  4.    Click the comment command on the view menu
 Discuss Question
Answer: Option C. -> Position the mouse pointer over the cell
Question 90. When you want to insert a blank embedded excel object in a word document you can
  1.    Click the object command on the insert menu
  2.    Click the office links button on the standard toolbar
  3.    Click the create worksheet button on the formatting toolbar
  4.    Click the import excel command on the file menu
 Discuss Question
Answer: Option A. -> Click the object command on the insert menu

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