Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Correct Answer :
B. Character
Related Questions
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
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
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
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
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
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
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
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
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
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
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
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
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
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
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
It is acceptable to let long text flow into adjacent cells on a worksheet when
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
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
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
The autofill feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
A numeric value can be treated as a label value if it precedes with
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
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
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )