We have sent an email with your new password.


Microsoft Excel Proficiency Test

30 Questions  I  By Octara
  • Share This on Twitter
  • +
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.  What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result?
A.
B.
C.
D.
2.  What is the purpose of range lookup in VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)?
A.
B.
C.
D.
3.  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.
4.  If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:
A.
B.
C.
D.
5.  If a formula contains several functions, Excel starts with the outermost function and then moves inward.
A.
B.
6.  A Range in Microsoft Excel refers to...
A.
B.
C.
7.  What is the purpose of the Add-In Manager?    
A.
B.
C.
D.
8.  To add two cells (A1 and A2) together you use the following formula
A.
B.
C.
D.
9.  Which of the following functions is correctly written?
A.
B.
C.
D.
10.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
11.  In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?  
A.
B.
C.
D.
12.  In Excel, charts do not remain linked or connected to the data sources if they appear in different worksheets.
A.
B.
13.  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.
14.  You can modify an exisiting chart?
A.
B.
15.  What chart object is a horizontal/vertical line extending across the plot area aiding reading values
A.
B.
C.
D.
16.  What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2
A.
B.
C.
D.
17.  Which of Excel’s ribbon tabs is shown in the figure below?
A.
B.
C.
D.
18.  When using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells.
A.
B.
19.  The _________________ displays the name of the sheets in the workbook.
A.
B.
C.
20.  The divide symbol is
A.
B.
C.
D.
21.  The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:  
A.
B.
C.
D.
22.  The "Go To" dialogue appears when you press the _____________ key from keyboard.  
A.
B.
C.
23.  What function offers you the possibility to view different results depending on the entered condition?
A.
B.
C.
24.  If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style.
A.
B.
25.  Which function converts miles to kilometers, kilograms to pounds, and so on?
A.
B.
C.
D.
26.  You use ______ filters to find all objects with a value greater than X or acquired after a certain date
A.
B.
C.
D.
27.  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.
28.  What is the keyboard shortcut for creating a chart from the selected cells?
A.
B.
C.
D.
29.  =Sheet1!D9+Sheet1!E9
A.
B.
C.
D.
30.  The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.  
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz