Sail E0 Webinar

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 59 of 64 pages
Question 581. In Excel this type of software is similar to an accountant’s worksheet
  1.    Word processing
  2.    Database
  3.    Spreadsheets
  4.    Graphics
 Discuss Question
Answer: Option C. -> Spreadsheets
Answer: (c)
Question 582. 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
  5.    None of these
 Discuss Question
Answer: Option A. -> Page Break Preview.
Answer: (a)
Question 583. In Excel the auto calculate feature
  1.    Can only add values in a range of cells
  2.    Provides a quick way to view the result of an arithmetic operation on a range of cells
  3.    Automatically creates formulas and adds them to a worksheet
  4.    (A) and (C)
 Discuss Question
Answer: Option B. -> Provides a quick way to view the result of an arithmetic operation on a range of cells
Answer: (b)
Question 584. In Excel you can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
  1.    View
  2.    Insert
  3.    Format
  4.    Tools
 Discuss Question
Answer: Option D. -> Tools
Answer: (d)
Question 585. All macro keyboard shortcuts include the...... key
  1.    Alt
  2.    Ctrl
  3.    F11
  4.    Shift
  5.    None of these
 Discuss Question
Answer: Option A. -> Alt
Answer: (a)
Question 586. Which of the following is the latest version of Excel?
  1.    Excel 2000
  2.    Excel 20.02
  3.    Excel ME
  4.    Excel XP
  5.    None of these
 Discuss Question
Answer: Option D. -> Excel XP
Answer: (d)
Question 587. In Excel which is not an advantage of using computerized spreadsheets?
  1.    Flexibility of moving entries
  2.    Speed of calculation
  3.    Ability of generate tables
  4.    Cost of initial setup
 Discuss Question
Answer: Option D. -> Cost of initial setup
Answer: (d)
Question 588. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
  1.    HTML
  2.    Pivot Table Field List
  3.    Pivot Table List
  4.    Pivot Table Report
  5.    None of these
 Discuss Question
Answer: Option D. -> Pivot Table Report
Answer: (d)
Question 589. A function incite another function is called a .....function.
  1.    Nested
  2.    Round
  3.    Sum
  4.    Text
  5.    None of these
 Discuss Question
Answer: Option A. -> Nested
Answer: (a)
Question 590. Where a row and a column meet, what do you call that?
  1.    A eel I
  2.    A block
  3.    A box
  4.    All of the above
  5.    None of these
 Discuss Question
Answer: Option A. -> A eel I
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