How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
Correct Answer :
C. now ()
Related Questions
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
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
It is acceptable to let long text flow into adjacent cells on a worksheet when
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
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
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
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
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
Excel files have a default extension of
Xls
Xlw
Wk1
123
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
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
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
The command Edit >> Fill Across Worksheet is active only when
One sheet is selected
When many sheets are selected
When no sheet is selected
None of above
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
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
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
To record a sequence of keystrokes and mouse actions to play back later we use:
Media player
Sound Recorder
Calculator
Macro Recorder
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10