Advanced Excel 2007

32 Questions  I  By Cburke14

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Once you hide a row, it remains hidden as long as the workbook is active.
A.
B.
2.  When a worksheet is printed, the grid lines that surround the cells are printed by default.
A.
B.
3.  A(n) ________ function is conditional.
4.  You can rotate cell contents in Excel so that they appear at any angle or orientation.
A.
B.
5.  After you merge a range into a single cell, you can't realign its content.
A.
B.
6.  In "SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.
A.
B.
C.
D.
7.  Formatting changes only the appearance of data- it does not affect the data itself.
A.
B.
8.  To enter a mixed reference, type $ after either the row or column reference.
A.
B.
9.  All functions have arguments.
A.
B.
10.  If a formula contains several functions, Excel starts with the outermost function and then moves inward.
A.
B.
11.  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.
12.  FUNCTION(argument1,argument2, ...) is ________.
A.
B.
C.
D.
13.  In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?
A.
B.
C.
D.
14.  The ____ button is equivalent to using the sum button.
A.
B.
C.
D.
15.  The numbers, text, or cell references used by the function to return a value are
A.
B.
C.
D.
16.  In "SUM(number1 [,number2 ,number3 ...])", number 2 and number 3 are ________
17.  What uses vertical rectangles to compare values across categories.
18.  Excel has a built in format to display 4 digit year values, so you do not need to create on.
A.
B.
19.  What displays values in different categories; column chart on its side.
20.  What is a range of values that is plotted as a single unit on the chart.
21.  This compares relative values of different categories to the whole; similar to the pie chart except that it can display multiple sets of data.
22.  This compares a collection of values from several different data sets.
23.  Pie charts are most effective with ___________ or fewer slices.
24.  This is a collection of one or more data series.
25.  This compares three sets of values in a 3D chart.
26.  This compares value from different categories; often used to show trends and changes over time.
27.  A "mixed reference" locks one part of the cell reference while the other part can change.
A.
B.
28.  One challenge of nesting functions is to make sure that you include all of the parentheses.
A.
B.
29.  In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
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.
31.  Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
A.
B.
32.  In pie charts with legends, it's best to make the slice colors as similar as possible.
A.
B.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz