sponsored links
Read complete study Material of Computer Knowledge Here. All The Best :)
To open an existing workbook, you can click the Open button on the …… toolbar.
a. Drawing
b. Formatting
c. Forms
d. Standard
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
a. F3
b. F5
c. F7
e. None of the above
“Qtr 1, Qtr 2, Qtr 3” is an example of a
a. Formula
b. Function
c. Series
d. Syntax
e. None of the above
You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
a. Edit
b. Insert
c. Format
d. Tools
e. None of the above
Which of the following is not a worksheet design criterion?
a. Efficiency
b. Auditability
c. Description
d. Clarity
e. None of the above
To copy cell contents using drag and drop, press the
a. End key
b. Shift key
c. Esc key
d. None of above
e. None of the above
If you press …., the cell accepts your typing as its contents.
a. Enter
b. Ctrl + Enter
c. TAB
d. Insert
e. None of the above
The autofill feature
a. Automatically repeat values that already are found in the column
b. Use the fill handle to fill data
c. Fill data into adjacent cells by using the Fill command
b. Use the fill handle to fill data
c. Fill data into adjacent cells by using the Fill command
d. All the above
e. None of the above
You can create only a horizontal page break by first selecting
a. A row below the row where you want the page break to occure
b. A cell in row 1
c. A cell in column A
d. a and c
e. None of the above
You can create hyperlinks from the Excel workbook to
a. A webpage on company internet
b. A web page on the internet
c. Other Office 97 application documents
d. All
e. None of the above
If you press ……, the cell accepts your typing as its contents.
a. Enter
b. Ctrl+Enter
c. Tab
d. Insert
e. None of the above
Which of the following special function keys allow the content in cell
a. esc
b. shift
c. return
d. Tab
e. None of the above
The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……
a. B1-G10
b. B1.G10
c. B1;G10
d. B1:G10
e. None of the above
Which of the following is not an option in the spelling dialog box?
a. Edit
b. Ignore
c. Ignore all
d. Change
e. None of the above
You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
a. Edit
b. View
c. Format
d. Tools
e. None of the above
To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
a. Edit
b. Format
c. Tools
d. Data
e. None of the above
The advantage of using a spreadsheet is:
a. calculations can be done automatically.
b. changing data automatically updates calculations
c. more flexibility
d. all of the above
e. None of the above
The intersection of a row and column is called :
a. data
b. a field.
c. a cell
d. an equation.
e. None of the above
There are three types of data found in a spreadsheet.
a. data, words, numbers
b. equations, data, numbers
c. words, numbers, labels
d. numbers formulas, labels
e. None of the above
To select a column the easiest method is to……
a. Double click any cell in the column
b. Drag from the top cell in the column to the last cell in the column
c. click the column heading
d. click the column label
awesome
ReplyDeleteThanks mam. Waiting for more sets
ReplyDeletethanks...
ReplyDeleteThnks mam....
ReplyDeleteThanks for your support...
ReplyDeletevery usefull mam...... thanks.........
ReplyDeletethanks a lot...............
ReplyDeletethanx a lot........
ReplyDeletecan u please provide MS Word bits..my exam is on 22 nd..
ReplyDeleteWe will try to post by tomorrow's evening Anu...
DeleteAll The Best
mam plz upload MS Word bits my exam is on 22nd mrng session
DeleteSure Reddy.. YOu can get complete sets by tomorrow's morning
DeleteAll The Best
can u plz post Ms word bits..my exam is on 22 nd..you are doing a gr8 job ALL THE BEST
ReplyDeleteReduction in the value of a currency, usually expressed in terms of another currency, is called_______________.Pls Ans
ReplyDeleteThe price of one country's currency expressed in another country's currency is called Exchange Rate Ricky kumar. Not sure about the reduction, may be "floating exchange rate".
DeleteReduction in the value of a currency, usually expressed in terms of another currency, is called_______________.Pls Ans this and also I have exam on 22nd.So pls advice me what gk and banking awareness I have go through based on 15 and 16th exams.
ReplyDeleteJust go through the banking terminology and functions of banks. For GA concentrate more on Ministers (after re shuffle), important events occured in last 6 months. Thats enough
DeleteAll THe Best
hai mam this is santhi its my first exam on 23 dec so pls tell me how many needed for safe zone i mean to qualify in ibps clerk exam
ReplyDeleteGetting only pass marks is of no use Prasanthi... Try to give your best. Try to get 20 marks at least in every section
DeleteAll The Best
hai mam pls provide some more material in ms office basics
ReplyDeleteSure Prasanthi... We're presently working on them... YOu can get complete set by this evening.
Deletethank u mam....i will try my level best
ReplyDeletehai mam is there is any chances repetetion questions from exam on 15, 16 and 22 to 23...my exam is on 23
ReplyDeleteNo friend. IBPS will be more cautious this time. There wont be repetitive questions...
Deletewhat were bank locker timings ?
ReplyDeleteYour visit and access your locker on all working days during banking hours Atchut.
Deleteguddd
ReplyDeletegud
ReplyDelete