Spreadsheet Management

1. All charts use an X-axis and a Y-axis EXCEPT a _____ chart.

Bar

Line

Column

Pie

XY scatter plot

2. The format that aligns the dollar signs next to the dollar amount is called a/an _____.

Number format

Percent format

Currency format

Accounting format

3. The settings to wrap text in a cell and to merge cells are found in the Format Cells dialog box on the _____ tab.

Number

Alignment

Font

Border

4. To save an existing file using a different name, you would choose the _____ command.

Save

Retrieve

Save as

Store file

5. If a cell displays #######, it means that _____.

There is a formatting error

The column is too narrow to display all the digits of the number

There is an error in your formula

You need to center the text within the cell

6. In a large spreadsheet, while scrolling down, it is helpful to make column headings visible by applying the _____ feature to the spreadsheet.

Arrange Panes

Split Panes

Freeze Panes

Conditional Formatting

7. When you choose the Alignment drop-down arrow, and the Number Category, the 1000 Separator _____.

Inserts a dollar sign format

Inserts a percentage format

Inserts a decimal format

Inserts a comma format

8. A fast way to add up a column of numbers is to click the cell below the numbers and then _____.

Click subtotals on the Data Menu

View the sum in the Formula Bar

Click the AutoSum button on the Home or Formulas Tab

Use a formula

Use a function

9. A cell address that is referenced in a formula that does not change based on the location of the cell that contains the formula is called a/an _____.

Relative cell reference

Absolute cell reference

Referential cell reference

Formatting cell reference

10. If you select a cell with a number in it and drag the fill handle down several cells, what happens is _____.

The number is copied into each cell

The number is increased by one number into each cell

Nothing happens because fill does not apply to numbers

None of the answers is correct

11. The feature that allows you to arrange rows in alphabetical order is _____.

Sorting

Conditional formatting

Filtering

Autofill

12. A graphic that allows you to compare and contrast data in a visual format is called _____.

A plot

A legend

A chart

A scenario

A pivot table

13. The formula that will add the value of D4 to the value of C2 and then multiply by the value in B2 is _____.

(D4+C2)*B2

D4+C2*B2

=D4+C2*B2

=(D4+C2)*B2

14. You can import a text file from MS Word into MS Excel by choosing the Data Tab, Get External Data From Text, choose the correct file, and then the Import button.

True

False

15. Mathematical operations are carried out in the following order:

A - S - M - D - E - P

P - A - M - D - E - S

P - M - D - A - S - E

P - E - M - D - A - S

None of the above

16. A quick way to get to Cell A1 (Home) is to _____.

Press CTRL + Home

Press Shift A1

Use Find and Replace

Click on File, Home

17. You have created several diagrams in MS Excel during class. Which diagram shows a process with a continuous flow?

Target Diagram

Pyramid Diagram

Radial Diagram

Cycle Diagram

18. A chart placed as an object within a worksheet is called a/an _____.

Chart sheet

Embedded chart

Category

Linked object

19. Which of the following is NOT a use of the tab at the bottom of each worksheet?

Moving from one worksheet to another

Inserting new columns and rows

Rearranging the order of worksheets

Identifying the worksheet

B and D only

20. When you select worksheets as a unit, all actions performed affect all the worksheets. This is called _____.

Activating

Grouping

Attaching

None of the above

21. Cells in a worksheet that act as a block, but are not necessarily adjacent to each other are called _____.

Ranges

Noncontiguous ranges

Contiguous ranges

Cell ranges

22. A Sony digital camera price is listed as $300.00 in Cell D5. The digital camera discount price is listed in Cell E5 as $20.00. You are going to insert a formula in Cell F5 to list the final price. Which formula is correct?

=D5+E5

=D5-E5

=E5-D5

=PRICE(D5-E5)

23. If you select a cell with a date in it and drag the fill handle down several cells, what happens is _____.

The date is copied to each cell

The date is increased by one day into each cell

The date is increased by one week into each cell

Nothing happens because the fill applies only to numbers

24. Templates (budgets, sales invoices, expense statements, loan amortizations, etc.) are included in MS Excel software. They can be found under the Office Button using which command?

Open

New

Publish

Excel Options

25. Control plus the ` key will show your formulas in a spreadsheet so that you can check for accuracy

True

False

26. In an Expense Report, Cell B13 contains the car miles (313 miles @ $0.83 per mile) for Day 1, Cell B14 contains 72 car miles for Day 2, Cell B15 contains 33 car miles for Day 3. Which formula is correct for calculating the total car expense to be reimbursed to the employee?

=SUM(B13:B15)

=B13+B14+B15

=SUM(B13:B15)*0.83

Both a and b are correct

Both a and c are correct

27. Values, by default, are aligned _____.

To the left

To the right

Centered in the cell

At the top of the cell

28. It is best to write formulas using cell references so that a spreadsheet _____.

Has no hidden information

Has all correct values

Can be easily updated

Can be easily graphed

29. The Format button allows you to do all of the following EXCEPT _____.

Change row height

Change column width

Hide and unhide rows and columns

Protect sheet and lock cells

All answers are correct

30. Paris Hilton worked 20 hours this week designing her new cologne. She was paid $5,000.00 an hour. The Federal Tax is 2%; the Social Security Tax is 3.5%; the State Tax is 1.5%; and the Medicare Tax is 2.4%. Her Gross Pay is _____, and her Net Pay is _____.

$100,000, $90,600

$100,000, $96,000

$10,000, $9,600

$10,000, $9,060

31. When inserting a column, it will always appear _____.

To the left of the active cell/column

Highlighted

To the right of the active cell/column

As a new Column A

32. Assume you work at your local mall at a fragrance boutique. Suppliers generally offer customers who buy on account a cash discount for early payment (Purchase Discount). The amount owed is $658 (Cell A1). The purchase discount is 3% (Cell B1). The Purchase Discount formula is _____ (Cell C1). The Subtotal formula is _____ (Cell D1). The sales tax is 5% on the Subtotal, and the formula is _____ (Cell E1). The Amount Owed formula is _____ (Cell F1).

=A1*B1; = B1-C1; =3%*C1; =D1-E1

=A1-B1; =A1-C1; =3%*B1; =D1-E1

=A1*B1; =A1-C1; =5%*D1; =D1+E1

=A1*B1; =B1-C1; = 5%+D1; =D1+E1

33. A block of cells in an Excel worksheet is called the _____.

Area

Range

Cell reference

Name box

All of the above

34. You have created a new document in MS Word 2007. You would like to insert a new Excel spreadsheet into the document. Which commands in MS Word would you use to complete this action?

Insert, Object, Create from File, Browse

Insert, Object, Microsoft Excel Binary Worksheet

Insert, Object, Microsoft Excel Worksheet

Insert, Object, Microsoft Excel Chart

35. Wireless Connections uses commissions as an incentive to motivate their sales staff. John Doe's base salary for the month of February is $1,000 (Cell C1). John earns a 5% commission for his Sales of $12,057 (Cell C2). The formula for his commission in February (Cell C3) is _____. In Cell C4, you will write a formula for his Total Salary for February. The formula for Cell C4 is _____.

=C1*5%, =C1+C3

=C2*5%, =C1+C3

=C2*5%, =C1+C2

=C1+C2, =C2*5%

None of the above are correct

36. You are finding the balance in your checkbook register. Cell A1 contains your first deposit of $750 on January 4. Cell B1 contains a check you wrote on January 6 for $55. Cell C1 contains another deposit on January 10 for $43.23. On January 11, you withdrew $20 from your bank's ATM (Cell D1). In Cell E1, you need to write a formula for the Balance. Which is the correct formula?

=A1+B1-C1-D1

=A1-B1+C1-D1

=A1-B1-C1+D1

=A1+B1+C1-D1

37. A mutual fund is an open-ended fund operated by an investment company. On January 1, 2010, you own 165 shares (Cell A1) in the investment company Fidelity. The price of each share at the beginning of the year was $18.82 (Cell B1). On December 31, 2010, the price of each share was $19.75 (Cell D1). Which formulas are correct for the value of the shares on January 1, 2010 (Cell C1), the value of the shares on December 31, 2010 (Cell E1), and the gain/loss at the end of the year (Cell F1)? Did you have a gain or loss?

=A1/B1; =A1/D1; =C1-E1; Loss

=A1*B1; =A1*D1; =E1-C1; Gain

=A1*B1; =A1*D1; =C1-E1; Loss

=A1+B1; =A1+D1; =E1-C1; Gain

38. A format such as cell shading or font color that Excel can apply automatically if certain things are true is called _____.

Autoformatting

Conditional formatting

Patterns

Both a and b are correct

39. To display a comment in a worksheet _____.

Roll the mouse over the red triangle

Choose View, comment

Highlight the cell

Both A and B

40. Lisa's SAT scores for Reading are 540 (Cell A1); Math 625 (Cell A2), and Writing 566 (Cell A3). Which formula would give the correct total for all three scores?

=SUM(A1;A3)

=540+625+566

=A1+A2+A3

Both B and C are correct

All answers are correct

41. What online resource can you use for Excel training, clip art, videos, or help and support?

Excel.com

Yahoo Questions and Answers

Microsoft.com

Spreadsheet Support

42. The Los Angeles Lakers coach has kept a spreadsheet of his players' field goals made, field goals attempted, and percentage. Cell E13 has Field Goals Made, Cell F13 has Field Goals Attempted. In Cell G13, what would be the correct formula for Kobe Bryant's Percentage. Kobe made 630 field goals and attempted 1114?

=E13*F13

=F13/E13

=F13-E13

=E13/F13

43. You own a boutique clothing store that sells merchandise to the general public. Businesses must determine how inventory should be marked up by dollars and percents. Your Tee Long Sleeve Logo shirts' Unit Cost is $15.00 (Cell E10). The Selling Price is $25.60 (Cell F10). In Cell G10, you want to create a formula to calculate the Markup Price. In Cell H10, you want to calculate the Markup Percentage. Which two formulas (choose only one answer) are correct?

=F10-E10; =E10/G10

=E10-F10; =E10/G10

=F10-E10; =G10/E10

=E10+F10; =G10*E10

None of the above are correct

44. Which function will calculate the cells containing numbers in a range of cells (blank cells or text entries are ignored)?

=AVERAGE( )

=COUNT( )

=SUM( )

=ROUND( )

45. To select Cells A3-A9 and Cells D3-D9 simultaneously, you would _____.

Hold down the CTRL key, select Cells A3-A9, select Cells D3-D9

Hold down the Shift key, select Cells A3-A9, select Cells D3-D9

Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9

Select Cells A3-A9, hold down the Shift key, select Cells D3-D9

Both A and B will make the selection simultaneously

46. A Kodak digital camera price of $559.00 is listed in Cell B10. The sales tax of 6% is listed in Cell C10. You are going to insert a formula in Cell D10 to list the final price of the camera. Which formula is correct?

=B10*6%

=B10*C10

=B10*6%+B10

=(B10+C10)*6%

47. When you choose a cell with data in it, you can select that cell, drag down (or across) several cells, and select Control D to duplicate the cells.

True

False

48. In English 102, Mrs. Gerlach tells you that a passing grade for her class is 70%. Which IF Statement would be correct if you were to receive a passing grade for the class (assuming C5 is your final grade)?

=if(C5 >70%,"PASS","FAIL")

=IF(C5>70%,PASS,FAIL)

=if(C5>=69.5%,"PASS","FAIL")

=IF(C5>=70%,"Pass","Fail")

This teacher does not round up the grades in her class.

Explanation

This teacher does not round up the grades in her class.