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.  =FUNCTION(argument1,argument2, ...) Is ________.
A.
B.
C.
D.
2.  What is the keyboard shortcut for creating a chart from the selected cells?
A.
B.
C.
D.
3.  In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?  
A.
B.
C.
D.
4.  What is a Workbook?
A.
B.
C.
5.  in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
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.  Which of the following keys/key can be used to check spelling and grammar?
A.
B.
C.
D.
8.  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.
9.  All functions have arguments.  There are no functions which work without providing them arguments.
A.
B.
10.  Which of Excel’s ribbon tabs is shown in the figure below?
A.
B.
C.
D.
11.  What term describes explanatory text attached to a cell
A.
B.
C.
D.
12.  You can display all formulas in an active worksheet by pressing the _____ keys
A.
B.
C.
D.
13.  Which of the following is the correct syntax for the COUNTIF function?
A.
B.
C.
D.
E.
14.  Which is not an advantage of using computerized spreadsheets?
A.
B.
C.
D.
15.  You can create maximum one Excel table in a worksheet
A.
B.
16.  What does SUMIFS function do?
A.
B.
C.
D.
17.  As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
A.
B.
18.  To format a cell like an already formated one you can use ------------------------------- .
A.
B.
C.
D.
19.  To name a cell or range, you use the _______________
A.
B.
C.
D.
20.  A Function is?
A.
B.
C.
21.  You can modify an exisiting chart?
A.
B.
22.  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.
23.  Which of the Excel 2007 ribbon tab allow you to check spelling, add a comment, or protect your workbook?
A.
B.
C.
D.
24.  Two common wildcard characters that Excel recognizes are
A.
B.
C.
D.
25.  You can print
A.
B.
C.
D.
26.  Whict PivotTable toolbar button updates the data in a PivotTable if the data has changed?
A.
B.
C.
D.
27.  What is a Chart?  
A.
B.
C.
28.  What function would you use to display today's date so that tomorrow it will updates automatically
A.
B.
C.
D.
1 comment
29.  What function offers you the possibility to view different results depending on the entered condition?
A.
B.
C.
30.  The "Go To" dialogue appears when you press the _____________ key from keyboard.  
A.
B.
C.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz