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.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  When creating an Excel formula, what does the cell reference with dollar signs like $A$1 do?
A.
B.
C.
D.
2.  You can create maximum one Excel table in a worksheet
A.
B.
3.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
4.  What is the keyboard shortcut for creating a chart from the selected cells?
A.
B.
C.
D.
5.  What is the purpose of the Add-In Manager?    
A.
B.
C.
D.
6.  If a formula contains several functions, Excel starts with the outermost function and then moves inward.
A.
B.
7.  Graphics objects on a chart are used to
A.
B.
C.
D.
8.  To name a cell or range, you use the _______________
A.
B.
C.
D.
9.  Ctrl+B key makes the shortcut for making font in selected cell bold.
A.
B.
10.  A Range in Microsoft Excel refers to...
A.
B.
C.
11.  Columns are identified by a _______________ .  
A.
B.
C.
12.  Whict PivotTable toolbar button updates the data in a PivotTable if the data has changed?
A.
B.
C.
D.
13.  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.
14.  On an Excel spreadsheet the active cell is indicated by
A.
B.
C.
D.
15.  Which of Excel’s ribbon tabs is shown in the figure below?
A.
B.
C.
D.
16.  The function arguments dialog box tells you how to use functions.
A.
B.
17.  Rows are identified by a _______________________
A.
B.
C.
18.  Once you hide a row, it remains hidden as long as the workbook is active.
A.
B.
19.  To format a cell like an already formated one you can use ------------------------------- .
A.
B.
C.
D.
20.   You can select the current Row by pressing
A.
B.
C.
D.
21.  In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?  
A.
B.
C.
D.
22.  Which number formatting style adds the dollar signs and commas to values?
A.
B.
C.
D.
23.  Which is not an advantage of using computerized spreadsheets?
A.
B.
C.
D.
24.  To select several cells or ranges that are not touching each other, you would _____ while selecting
A.
B.
C.
Discuss this Question
25.  When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.  
A.
B.
C.
26.  You can use the drag and drop method to
A.
B.
C.
D.
27.  in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
A.
B.
C.
D.
28.  How would you print formulas?
A.
B.
C.
29.  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.
30.  Which of the following keys/key can be used to check spelling and grammar?
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.