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.  Which function converts miles to kilometers, kilograms to pounds, and so on?
A.
B.
C.
D.
2.  What is the purpose of the Add-In Manager?    
A.
B.
C.
D.
3.  One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file?
A.
B.
C.
D.
4.  What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?    
A.
B.
C.
D.
5.  Which of the following would you use in an Excel formula to reference the cell located at column G row 17?
A.
B.
C.
D.
6.  =FUNCTION(argument1,argument2, ...) Is ________.
A.
B.
C.
D.
7.  To select several cells or ranges that are not touching each other, you would _____ while selecting
A.
B.
C.
8.  _____________ is the horizontal part of the spreadsheet.
A.
B.
C.
9.  Which function does not exist in Excel's function library?
A.
B.
C.
D.
10.  A worksheet is..
A.
B.
C.
11.  Rows are identified by a _______________________
A.
B.
C.
12.  What chart object is a horizontal/vertical line extending across the plot area aiding reading values
A.
B.
C.
D.
13.  Pressing ENTER moves the selection one cell to the right by default.
A.
B.
14.  When using Excel 2007 which sign is used to create a formula or function in a cell?
A.
B.
C.
D.
15.  A Range in Microsoft Excel refers to...
A.
B.
C.
16.  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.
17.  What does the LEN() function do?
A.
B.
C.
D.
18.  Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
B.
C.
D.
19.  Pie charts are most effective with ___________ or fewer slices.
A.
B.
C.
20.  Using the autosum button will place in the selected cell _____.
A.
B.
C.
D.
21.  Excel has a builtin format to display 4 digit year values, so you do not need to create one.
A.
B.
22.  The "Go To" dialogue appears when you press the _____________ key from keyboard.  
A.
B.
C.
23.  The function arguments dialog box tells you how to use functions.
A.
B.
24.  Microsoft Excel 2007 is a ___________________?
A.
B.
C.
D.
E.
25.  When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
A.
B.
C.
D.
26.  An Excel spreadsheet is also called a _______________________ .
A.
B.
C.
27.  Which of Excel’s ribbon tabs is shown in the figure below?
A.
B.
C.
D.
28.  You can use the drag and drop method to
A.
B.
C.
D.
29.  When a worksheet is printed, the grid lines that surround the cells are printable by default.
A.
B.
30.   You can select the current Row by pressing
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz