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

Internet Ms Power Point And Ms Access


Sponsored Links
500
Write your Comment or Discuss..
    Log in | Sign up

    Copyright 2019-2020 | Privacy Policy | Terms and Conditions | Contact us | Advertise