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.  Which is not an advantage of using computerized spreadsheets?
A.
B.
C.
D.
2.  Columns are identified by a _______________ .  
A.
B.
C.
3.  The name of the active cell appeares in the -----------------------.    
A.
B.
C.
4.  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.
5.  You can modify an exisiting chart?
A.
B.
6.  What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2
A.
B.
C.
D.
7.  What is the keyboard shortcut for creating a chart from the selected cells?
A.
B.
C.
D.
8.  Which number formatting style adds the dollar signs and commas to values?
A.
B.
C.
D.
9.  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.
10.  Which of the following functions is correctly written?
A.
B.
C.
D.
11.  Microsoft Excel 2007 is a ___________________?
A.
B.
C.
D.
E.
12.  The divide symbol is
A.
B.
C.
D.
13.  Using the autosum button will place in the selected cell _____.
A.
B.
C.
D.
14.  How would you print formulas?
A.
B.
C.
15.  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.
16.  Pie charts are most effective with ___________ or fewer slices.
A.
B.
C.
17.  What chart object is a horizontal/vertical line extending across the plot area aiding reading values
A.
B.
C.
D.
18.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
19.  What does the LEN() function do?
A.
B.
C.
D.
20.  A Function is?
A.
B.
C.
21. 
What is the correct forumla to calculate an average between cells B3 and B6?
A.
B.
C.
D.
E.
22.  _____________ is the horizontal part of the spreadsheet.
A.
B.
C.
23.  You can display all formulas in an active worksheet by pressing the _____ keys
A.
B.
C.
D.
24.  What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?    
A.
B.
C.
D.
25.  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.
26.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
27.  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.
28.  What is the function of the autofit ?
A.
B.
C.
29.  Once you hide a row, it remains hidden as long as the workbook is active.
A.
B.
30.  You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
A.
B.
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.