Spreadsheet Management
Settings
-
+
Mrs. Vance's Spreadsheet Management class will take this written test, along with a performance exam, that will count as part of your final semester grade. GOOD LUCK!
- 1.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)?
- A.
=if(C5 >70%,"PASS","FAIL")
- B.
=IF(C5>70%,PASS,FAIL)
- C.
=if(C5>=69.5%,"PASS","FAIL")
- D.
=IF(C5>=70%,"Pass","Fail")
- 2.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?
- A.
=D5+E5
- B.
=D5-E5
- C.
=E5-D5
- D.
=PRICE(D5-E5)
- 3.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?
- A.
=B10*6%
- B.
=B10*C10
- C.
=B10*6%+B10
- D.
=(B10+C10)*6%
- 4.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 _____.
- A.
$100,000, $90,600
- B.
$100,000, $96,000
- C.
$10,000, $9,600
- D.
$10,000, $9,060
- 5.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?
- A.
=SUM(A1;A3)
- B.
=540+625+566
- C.
=A1+A2+A3
- D.
Both B and C are correct
- E.
All answers are correct
- 6.To save an existing file using a different name, you would choose the _____ command.
- A.
Save
- B.
Retrieve
- C.
Save as
- D.
Store file
- 7.When you choose the Alignment drop-down arrow, and the Number Category, the 1000 Separator _____.
- A.
Inserts a dollar sign format
- B.
Inserts a percentage format
- C.
Inserts a decimal format
- D.
Inserts a comma format
- 8.Cell B5 is 45; Cell B6 is 45; Cell B7 is 44. Which is the correct formula for B8 that will return the answer 45 (do not use decimal places).
- A.
=MAX(B5:B7)
- B.
=AVERAGE(B5:B7)
- C.
=SUM(B5:B7)
- D.
Both A and B are correct
- E.
None of the above is correct
- 9.Which of the following is NOT a use of the tab at the bottom of each worksheet?
- A.
Moving from one worksheet to another
- B.
Inserting new columns and rows
- C.
Rearranging the order of worksheets
- D.
Identifying the worksheet
- E.
B and D only
- 10.If you select a cell with a date in it and drag the fill handle down several cells, what happens is _____.
- A.
The date is copied to each cell
- B.
The date is increased by one day into each cell
- C.
The date is increased by one week into each cell
- D.
Nothing happens because the fill applies only to numbers
- 11.The settings to wrap text in a cell and to merge cells are found in the Format Cells dialog box on the _____ tab.
- A.
Number
- B.
Alignment
- C.
Font
- D.
Border
- 12.Values, by default, are aligned _____.
- A.
To the left
- B.
To the right
- C.
Centered in the cell
- D.
At the top of the cell
- 13.
- A.
A - S - M - D - E - P
- B.
P - A - M - D - E - S
- C.
P - M - D - A - S - E
- D.
P - E - M - D - A - S
- E.
None of the above
- 14.It is best to write formulas using cell references so that a spreadsheet _____.
- A.
Has no hidden information
- B.
Has all correct values
- C.
Can be easily updated
- D.
Can be easily graphed
- 15.When inserting a column, it will always appear _____.
- A.
To the left of the active cell/column
- B.
Highlighted
- C.
To the right of the active cell/column
- D.
As a new Column A
- 16.What online resource can you use for Excel training, clip art, videos, or help and support?
- A.
Excel.com
- B.
Yahoo Questions and Answers
- C.
Microsoft.com
- D.
Spreadsheet Support
- 17.To arrange rows in alphabetical order based on Column A, you need to use the command _____.
- A.
Home, Sort and Filter
- B.
Data, Sort
- C.
Edit, Data, Sort
- D.
None of the above
- E.
Both A and B
- 18.The formula that will add the value of D4 to the value of C2 and then multiply by the value in B2 is _____.
- A.
(D4+C2)*B2
- B.
D4+C2*B2
- C.
=D4+C2*B2
- D.
=(D4+C2)*B2
- 19.A quick way to get to Cell A1 (Home) is to _____.
- A.
Press CTRL + Home
- B.
Press Shift A1
- C.
Use Find and Replace
- D.
Click on File, Home
- 20.The feature that allows you to arrange rows in alphabetical order is _____.
- A.
Sorting
- B.
Conditional formatting
- C.
Filtering
- D.
Autofill
- 21.If a cell displays #######, it means that _____.
- A.
There is a formatting error
- B.
The column is too narrow to display all the digits of the number
- C.
There is an error in your formula
- D.
You need to center the text within the cell
- 22.A fast way to add up a column of numbers is to click the cell below the numbers and then _____.
- A.
Click subtotals on the Data Menu
- B.
View the sum in the Formula Bar
- C.
Click the AutoSum button on the Home or Formulas Tab
- D.
Use a formula
- E.
Use a function
- 23.To display a comment in a worksheet _____.
- A.
Roll the mouse over the red triangle
- B.
Choose View, comment
- C.
Highlight the cell
- D.
Both A and B
- 24.A chart placed as an object within a worksheet is called a/an _____.
- A.
Chart sheet
- B.
Embedded chart
- C.
Category
- D.
Linked object
- 25.All charts use an X-axis and a Y-axis EXCEPT a _____ chart.
- A.
Bar
- B.
Line
- C.
Column
- D.
Pie
- E.
XY scatter plot
- 26.When you select worksheets as a unit, all actions performed affect all the worksheets. This is called _____.
- A.
Activating
- B.
Grouping
- C.
Attaching
- D.
None of the above
- 27.A graphic that allows you to compare and contrast data in a visual format is called _____.
- A.
A plot
- B.
A legend
- C.
A chart
- D.
A scenario
- E.
A pivot table
- 28.A block of cells in an Excel worksheet is called the _____.
- A.
Area
- B.
Range
- C.
Cell reference
- D.
Name box
- E.
All of the above
- 29.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?
- A.
=A1+B1-C1-D1
- B.
=A1-B1+C1-D1
- C.
=A1-B1-C1+D1
- D.
=A1+B1+C1-D1
- 30.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 _____.
- A.
=C1*5%, =C1+C3
- B.
=C2*5%, =C1+C3
- C.
=C2*5%, =C1+C2
- D.
=C1+C2, =C2*5%
- E.
None of the above are correct
- 31.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).
- A.
=A1*B1; = B1-C1; =3%*C1; =D1-E1
- B.
=A1-B1; =A1-C1; =3%*B1; =D1-E1
- C.
=A1*B1; =A1-C1; =5%*D1; =D1+E1
- D.
=A1*B1; =B1-C1; = 5%+D1; =D1+E1
- 32.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?
- A.
=E13*F13
- B.
=F13/E13
- C.
=F13-E13
- D.
=E13/F13
- 33.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?
- A.
=A1/B1; =A1/D1; =C1-E1; Loss
- B.
=A1*B1; =A1*D1; =E1-C1; Gain
- C.
=A1*B1; =A1*D1; =C1-E1; Loss
- D.
=A1+B1; =A1+D1; =E1-C1; Gain
- 34.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?
- A.
=F10-E10; =E10/G10
- B.
=E10-F10; =E10/G10
- C.
=F10-E10; =G10/E10
- D.
=E10+F10; =G10*E10
- E.
None of the above are correct
- 35.To select Cells A3-A9 and Cells D3-D9 simultaneously, you would _____.
- A.
Hold down the CTRL key, select Cells A3-A9, select Cells D3-D9
- B.
Hold down the Shift key, select Cells A3-A9, select Cells D3-D9
- C.
Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9
- D.
Select Cells A3-A9, hold down the Shift key, select Cells D3-D9
- E.
Both A and B will make the selection simultaneously
- 36.In a large spreadsheet, while scrolling down, it is helpful to make column headings visible by applying the _____ feature to the spreadsheet.
- A.
Arrange Panes
- B.
Split Panes
- C.
Freeze Panes
- D.
Conditional Formatting
- 37.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?
- A.
Open
- B.
New
- C.
Publish
- D.
Excel Options
- 38.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?
- A.
Insert, Object, Create from File, Browse
- B.
Insert, Object, Microsoft Excel Binary Worksheet
- C.
Insert, Object, Microsoft Excel Worksheet
- D.
Insert, Object, Microsoft Excel Chart
- 39.You have created several diagrams in MS Excel during class. Which diagram shows a process with a continuous flow?
- A.
Target Diagram
- B.
Pyramid Diagram
- C.
Radial Diagram
- D.
Cycle Diagram
- 40.Cells in a worksheet that act as a block, but are not necessarily adjacent to each other are called _____.
- A.
Ranges
- B.
Noncontiguous ranges
- C.
Contiguous ranges
- D.
Cell ranges
- 41.The format that aligns the dollar signs next to the dollar amount is called a/an _____.
- A.
Number format
- B.
Percent format
- C.
Currency format
- D.
Accounting format
- 42.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 _____.
- A.
Relative cell reference
- B.
Absolute cell reference
- C.
Referential cell reference
- D.
Formatting cell reference
- 43.Which function will calculate the cells containing numbers in a range of cells (blank cells or text entries are ignored)?
- A.
=AVERAGE( )
- B.
=COUNT( )
- C.
=SUM( )
- D.
=ROUND( )
- 44.If you select a cell with a number in it and drag the fill handle down several cells, what happens is _____.
- A.
The number is copied into each cell
- B.
The number is increased by one number into each cell
- C.
Nothing happens because fill does not apply to numbers
- D.
None of the answers is correct
- 45.A format such as cell shading or font color that Excel can apply automatically if certain things are true is called _____.
- A.
Autoformatting
- B.
Conditional formatting
- C.
Patterns
- D.
Both a and b are correct
- 46.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.
- A.
True
- B.
False
- 47.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.
- A.
True
- B.
False
- 48.The Format button allows you to do all of the following EXCEPT _____.
- A.
Change row height
- B.
Change column width
- C.
Hide and unhide rows and columns
- D.
Protect sheet and lock cells
- E.
All answers are correct
- 49.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?
- A.
=SUM(B13:B15)
- B.
=B13+B14+B15
- C.
=SUM(B13:B15)*0.83
- D.
Both a and b are correct
- E.
Both a and c are correct
- 50.Control plus the ` key will show your formulas in a spreadsheet so that you can check for accuracy
- A.
True
- B.
False
Back to top