Microsoft Excel Proficiency Test

30 Questions  I  By Octara
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 number formatting style adds the dollar signs and commas to values?
A.
B.
C.
D.
2.  Rows are identified by a _______________________
A.
B.
C.
3. 
Reference to the above image of Command Group "Alignment" which of the following tabs consist it:     
A.
B.
C.
4.  A Logical test in Excel can contain =, >=, <=, >,<, <>, $
A.
B.
C.
D.
5.  Columns are identified by a _______________ .  
A.
B.
C.
6.  You can create maximum one Excel table in a worksheet
A.
B.
7.  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.
8.  _____________ is the horizontal part of the spreadsheet.
A.
B.
C.
9.  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.
10.  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.
11.  In an IF Function the required arguments are ____________
A.
B.
C.
D.
12.  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.
13.  The Insert Function dialog box tells you how to use functions.
A.
B.
14.  A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?
A.
B.
C.
15.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
16. 
What is the correct forumla to calculate an average between cells B3 and B6?
A.
B.
C.
D.
E.
17.  To name a cell or range, you use the _______________
A.
B.
C.
D.
18.  Which function does not exist in Excel's function library?
A.
B.
C.
D.
19.  What is the purpose of range lookup in VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)?
A.
B.
C.
D.
20.  How would you print formulas?
A.
B.
C.
21.  All functions have arguments.  There are no functions which work without providing them arguments.
A.
B.
22.  When using Excel 2007 which sign is used to create a formula or function in a cell?
A.
B.
C.
D.
23.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
24.  Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A.
B.
C.
D.
25.  The view that puts a blue line around each page that would be printed is the _____.  
A.
B.
C.
D.
26.  Pie charts are most effective with ___________ or fewer slices.
A.
B.
C.
27.  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.
28.  What function offers you the possibility to view different results depending on the entered condition?
A.
B.
C.
29.  =FUNCTION(argument1,argument2, ...) Is ________.
A.
B.
C.
D.
30.  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.
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.