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
Correct Answer :
D. You can not set page border in Excel
Related Questions
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
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
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
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
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
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
To edit in an embedded excel worksheet object in a word document
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
When you copy a formula
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
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
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
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
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
The name box
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
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
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
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