Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
Correct Answer :
C. Name Box
Related Questions
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
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, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
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
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
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
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
Excel files have a default extension of
Xls
Xlw
Wk1
123
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
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
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
Which of the cell pointer indicate that you can move the content to other cell?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Which of the following formulas is not entered correctly?
=10+50
10+50
=10+50
=B7+14
Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
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