Microsoft Excel Proficiency Test

30 Questions  I  By Octara
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.  Which of Excel’s ribbon tabs is shown in the figure below?
A.
B.
C.
D.
2.  Which function converts miles to kilometers, kilograms to pounds, and so on?
A.
B.
C.
D.
3.  You can press ___________ to move between open Workbook
A.
B.
C.
D.
4.  Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
A.
B.
C.
5.  In an IF Function the required arguments are ____________
A.
B.
C.
D.
6.  Which of the following functions is correctly written?
A.
B.
C.
D.
7.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
8.  To select several cells or ranges that are not touching each other, you would _____ while selecting
A.
B.
C.
9.  The name of the active cell appeares in the -----------------------.    
A.
B.
C.
10.  Reference to the above image of Command Group "Alignment" which of the following tabs consist it:     
A.
B.
C.
11.  Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
B.
C.
D.
12.  What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result?
A.
B.
C.
D.
13.  _____________ is the horizontal part of the spreadsheet.
A.
B.
C.
14.  What term describes explanatory text attached to a cell
A.
B.
C.
D.
15.  The function arguments dialog box tells you how to use functions.
A.
B.
16.  Which function does not exist in Excel's function library?
A.
B.
C.
D.
17.  Once you hide a row, it remains hidden as long as the workbook is active.
A.
B.
18.  =FUNCTION(argument1,argument2, ...) Is ________.
A.
B.
C.
D.
19.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
20.  In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?  
A.
B.
C.
D.
21.  How would you print formulas?
A.
B.
C.
22.  After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.
A.
B.
C.
D.
23.  The divide symbol is
A.
B.
C.
D.
24.  Pie charts are most effective with ___________ or fewer slices.
A.
B.
C.
25.  An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
A.
B.
26.  Which number formatting style adds the dollar signs and commas to values?
A.
B.
C.
D.
27.  A Function is?
A.
B.
C.
28.  Which Excel 2007 feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet?
A.
B.
C.
D.
29.  The "Go To" dialogue appears when you press the _____________ key from keyboard.  
A.
B.
C.
30.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz