# Bank Exams :: Computer Awareness :: Ms Excel

## Home Bank Exams / Computer Awareness Ms Excel Questions and Answers

1 .
On an excel sheet the active cell in indicated by?
A dotted border
A dark wide border
By italic text
None of these
2 .
With which of the following all formulas in excel starts?
/
*
$= @  View Answer Discuss in Forum 3 . Which among following is associated with excel? Graphic program word processor presentation spreadsheet None of these  View Answer Discuss in Forum 4 . You can convert existing Excel worksheet data and charts to HTML document by using the? Internet Assistant Wizard Internet Wizard import wizard Export wizard Internet import wizard  View Answer Discuss in Forum 5 . Which of the following is not a valid Zoom percentage in Excel? 10 100 300 500 600  View Answer Discuss in Forum 6 . How can we set Page Border in Excel? From Edit Menu From Home You cannot set page border in Excel From Tools Menu None of these  View Answer Discuss in Forum 7 . Which types of charts can excel produce? Line graphs and pie charts only Bar charts, line graphs and pie charts Bar charts and line graphs only Only line graphs None of these  View Answer Discuss in Forum 8 . Which function in excel counts the numbers of characters in a cell? Length LGT LT LEN LTE  View Answer Discuss in Forum 9 . What is shortcut to enter current date in cell in excel? ctrl+; Alt+; Shift+& Ctrl+$
Ctrl+*
10 .
When the formula bar is activated in excel, you can see
The Edit Formula button
The Cancel button
The Enter button
All of above
None of these
11 .
Which function will you use to enter current time in a woksheet cell?
=time()
=nowtime()
=now()
=currentTime()
NowcurrentTime()
12 .
Which among following is type of excel data types?
Numbers,Formulas,Labels
Data,Words,Numbers
Words,Number,Labels
Equations,Data,Numbers
None of these
13 .
On Excel screen, Tab scroll buttons are
towards the top left corner
towards the top right corner
towards the bottom right corner
towards the bottom left corner
None of these
14 .
In Excel Worksheet how can you show or hide the gridlines?
Click Gridline tool on Forms toolbar
Go to Tools -> Options -> View tab and mark or remove the check box named Gridline
Both of above
Only A is correct
None of these
15 .
When you press Ctrl + X after selecting some cells in Excel, what will happen then
The cell content of selected cells disappear from cell and stored in clipboard
The selected cells are deleted and cells are shifted up
The selected cells are deleted and the cells are shifted left
The cells selected are marked for cutting
None of these
16 .
To convert a column of data into row, which command will you choose
Edit -> Paste Special -> Transpose
Cut and Paste
Both of above
None of these
None of these
17 .
Each box in a spreadsheet is called a
cell
empty space
record
field
None of these
18 .
You cannot link Excel worksheet data to a Word document ___________.
with the right drag method
with the copy and paste special commands
with the copy and paste buttons on the standard commands
All of these
19 .
In Excel, Charts are created using which option?
Chart wizard
pivot table
pie chard
bar chart
None of these
20 .
A partially completed workbook that contains formulas and formatting, but no data is called a
prototype
template
model
function
None of these
21 .
Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the
cell's column label
cell's column label and worksheet tab name
cell's row label
cell's row and column labels
cell's contents
22 .
Excel is designed to provide visual cues to the relationships between the cells that provide values to the formulas or the cells that depend on the formulas by
Bolding the cell references to match the colour coding of the borders around the referenced worksheet cells.
Highlighting the cell references.
Colour coding the cell references in the formula to match the borders around the referenced worksheet cells
Bolding the cell references
None of these
23 .
This Excel feature includes functions to calculate an Average, Minimum, Maximum and Count.
Format
Number
Autosum
Calculate
Min
24 .
This is a set of values that you want to chart in Excel.
Object
Numbers
Data mart
Formulas
Data series
25 .
The .xls extension is used for ________ files.
windows
access
powerpoint
word
excel
26 .
To copy a cell, you would drag the cell border while simultaneously holding down the Ctrl key when
You have one or more cells to copy.
Only some of the cells are visible in the window
You don't want to refer to absolute references
The distance between cells is short and they are both visible in the window.
None of these
27 .
In Excel, _________ contains one or more worksheets.
Template
Workbook
Active cell
Label
None of these
28 .
Numbers in table columns are usually
right-aligned
left-aligned
justified
centered
None of these
29 .
You will use which feature in excel, if you want to work with one record at a time ?
Auto complete
Auto Filter
Sub Tools
Data Form
None of these
30 .
What term describes explanatory text attached to a cell ?
context
callout
comment
dialog
None of these