Skill Assessment Survey for Becoming a Beginner in Excel

Trends in Expenditure FY06-09Pt 1020,000,00040,000,00060,000,00080,000,000100,000,000120,000,000140,000,000FiscalYear 2006FiscalYear 2007FiscalYear 2008FiscalYear 2009Axis TitleREGULATORY BOARDS &COMMISSIONSJUDICIAL OFFICESLEGISLATIVE OFFICESExpenditures-Fiscal Year 2007LEGISLATIVE OFFICESJUDICIAL OFFICESOTHER CONSTITUTIONALOFFICESREGULATORY BOARDS &COMMISSIONSINSTITUTIONS OF HIGHEREDUCATIONSTATE AGENCIESBecoming a Beginner in Excel Skill Assessment Survey 1) What are the columns? a. A-F b. 1-9 2) What are the rows? c. A-F d. 1-9 3) What type of chart is ? e. Area Chart f. XY Scatter Chart g. Line Chart h. Pie Chart i. Column Chart j. Bar Chart k. Radar Chart 4) What type of chart is  l. Area Chart m. XY Scatter Chart n. Line Chart o. Pie Chart p. Column Chart q. Bar Chart r. Radar Chart 5) Look at the mouse pointer in the diagram. What is this user in the middle of doing? a. Copying a range of cells b. Moving a range of cells c. Copying a worksheet d. Moving a worksheet 6) Sorting data can only be done with numbers a. True b. False 7) What is the shortcut to copy? a. Ctrl + V b. Shift + V c. Ctrl + C d. Shift + C 8) To begin a formula in Excel, what do you start with? a. – b. = c. * d. ^ 9) What is it called when there is a dropdown list of words/dates/times, etc? a. Auto Format b. Track Changes c. Create List d. Data Validation 10) When sorting data only 1 column/row can be done at a time. a. True b. False 11) What is the shortcut to un-do? a. Ctrl + Z b. Shift + Z c. Ctrl + U d. Shift + U 12) Paste Special allows you to: a. Paste only numbers and letters – no formulas b. Paste only the format of the cells-formulas included c. Paste all, formulas, values, formats, comments, and more d. Paste with no border options 13) Can more than 1 person share a workspace? a. Yes b. No 14) If you have a large spreadsheet and need the top column/row to not move, what function do you use? a. Freeze Pane b. Freeze Workbook c. Conditional Formatting d. Header/Footer 15) Formulas typed in cells appear where? a. A b. B c. C d. D e. E