Right clicking something in Excel:
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
Correct Answer :
C. Opens a shortcut menu listing everything you can do to the object
Related Questions
The short cut key Ctrl + R is used in Excel to
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above
The spelling dialog box can be involved by choosing spelling from ________ menu.
insert
file
tools
view
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
Excel files have a default extension of
Xls
Xlw
Wk1
123
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
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
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
work sheet
chart sheet
module sheet
data sheet
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
XY Chart
Line Chart
Pie Chart
Column Chart
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
Which is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells