We have sent an email with your new password.

Close this window

Microsoft Excel Proficiency Test

30 Questions  I  By Octara
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.  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.
2.  What is the purpose of the Add-In Manager?    
A.
B.
C.
D.
3.  All functions have arguments.  There are no functions which work without providing them arguments.
A.
B.
4.  Pressing ENTER moves the selection one cell to the right by default.
A.
B.
5.  How would you print formulas?
A.
B.
C.
6.  The view that puts a blue line around each page that would be printed is the _____.  
A.
B.
C.
D.
7.  What is the correct forumla to calculate an average between cells B3 and B6?
A.
B.
C.
D.
E.
8.  What term describes explanatory text attached to a cell
A.
B.
C.
D.
9.  When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
A.
B.
C.
D.
10.  You can display all formulas in an active worksheet by pressing the _____ keys
A.
B.
C.
D.
11.  To add two cells (A1 and A2) together you use the following formula
A.
B.
C.
D.
12.  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.
13.  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.
14.  To format a cell like an already formated one you can use ------------------------------- .
A.
B.
C.
D.
15.  Once you hide a row, it remains hidden as long as the workbook is active.
A.
B.
16.  Rows are identified by a _______________________
A.
B.
C.
17.  What is the short key to enter the current date in a cell?
A.
B.
C.
D.
18.  After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.
A.
B.
C.
D.
19.  What does the LEN() function do?
A.
B.
C.
D.
20.  You can use a spreadsheets package like the Microsoft Excel To _________________
A.
B.
C.
D.
21.  In an IF Function the required arguments are ____________
A.
B.
C.
D.
22.  A Function is?
A.
B.
C.
23.  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.
24.  After you merge a range into a single cell, you can't realign its content.
A.
B.
25.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
26.  You can print
A.
B.
C.
D.
27.  What function would you use to display today's date so that tomorrow it will updates automatically
A.
B.
C.
D.
28.  The _________________ displays the name of the sheets in the workbook.
A.
B.
C.
29.  Once data is entered into a cell, can it be edited after saving the file?
A.
B.
C.
30.  The name of the active cell appeares in the -----------------------.    
A.
B.
C.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz