Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
Correct Answer :
D. Serial Number 50771
Related Questions
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
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the 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 information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
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
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
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
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
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
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
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
How can you remove borders applied in cells?ACC
Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
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
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
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
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Excel
StarCalc
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
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 is not the function of Edit, Clear command?
Delete contents
Delete notes
Delete cells
Delete formats
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
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
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
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
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
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
work sheet
chart sheet
module sheet
data sheet