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
Correct Answer :
C. Both of above
Related Questions
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
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
When you insert an excel file into a word document. The data are
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
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
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border 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
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
The spelling dialog box can be involved by choosing spelling from ________ menu.
insert
file
tools
view
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
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
The active cell:
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
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
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
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
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
If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
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 action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous