English Vocabulary from
sponsored links
Read Set 1 Here
a. Backspace
key
b. Default
font
c. Format
painter
d.
Formatting toolbar
The accounting style shows negative numbers in_____________
a. Bold
b. Brackets
c.
Parentheses
d. Quotes
e. None of
the Above
You can use drag and drop to embed excel worksheet
data in a word document
a. By
dragging a range of excel data to the word button on the taskbar while pressing
the Ctrl key
b. By
dragging a range of excel data to the Word
button on the taskbar while pressing Shift key
c. By
displaying both applications side-by-side and dragging a selected range of
Excel data into the word application window while pressing the Ctrl key
d. a and c
e. None of
the Above
A _____________
is a group of cells that form a rectangle on the screen.
a.
Calculation
b. Formula
c. Range
d. Range
address
e. None of
the Above
What term describes explanatory text attached to a cell
a. Callout
b. Comment
c. Dialog
d. Extension
e. None of
the Above
The drag and drop method of copying or moving
a. Can be
used between worksheets but not workbooks
b. Can be used between workbooks but not
worksheets
c. Can be
used between workbooks but not worksheets
d. None
e. None of
the Above
3-D reference in a formula
a. Can not
be modified
b. Only
appears on summary worksheets
c. Limits
the formatting options
d. Spans
worksheets
e. None of
the Above
What excel feature can you use if you want to work
with one record at a time?
a. Auto
Complete
b. Auto
Filter
c. Data Form
d. Sub
Totals
e. None of
the Above
Excel uses the_____________ Function when creating a
data table
a. Average
b. Count
c. Sum
d. Table
e. None of
the Above
The auto calculate feature
a. Can only
add values in a range of cells
b. Provides
a quick way to view the results of an arithmetic operation on a range of cells
c.
Automatically creates formulas and adds them to a worksheet
d. a and c
e. None of
the Above
The chart
wizard
a. Can place
a chart on a new chart sheet or on any sheet in the workbook
b. Can only
place a chart on new chart sheet
c. Can only
place a chart on a new blank worksheet
d. Can only
be used to create embedded charts
e. None of
the Above
The default style for new data keyed in a new
workbook is
a. Comma
b. Currency
c. Normal
d. Percent
e. None of
the Above
The LEN function does what?
a. Compares
the content in two cells
b. Counts
the numbers of characters in a cell
c. Deletes
extra space in text
d. All the above
e. None of
the Above
Which function converts miles to kilometers,
kilograms to pounds, and so on?
a. Convert
b. Product
c. Change
d. All of
above
e. None of
the Above
You can use the drag and drop method to
a. Copy cell
contents
b. Delete
cells contents
c. Add cell
contents
d. All of
above
e. None of
the Above
To balance your checkbook in Excel, your best method
is
a. Copy your
check amounts into Excel so that you’ll have a neat printout to work on
b. Use Excel
to check your arithmetic
c. Download
the Checkbook register templates from Templates on Microsoft Office Online
d. All of
above
e. None of the Above
Which formula can add the all the numeric values in
a range of cells, ignoring those which are not numeric, and place the resulting
a differene cell
a. Count
b. Average
c. Sum
d. None of
above
e. All
the Above
To name a constant, you use the _____________dialog
box
a. Create
names
b. Define
name
c. Paste
name
d. Format
cells
e. None of
the Above
To cancel the marquee, press
a. Ctrl +
End
b. End
c. Esc
d. Shift +
Esc
e. None of
the Above
To access the Go To Special feature, you can press
a. Ctrl + G
b. Ctrl + O
c. Ctrl +
Shift + G
d. Ctrl + 1
e. None of
the Above
Which do you press to enter the current date in a
cell?
a. Ctrl +
Shift + :
b. Ctrl + ;
c. Ctrl +
F10
d. All of
above
e. None of
the Above
It is acceptable to let long text flow into adjacent
cells on a worksheet when
a. Data will
be entered in the adjacent cells
b. No data
will be ente4red in the adjacent cells
c. There is
no suitable abbreviation for the text
d. There is
not time to format the text
e. None of
the Above
Liked this post? Read more on Computer Knowledge of SBI PO Exam Here
thnku..plz upload ms word set also..
ReplyDeleteTHANQ FOR UR EFFOTS MAM PLZ UPLOAD MS WORD ALSO
ReplyDeletehave some more updates.............
ReplyDelete