Microsoft Excel Proficiency Test

30 Questions  I  By Octara
Please take the quiz to rate it.

Microsoft Excel Proficiency Test
This quiz is created to identify the proficiency of users about Microsoft Excel.

  
Changes are done, please start the quiz.


Questions and Answers Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  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.
2.  Which function converts miles to kilometers, kilograms to pounds, and so on?
A.
B.
C.
D.
3.  You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
A.
B.
4.  =FUNCTION(argument1,argument2, ...) Is ________.
A.
B.
C.
D.
5.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
6.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
7.  The name of the active cell appeares in the -----------------------.    
A.
B.
C.
8.  A Logical test in Excel can contain =, >=, <=, >,<, <>, $
A.
B.
C.
D.
9.  In an IF Function the required arguments are ____________
A.
B.
C.
D.
10.  The _________________ displays the name of the sheets in the workbook.
A.
B.
C.
11.   You can select the current Row by pressing
A.
B.
C.
D.
12.  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.
13.  If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:  
A.
B.
C.
D.
14.  What is the function of the autofit ?
A.
B.
C.
15.  The function arguments dialog box tells you how to use functions.
A.
B.
16.  After you merge a range into a single cell, you can't realign its content.
A.
B.
17.  You can modify an exisiting chart?
A.
B.
18.  Cell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?
A.
B.
C.
D.
19.  Which of the following functions is correctly written?
A.
B.
C.
D.
20.  Rows are identified by a _______________________
A.
B.
C.
21.  The number of rows in an Excel 2007 worksheet is:
A.
B.
C.
D.
22.  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.
23.  What is the shortcut to add a hyperlink to your worksheet?
A.
B.
C.
D.
24.  in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
A.
B.
C.
D.
25.  Formatting data only change the appearance of data, it does not affect the data itself.
A.
B.
26.  Which mathematical operation is performed by the ^ key in an Excel formula?
A.
B.
C.
D.
27.  The view that puts a blue line around each page that would be printed is the _____.  
A.
B.
C.
D.
28. 
Reference to the above image of Command Group "Alignment" which of the following tabs consist it:     
A.
B.
C.
29.  To name a cell or range, you use the _______________
A.
B.
C.
D.
30.  Excel has a builtin format to display 4 digit year values, so you do not need to create one.
A.
B.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.