We have sent an email with your new password.


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.  To sort data in an Excel worksheet you can use the ______.
A.
B.
C.
D.
2.  The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.
A.
B.
3.  Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook?
A.
B.
C.
D.
4.  Excel has a builtin format to display 4 digit year values, so you do not need to create one.
A.
B.
5.  To format a cell like an already formated one you can use ------------------------------- .
A.
B.
C.
D.
6.  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.
7.  In an IF Function the required arguments are ____________
A.
B.
C.
D.
8.  The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:  
A.
B.
C.
D.
9.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
10.  On an Excel spreadsheet the active cell is indicated by
A.
B.
C.
D.
11.  After you merge a range into a single cell, you can't realign its content.
A.
B.
12.  The name of the active cell appeares in the -----------------------.    
A.
B.
C.
13.  When using Excel 2007 which sign is used to create a formula or function in a cell?
A.
B.
C.
D.
14.  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.
15.  You can use a spreadsheets package like the Microsoft Excel To _________________
A.
B.
C.
D.
16.  You cannot insert comments on each cell.
A.
B.
17.  The function arguments dialog box tells you how to use functions.
A.
B.
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.  An Excel spreadsheet is also called a _______________________ .
A.
B.
C.
20.  What is the function of the autofit ?
A.
B.
C.
21.  in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
A.
B.
C.
D.
22.  What is the keyboard shortcut for creating a chart from the selected cells?
A.
B.
C.
D.
23.  Which function does not exist in Excel's function library?
A.
B.
C.
D.
24.  To add two cells (A1 and A2) together you use the following formula
A.
B.
C.
D.
25.  All functions have arguments.  There are no functions which work without providing them arguments.
A.
B.
26.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
27.  When creating an Excel workbook, you should avoid using ______ text and background together, since this is the most common form of color blindness.  
A.
B.
C.
D.
28.  Microsoft Excel 2007 is a ___________________?
A.
B.
C.
D.
E.
29.  You use ______ filters to find all objects with a value greater than X or acquired after a certain date
A.
B.
C.
D.
30.  The number of rows in an Excel 2007 worksheet is:
A.
B.
C.
D.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz