Microsoft Excel Exam

20 Questions  I  By Lorie on March 26, 2009
Take an exam to see how well you know some Excel basics. Content in this quiz was excerpted from Training on Microsoft Office Online.

  

Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  A fast way to add up this column of numbers is to click in the cell below the numbers and then:
A.
B.
C.
2.  Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?  
A.
B.
C.
3.  How do you change column width to fit the contents?
A.
B.
C.
4.  There are three worksheets with every new workbook. You can change that automatic number if you want to.  
A.
B.
5.  ###### means: 
A.
B.
C.
6.  To add a new row, click a cell in the row immediately above where you want the new row.  
A.
B.
7.  Which key do you press to group two or more nonadjacent worksheets? 
A.
B.
C.
2 comments
8.  To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. 
A.
B.
9.  A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
A.
B.
C.
2 comments
10.  Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
A.
B.
C.
1 comment
11.  Is it possible to insert an image from a file into an Excel spreadsheet ?
A.
B.
12.  Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
A.
B.
13.  On an Excel sheet the active cell is indicated by ____.
A.
B.
C.
D.
14.  A Formula and a function are the same thing.
A.
B.
15.  In order to multiply items in Excel you would use:
A.
B.
C.
D.
16.  The formula = ((A2+B5)*5% is valid
A.
B.
17.  If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
4 comments
18.  If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
19.  Get the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
1 comment
20.  Get the remarks in cell A1 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
1 comment
Back to top
Quiz Comments (5)
IS THIS IT ?BUT IN THIS THE QUESTION IS BASED BY MATHEMATICS. but not bad
IS THIS IT ?BUT IN THIS THE QUESTION IS BASED BY MATHEMATICS.
PLEASE DON'T READ THIS.YOU WILL BE KISSED ON THE NEAREST FRIDAY BY THE ONE YOU LOVE.NOW YOU'VE STARTED READING THIS SO DON'T STOP THIS IS REALLY FREAKY!!!!!!!! 1)say your name 10 times 2)say your mom's name 5 times 3)say your crushes name 3 times 4)paste this on 4 other quizzes.if you do this your crush will kiss you on the nearest friday.if you don't do this after reading this you will get bad luck send this to 4 other quizzes in 143 minutez when your done press F6 and the name of your crush will appear on the screen in big letters
Lorie. I know this test is old, but I have to point out the same as the other guest that posted. However, the problems are with question 7 and 9. There is an additional issue with question 13. The answer is correct if the active cell has no border formatting. But if the active cell has a border on all four sides, then the indication will be what appears to be a double line border.
Hi Lorie, I took the test, it was quite interesting. I would like to hihglight the fact that question no. 7 and/or its correct answer is INCORRECT. Please review it and correct it. Same applies to question number 14. Thank you in advance.
to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz