In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
Correct Answer :
B. Rows
Related Questions
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
You cannot link excel worksheet data to a word document
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
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
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
A typical worksheet has …. Number of columns
128
256
512
1024
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
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 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
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
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
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
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