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
Back to top