Excel Quizzes

Which function would you use to find the oldest date in a range? a. MIN b. MAX c. OLDEST d. MEDIAN

a. MIN

Which chart type CANNOT be displayed as a sparkline a. bar chart b. line chart c. column d. win/loss

a. bar chart

In a structures reference, what do you use to indicate a column heading or field name? a. brackets [ ] b. parenthesis ( ) c. curly brackets { } d. quotes " "

a. brackets [ ]

Which of the following is NOT a chart element? a. chart foreground b. chart title c. axis title d. gridlines

a. chart foreground

If you wanted every cell that has a values over $1,251 to have a purple fill, you would use what feature in Excel? a. conditional formatting b. autofill formating c. autocomplete formating d. aggregate cell formatting

a. conditional formatting

Which of the following is NOT a way to widen a column ? a. drag the line between the column headings to the desired size b. in the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box c. Double-click the line between the column headings d. Right-click a column heading and select Column Width

b. in the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box

What is the default method of referencing cells in formulas? a. absolute b. relative c. mixed d. default

b. relative

In the formula, =1+(2-3)+5/6-6*2, what will Excel execute first? a. 5/6 b. 1+ c. (2-3) d. 6*2

c. (2-3)

IF A7=21, which of the following =IF statements would produce the result of "Much Greater"? a. =IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) b. =IF(A7<50,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) c. =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) d. =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))

c. =IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20"))

What is NOT a purpose of using an effective chart? a. compares data b. reveals trends and patterns c. reveals even subtle errors in formulas d. aids in making informed decisions

c. reveals even subtle errors in formulas

What is NOT true about tables in Excel? a. column headings stay on the screen automatically b. filter arrows make it quick and easy to filter that data in the table c. row headings stay on the screen automatically d. you can export the data to a SharePoint list

c. row headings stay on the screen automatically

What does pressing the Enter key while in a cell do? a. the value is set, and the active cell remains the active cell b. the value is set, and the cell to the right becomes the active cell c. the value is set, and the cell below becomes the active cell d. the value is set, and the action is the same as pressing the Tab key

c. the value is set, and the cell below becomes the active cell

Which of the following is NOT a valid formula? a. =D3 b. =2*2 c. =sum(1,2,3,4,5) d. =#12/31/2014#-#12/31/2015#

d. =#12/31/2014#-#12/31/2015#

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference? a. fixed b. relative c. mixed d. absolute

d. absolute

Where does Excel display the Total row in a table? a. at the top of the table b. after each subtotal in the table c. two rows below the last row in the table d. below the last row in the table

d. below the last row in the table

What punctuation is used to separate the two cell references in a range? a. period (.) b. semi-colon (;) c. comma (,) d. colon (:)

d. colon (:)

Which of the following is NOT a freeze option? a. freeze panes b. freeze top row c. freeze first column d. freeze section

d. freeze section

A 100% stacked column chart is similar to what other chart in that it converts values to percentages? a. clustered column b. radar c. line d. pie

d. pie

A range is specified by its _______. a. top and bottom row and left and right column b. top row and leftmost column c. top right and bottom left cells d. top left and bottom right cells

d. top left and bottom right cells

What should you NOT select when selecting data for a chart? a. column labels b. row labels c. data d. worksheet titles

d. worksheet titles