We have sent an email with your new password.


Excel 2007 (pre Test)

15 Questions  I  By PradipMCT
  • Share This on Twitter
  • +
Excel 2007 (Pre Test)

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Cell formatted as ";;;" will result in
A.
B.
C.
D.
2.  The formula present in cell D7 of book1, sheet2, is =sum(A2:A5). The same formula is copied to another workbook, book2 and pasted in sheet2, cell C7. Select the most appropriate outcome?
A.
B.
C.
D.
3.  Which of the following function syntax is correct?
A.
B.
C.
D.
4.  Which of the following functions are correct syntactically?
A.
B.
C.
D.
5.  What is the keyboard short cut for ‘Save-As’?
A.
B.
C.
D.
6.  You open a worksheet, you received in an email with cells D6:D9 containing the formula {=a6:A9*C6:C9}. Which feature of excel can help us design formulae like this
A.
B.
C.
D.
7.  Is addition of rows and columns is possible beyond defined limit
A.
B.
C.
8.  Excel allows users to be able to protect each cell with a different password
A.
B.
C.
D.
9.  Control + Enter shortcut is used ....
A.
B.
C.
D.
10.  The number 32002 formatted as a date would be:
A.
B.
C.
D.
11.  Which amongst the following is ideal methods is ideal to work with a workbook which has the huge data and takes lot of time to do the calculations
A.
B.
C.
D.
12.  When you first create a comment, what appears in the comment text box?
A.
B.
C.
D.
13.  The Name box
A.
B.
C.
D.
14.  Select the most appropriate amongst the following
A.
B.
C.
D.
15.  A column chart is made out of data present in A1:B5. For a new data added in A6 and B6, the chart has to be redesigned to include the new record
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz