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.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  What term describes explanatory text attached to a cell
A.
B.
C.
D.
2.  =FUNCTION(argument1,argument2, ...) Is ________.
A.
B.
C.
D.
3.  After you merge a range into a single cell, you can't realign its content.
A.
B.
4.  What is a workbook made up of?
A.
B.
C.
5.  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.
6.  If a formula contains several functions, Excel starts with the outermost function and then moves inward.
A.
B.
7.  The number of rows in an Excel 2007 worksheet is:
A.
B.
C.
D.
8.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
9.  When using Excel 2007 which sign is used to create a formula or function in a cell?
A.
B.
C.
D.
10.  What is the function of the autofit ?
A.
B.
C.
11.  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.
12.  Graphics objects on a chart are used to
A.
B.
C.
D.
13.  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.
14.  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.
15.  The function arguments dialog box tells you how to use functions.
A.
B.
16.  You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?
A.
B.
17.  How would you print formulas?
A.
B.
C.
18.  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.
19.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
20.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
21.  A function inside another function is called a _____________ function.
A.
B.
C.
D.
22.  Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
B.
C.
D.
23.  The "Go To" dialogue appears when you press the _____________ key from keyboard.  
A.
B.
C.
24.  in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
A.
B.
C.
D.
25.  A worksheet is..
A.
B.
C.
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.  An Excel spreadsheet is also called a _______________________ .
A.
B.
C.
28.  The divide symbol is
A.
B.
C.
D.
29.  Which mathematical operation is performed by the ^ key in an Excel formula?
A.
B.
C.
D.
30.  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.
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.