To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Correct Answer :
B. Edit >> Clear >> Contents
Related Questions
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
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
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
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
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
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
You can use drag-and-drop to embed excel worksheet data in a word document
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
Excel files have a default extension of
Xls
Xlw
Wk1
123
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
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
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
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
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
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
Which Chart can be created in Excel?
Area
Line
Pie
All of the above