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.  Graphics objects on a chart are used to
A.
B.
C.
D.
2.  After you merge a range into a single cell, you can't realign its content.
A.
B.
3.  What is the purpose of the Add-In Manager?    
A.
B.
C.
D.
4.  Reference to the above image of Command Group "Alignment" which of the following tabs consist it:     
A.
B.
C.
5.  The function arguments dialog box tells you how to use functions.
A.
B.
6.  What function offers you the possibility to view different results depending on the entered condition?
A.
B.
C.
7.  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.
8.  What is the short key to enter the current date in a cell?
A.
B.
C.
D.
9.  A worksheet is..
A.
B.
C.
10.  Whict PivotTable toolbar button updates the data in a PivotTable if the data has changed?
A.
B.
C.
D.
11.  What is the shortcut to add a hyperlink to your worksheet?
A.
B.
C.
D.
12.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
13.  When using Excel 2007 which sign is used to create a formula or function in a cell?
A.
B.
C.
D.
14.  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.
15.  What does SUMIFS function do?
A.
B.
C.
D.
16.  To open the Format Cells dialog box, press
A.
B.
C.
D.
17.  You can print
A.
B.
C.
D.
18.  When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
A.
B.
C.
D.
19.  Ctrl+B key makes the shortcut for making font in selected cell bold.
A.
B.
20.  You can use a spreadsheets package like the Microsoft Excel To _________________
A.
B.
C.
D.
21.  Which function converts miles to kilometers, kilograms to pounds, and so on?
A.
B.
C.
D.
22.  Which of the following methods allows you to insert an Adobe Photoshop Image into your Excel spreadsheet?
A.
B.
C.
D.
23.  Which of the following would you use in an Excel formula to reference the cell located at column G row 17?
A.
B.
C.
D.
24.  You can modify an exisiting chart?
A.
B.
25.  Once you hide a row, it remains hidden as long as the workbook is active.
A.
B.
26.  Using the autosum button will place in the selected cell _____.
A.
B.
C.
D.
27.  What chart object is a horizontal/vertical line extending across the plot area aiding reading values
A.
B.
C.
D.
28.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
29.  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.
30.  An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
A.
B.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz