Menu
Popular Courses
Sail E0 PackageValid Till Next Exam
Fast Math Tricks165 videos
Quantitative Aptitude645 Videos
Reasoning Aptitude161 Videos
CLASS 8 MATHS(CBSE)417 Videos
CLASS 9 MATHS(CBSE)40 hours, 647 questions
Check All Courses
Search

Computer Aptitude

MICROSOFT EXCEL Q/A MCQs

Total Questions : 635 | Page 2 of 64 pages
Question 11. You can enter which types of data into worksheet cells?
  1.    Labels, values, and formulas
  2.    Labe31s and values but not formulas
  3.    Values and formulas but not labels
  4.    Formulas only
  5.    None of these
 Discuss Question
Answer: Option A. -> Labels, values, and formulas
Question 12. Which menu option can be used to split windows into two
  1.    View > window > split
  2.    Format > window
  3.    Window > split
  4.    View > split
  5.    None of these
 Discuss Question
Answer: Option C. -> Window > split
Question 13. What Is entered by the function •today ()
  1.    The date value for the day according to system clock
  2.    The time value according to system clock
  3.    Today's date as Text format
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option A. -> The date value for the day according to system clock
Question 14. To copy cell contents using drag and drop press the
  1.    End key
  2.    Shift key
  3.    Ctrl key
  4.    Esc key
  5.    None of these
 Discuss Question
Answer: Option D. -> Esc key
Question 15. Ctrl +p shortcut key in Excel will
  1.    Open the font dialog box
  2.    Apply double underline for the active cell
  3.    Fill down in the selection
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> Fill down in the selection
Question 16. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
  1.    Rows and columns
  2.    Headings
  3.    Speed
  4.    None
 Discuss Question
Answer: Option C. -> Speed
Question 17. Which of the following is not information you can specify using the solver?
  1.    Input cells
  2.    Constraints
  3.    Target cell
  4.    Changing cells
  5.    None of these
 Discuss Question
Answer: Option A. -> Input cells
Question 18. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
  1.    Use Ctrl to select all three cells, then click the paste button on the standard toolbar
  2.    Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
  3.    Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
  4.    All of above
  5.    None of these
 Discuss Question
Answer: Option C. -> Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
Question 19. You can open the consolidate dialog box by choosing Consolidate from the..... menu.
  1.    Insert
  2.    Format
  3.    Tools
  4.    Data
  5.    None of these
 Discuss Question
Answer: Option D. -> Data
Question 20. To select a column the easiest method is to........
  1.    Double click any cell in the column
  2.    Drag from the top cell in the column to the last cell in the column
  3.    click the column heading
  4.    click the column label
  5.    None of these
 Discuss Question
Answer: Option C. -> click the column heading

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 2024
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 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant GPOE/GPA 2024
Chapter 1.1 : Personnel Functions- An ov Chapter 1 : Personnel Management GFM 2024
Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set Chapter 2 : Coke Ovens and Coal Chemicals GPOE/GPA 2024
Chapter 2.1 : Overview Chapter 2 : Materials Management GFM 2024