Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 3 of 64 pages
Question 21. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply t
  1.    Use -if function to format the required numbers red
  2.    Apply Conditional Formatting command on Format menu
  3.    Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option B. -> Apply Conditional Formatting command on Format menu
Question 22. To activate the previous cell in a pre selected range, press
  1.    The Alt key
  2.    The Tab key
  3.    The Enter key
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option D. -> All of the above
Question 23. The view that puts a blue a blue line around each page that would be printed is the......
  1.    Print Preview
  2.    Normal View
  3.    Page Break Preview
  4.    Split View
  5.    None of these
 Discuss Question
Answer: Option C. -> Page Break Preview
Question 24. How do you insert a row?
  1.    Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
  2.    Select the row heading where you want to insert the new row and select Edit > Row from the menu
  3.    Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option A. -> Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Question 25. You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which Command should you use?
  1.    New
  2.    Save As
  3.    Edit
  4.    Save
  5.    None of these
 Discuss Question
Answer: Option B. -> Save As
Question 26. Excel uses the …. Function when creating a data table
  1.    Count
  2.    Table
  3.    Average
  4.    Sum
 Discuss Question
Answer: Option B. -> Table
Question 27. In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
  1.    Click the arrow on the paste button on the standard toolbar, then click formulas
  2.    Click the arrow on the paste button on the standard toolbar, then click values.
  3.    Click the Paste button on the standard toolbar
  4.    All of above
 Discuss Question
Answer: Option B. -> Click the arrow on the paste button on the standard toolbar, then click values.
Question 28. You cannot link Excel worksheet data to a Word document
  1.    With a hyperlink
  2.    With the copy and paste special commands
  3.    With the copy and paste buttons on the standard toolbar
  4.    With the right drag method
 Discuss Question
Answer: Option C. -> With the copy and paste buttons on the standard toolbar
Question 29. In Excel To select several cells or ranges that are not touching each other, you would … while selecting
  1.    hold down the Shift key
  2.    hold down the Alt key
  3.    hold down Ctrl + Shift key
  4.    hold down the Ctrl key
 Discuss Question
Answer: Option D. -> hold down the Ctrl key
Question 30. In Excel which of the following formulas will Excel not be able to calculate?
  1.    =SUM(A1:A5)-10
  2.    =SUM(A1:A5)/(10-10)
  3.    =SUM(A1:A5)*.5
  4.    =SUM(Sales)-A3
 Discuss Question
Answer: Option D. -> =SUM(Sales)-A3

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

Chapter 3.1 : Overview of Finance & Accounts Department Chapter 3 : Finance & Accounts SAIL E0 - GFM 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management SAIL E0 - GFM 2024
Chapter 1.1 : Personnel Functions- An overview Chapter 1 : Personnel Management SAIL E0 - GFM 2024
GPOE / GPA Combined 1 Free CBT Mock Test SAIL E0 2024
CBT Mixed Test 1 GPOE/GPA SAIL E0 2024