Menu
Popular Courses
Search

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs


Total Questions : 635 | Page 63 of 64 pages
Question 621. When you work with large worksheets, you may need to
  1.    size the worksheet to fit on the specific number of pages
  2.    add and remove page breaks
  3.    specify only certain print areas
  4.    all of above
  5.    None of these
 Discuss Question
Answer: Option D. -> all of above
Answer: (d)
Question 622. In Excel the following is not a basic step in creating a worksheet
  1.    Save workbook
  2.    Modifiy the worksheet
  3.    Enter text and data
  4.    Copy the worksheet
 Discuss Question
Answer: Option D. -> Copy the worksheet
Answer: (d)
Question 623. Data marker on a chart are linked to data points in a . worksheet therefore,
  1.    You can automatically apply formatting to a data series
  2.    You can change the position of a data marker and automatically change the data point value in the worksheet
  3.    You can change a data print value and automatically are draw the chart
  4.    a and b
  5.    None of these
 Discuss Question
Answer: Option B. -> You can change the position of a data marker and automatically change the data point value in the worksheet
Answer: (b)
Question 624. In Excel the auto calculate feature
  1.    Can only add values in a range of cells
  2.    Provides a quick way to view the results of an arithmetic operation on a range of cells
  3.    Automatically creates formulas and adds them to a worksheet
  4.    None of the above
 Discuss Question
Answer: Option B. -> Provides a quick way to view the results of an arithmetic operation on a range of cells
Answer: (b)
Question 625. 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
  5.    None of these
 Discuss Question
Answer: Option C. -> Text boxes
Answer: (c)
Question 626. In Excel Comments put in cells are called
  1.    Smart tip
  2.    Cell tip
  3.    Web tip
  4.    Soft tip
 Discuss Question
Answer: Option B. -> Cell tip
Answer: (b)
Question 627. In Excel the cell labeled F5 refers to
  1.    row F column 5
  2.    column F row 5
  3.    function available in cells
  4.    function key F4
 Discuss Question
Answer: Option B. -> column F row 5
Answer: (b)
Question 628. In Excel which of the following special function keys allow the content in cell
  1.    Esc
  2.    Shift
  3.    Return
  4.    Tab
 Discuss Question
Answer: Option C. -> Return
Answer: (c)
Question 629. Which of the cell pointer indicates that you can fill series?
  1.    Doctor's symbol (Big Plus)
  2.    small thin plus icon
  3.    Mouse Pointer with anchor at the tip
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option B. -> small thin plus icon
Answer: (b)
Question 630. You can open the Sort dialog box by choosing Sort from the .... menu
  1.    View
  2.    Format
  3.    Tools
  4.    Data
  5.    None of these
 Discuss Question
Answer: Option D. -> Data
Answer: (d)

Share this page with your friends!

Share this page with your friends!

Latest Videos

Chapter 1 - GLOBAL STEEL SCENARIO & INDI 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)
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Log On To LOGO Computer 3rd Grade
Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant SAIL E0 2024 - GPOE/GPA
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant SAIL E0 2024 - GPOE/GPA
Chapter 2.3 : COAL HANDLING PLANT - Set Chapter 2 : Coke Ovens and Coal Chemicals SAIL E0 2024 - GPOE/GPA
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management SAIL E0 2024 - GFM