We have sent an email with your new password.

Close this window

Microsoft Excel Proficiency Test

30 Questions  I  By Octara
Microsoft Excel Proficiency Test
This quiz is created to identify the proficiency of users about Microsoft Excel.

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  When you clear a filter, all filters in the worksheet are cleared, if worksheet contains more than one filters
A.
B.
2.  A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?
A.
B.
C.
3.  On an Excel spreadsheet the active cell is indicated by
A.
B.
C.
D.
4.  What is a Workbook?
A.
B.
C.
5.  What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?    
A.
B.
C.
D.
6.  Which of Excel’s ribbon tabs is shown in the figure below?
A.
B.
C.
D.
7.  Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?
A.
B.
C.
D.
8.  Microsoft Excel 2007 is a ___________________?
A.
B.
C.
D.
E.
9.  When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.  
A.
B.
C.
10.  Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?  
A.
B.
C.
11.  Once data is entered into a cell, can it be edited after saving the file?
A.
B.
C.
12.  You cannot insert comments on each cell.
A.
B.
13.  A Logical test in Excel can contain =, >=, <=, >,<, <>, $
A.
B.
C.
D.
14.  Pressing ENTER moves the selection one cell to the right by default.
A.
B.
15.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
16.  After you merge a range into a single cell, you can't realign its content.
A.
B.
17.  An Excel spreadsheet is also called a _______________________ .
A.
B.
C.
18.  What is the function of the autofit ?
A.
B.
C.
19.  What is the purpose of the Add-In Manager?    
A.
B.
C.
D.
20.  Which function converts miles to kilometers, kilograms to pounds, and so on?
A.
B.
C.
D.
21.  To add two cells (A1 and A2) together you use the following formula
A.
B.
C.
D.
22.  All functions have arguments.  There are no functions which work without providing them arguments.
A.
B.
23.  What is the short key to enter the current date in a cell?
A.
B.
C.
D.
24.  What key should be used to edit the content of a cell?
A.
B.
C.
25.  A function inside another function is called a _____________ function.
A.
B.
C.
D.
26.  Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.
A.
B.
27.  As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
A.
B.
28.  The  ___________ allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.
A.
B.
29.  Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook?
A.
B.
C.
D.
30.  Which mathematical operation is performed by the ^ key in an Excel formula?
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz