Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Correct Answer :
C. Formula Bar
Related Questions
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
A numeric value can be treated as a label value if it precedes with
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
You can use the formula pallette to
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
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 menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split
View > Split
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
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
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
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
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
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
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
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
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial