Popular Courses
Sail E0 Package
Valid Till Next Exam
Fast Math Tricks
165 videos
Quantitative Aptitude
645 Videos
Reasoning Aptitude
161 Videos
CLASS 8 MATHS(CBSE)
417 Videos
CLASS 9 MATHS(CBSE)
40 hours, 647 questions
Check All Courses
Resources
Store
Blog
More
About Us
Contact Us
Register / Login
Menu
Home
Blog
Store
About Us
Contact Us
Profile Settings
Attempted Tests
My Purchases
Popular Courses
Sail E0 Package
Valid Till Next Exam
Fast Math Tricks
165 videos
Quantitative Aptitude
645 Videos
Reasoning Aptitude
161 Videos
CLASS 8 MATHS(CBSE)
417 Videos
CLASS 9 MATHS(CBSE)
40 hours, 647 questions
Check All Courses
Search
Search
Home
Topics
Computer Aptitude
Microsoft Excel Q/a
Computer Aptitude
MICROSOFT EXCEL Q/A MCQs
Total Questions : 635 | Page
6
of 64 pages
Question 51.
Two common wildcard characters that Excel recognizes are
* and?
< and >
* and /
+ and –
None of these
See Solution
Discuss Question
Answer: Option A. ->
* and?
Question 52.
You can open the consolidate dialog box by choosing' Consolidate from the...... menu.
Insert
Format
Tools
Data
None of these
See Solution
Discuss Question
Answer: Option D. ->
Data
Question 53.
In Excel Tab scrolling buttons
Allow you to view a different worksheet
Allow you to view additional worksheet row down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheet tabs
See Solution
Discuss Question
Answer: Option D. ->
Allow you to view additional sheet tabs
Question 54.
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows tne name of worksheet currently working on
shows the name of cell or range currently working on
All of above
None of these
See Solution
Discuss Question
Answer: Option C. ->
shows the name of cell or range currently working on
Question 55.
Which function will you use to enter current time In a worksheet cell?
=today( )
-now ( )
-time ( )
=CurrentTime ( )
None of these
See Solution
Discuss Question
Answer: Option B. ->
-now ( )
Question 56.
In Excel you can select a single range of cells by
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells .
See Solution
Discuss Question
Answer: Option D. ->
Dragging over the desired cells .
Answer: (d)
Question 57.
A data map is helpful
When you have too much data to chart
To show a geographic distribution of data
To compare data points
To show changes in data over time
None of these
See Solution
Discuss Question
Answer: Option B. ->
To show a geographic distribution of data
Answer: (b)
Question 58.
To copy formatting from one area in a worksheet and apply it to another area you would use:
The Edit>Copy Format and Edit>Paste Format commands form the menu.
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
There is no way to copy and apply formatting in Excel - You have to do it manually
The Format Painter button on the standard toolbar
None of these
See Solution
Discuss Question
Answer: Option D. ->
The Format Painter button on the standard toolbar
Answer: (d)
Question 59.
In Excel when a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
See Solution
Discuss Question
Answer: Option B. ->
Increase the column width
Answer: (b)
Question 60.
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
None of these
See Solution
Discuss Question
Answer: Option A. ->
Press the Alt key
Answer: (a)
← Previous
1
2
...
4
5
6
7
8
...
63
64
Next →
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