What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Correct Answer :
C. Ctrl + H
Related Questions
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
You can move a sheet from one workbook into new book by
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Which would you choose to create a bar diagram?
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
Which of the cell pointer indicates that you can fill series?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
To view a cell comment
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts
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
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
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
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
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
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
Which of the following is not true about Find and Replace in Excel
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
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
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above
How can you remove borders applied in cells?ACC
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above