Spreadsheet Written Exam

NAME: ____________________________ Period: ___________

1. Spreadsheets are used for: A. Entering and calculating numeric data B. Creating accounting and financial documents C. Making charts and graphs D. All of these

2. A ___________________ is a grid of rows and columns containing numbers, text, and formulas.

A. Spreadsheet B. Ledger C. Workbook D. Document

3. Which of the following programs allows you to produce electronic spreadsheets?A. WordB. ExcelC. Power PointD. Access

4. What is an active cell? A. One that has numbers in it B. One that is selected and appears to have a dark border around it. C. One that has words in it. D. One that has a formula in it.

5. If you want to find the average of numbers in a cell range E5 though E10, the formula would be: A. AVG(E5-E10) B. =AVERAGE(E5-E10) C. =E5+E10D. =AVERAGE(E5:E10)

6. Columns in a worksheet are labeled:A. Using numbersB. Using lettersC. Using colorsD. Using symbols

7. Rows in a worksheet are labeledA. Using colorsB. Using numbersC. Using lettersD. Using symbols

1By Megan Rees

Spreadsheet Written Exam

8. A correct formula for subtracting would be A. =D3-D6 B. D3-D6 C. (D3-D6) D. #D3-D6

9. To get the minimum score on Assignment 1, what would I enter into cell B15?A. =MINIMUM(C3:C12)

B. =MIN(B3:B12) C. =MIN(B3:B14) D. =MINIMUM(B3:B14)

10. To AutoFit text or numbers to a column you A. Click once on the column header boundary B. Double click on the column header boundary C. Double click in a cell in the column D. Double click on the row header boundary

11. In Format Cells, under which tab would you find the Shrink to Fit option? A. Alignment B. Number C. Layout D. Fill

12. What type of chart would be best for this data?A. Column

B. Line C. Bar D. Pie

13. A correct cell reference or cell address is:A. AA25

B. J.10 C. 2C D. None of these

14. To select cells, what should your cursor look like?

A. A white plus sign B. A black plus sign C. A four-sided arrow D. A white arrow

15. Excel recognizes the entry =(B4/B2)*C4, as a ________ A. Label B. Value C. Formula D. Function

2By Megan Rees

Spreadsheet Written Exam

16. All Excel formulas begin with ____. A. * B. + C. = D. /

17. The correct formula to multiply cell D5 by B2 is ________. A. B2*D5 B. =D5*B2 C. D5*B2 D. (D5*B2)

18. SUM and AVERAGE are examples of: A. Function B. Buttons C. Toggles D. Arguments

19. Which mathematical operation is indicated by an asterisk (*)? A. Divide B. Multiply C. Subtraction D. Addition

20. A mathematical equation that adds, subtracts, multiplies, or divides data in a spreadsheet is called a:

A. Formula B. Reference C. Problem D. Value

21. What kind of chart would be best for this kind of data?A. Pie

B. Column C. Line D. Bar

22. _________ is what you do when you organize data numerically or alphabetically.A. Sorting

B. Formatting C. Charting D. Aligning

23. The key that explains the chart is called the: A. Bullet B. Series C. Legend D. Label

3By Megan Rees

Spreadsheet Written Exam

24. What is the decimal equivalent for 6.6% sales tax? A. .66 B. 6.6 C. .066 D. .0066

25. What does it mean when a cell contains ##########? A. The information entered is incorrect B. The information has been copied from another cell C. There is not enough room to display the numbers D. An absolute reference has been used.

26. The formula to calculate 7.5% sales tax on an item located in cell B24 is: A. =B24/7.5 B. =.075/B24 C. =B24*.075 D. =B24*7.5

27. ________ cells involves creating a single cell by combining two or more selected cells.

A. Sorting B. Splitting C. Centering D. Merging

28. The tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula:A. Data ValidationB. VLookup TableC. Conditional FormattingD. Sorting

29. Each worksheet has a sheet name that appears on a(n) ______ at the bottom of the workbook.

A. Name indicator B. Title tab C. Sheet tab D. Active tab

30. The basic unit of a worksheet into which you enter data, and is where a row and column meet, is called a:

A. Box B. Cell C. Range D. Tab

31. The horizontal and vertical lines on a worksheet are called: A. Gridlines B. Blocklines C. Cells D. Sheets

4By Megan Rees

Spreadsheet Written Exam

32. In Excel, the name of the file created that contains one or more worksheets is called a

A. Workbook B. Spreadsheet file C. Excel worksheet D. Folder

33. To save your file using the shortcut keys, press: A. ALT+S B. CTRL+ C. SHIFT+S D. CTRL+A

34. The small black box on the lower right hand corner is called the:A. Drag handle

B. Fill handle C. Auto Fill D. Autofit

35. What symbol do you use to make a cell reference an absolute value? A. # B. $ C. @ D. =

36. Match the following icons to their purpose:

Borders A

Sort BAutosum C

Merge & Center D

Wrap Text EConditional Formatting

F

Rotate Text G

37. Which of the following represents a RANGE of cells? A. A1 B. Column B C. A2:I2 D. A2-I2

For Questions 39-41, use the image to the right.

5By Megan Rees

Spreadsheet Written Exam

38. What function is being used in cell B14 of this spreadsheet?A. AVERAGE

B. COUNT C. MAXIMUM D. MINIMUM E. SUM

39. What function is being used in cell C14 of this spreadsheet?A. AVERAGE

B. COUNT C. MAXIMUM D. MINIMUM E. SUM

40. What function is being used in cell D14 of this spreadsheet?A. AVERAGE

B. COUNT C. MAXIMUM D. MINIMUM E. SUM

41. This function looks up a value in one column, and finds its corresponding value on the same row in another column.A. MAXB. COUNTIFC. VLOOKUPD. IF

42. This function returns one value if a condition is true and another value if it’s false.A. VLOOKUPB. CONCATENATEC. IFD. LEFT

43. What function was used in column C?A. VLOOKUPB. CONCATENATEC. MIDD. IF

44. What function was used in column D?A. LEFTB. PROPERC. NAMED. CONCATENATE

6By Megan Rees

Spreadsheet Written Exam

45. Label the Excel Sheet parts

Active Cell Formula BarSheet TabsColumn ButtonsFill HandleRow ButtonsInsert Function Button Zoom Control RibbonName BoxBoundary HeadingCell

46. If you wanted to count the number of times “blue” appears in the cells shown, how would you write the formula?A. =Countif(A1:A9,”blue”) B. =Count(“blue”)C. =Countif(A1:A10,=”blue”)D. =Count(“A1:A9,”Blue”)

47. In order to select different ranges that are not adjacent on a spreadsheet, you must hold down the ________ key while highlighting.

7By Megan Rees

Spreadsheet Written Exam

A. ENTER B. SHIFT C. ALT D. CTRL

48. Match the type of chart to the type of information it is best for. (Draw a line)

Change over Time CompositeA Part of the Whole Line

Compare incompatible sets of number data Bar or ColumnVisualize more than one category of data Pie

49. Which column was used to sort this data?A. AB. BC. CD. D

50. This data was sorted in a Multiple Sort. Which column was it sorted by first, and which column was it sorted by second?A. A, CB. B, AC. D, AD. B, C

8By Megan Rees