Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
Correct Answer :
D. Financial
Related Questions
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
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
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
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
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
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
Excel files have a default extension of
Xls
Xlw
Wk1
123
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
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
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
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
You cannot link excel worksheet data to a word document
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
You can edit a cell by
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above
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
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All 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
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
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
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
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above