Spreadsheet Management

50 Questions | Attempts: 111
Share
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/50 Questions

    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
Please wait...
About This Quiz

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!

Data Management Quizzes & Trivia

Quiz Preview

  • 2. 

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

    • Bar

    • Line

    • Column

    • Pie

    • XY scatter plot

    Correct Answer
    A. Pie
  • 3. 

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

    • Number format

    • Percent format

    • Currency format

    • Accounting format

    Correct Answer
    A. Currency format
  • 4. 

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

    • Save

    • Retrieve

    • Save as

    • Store file

    Correct Answer
    A. Save as
  • 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

    Correct Answer
    A. The column is too narrow to display all the digits of the number
  • 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

    Correct Answer
    A. Freeze Panes
  • 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

    Correct Answer
    A. Inserts a comma format
  • 8. 

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

    • Sorting

    • Conditional formatting

    • Filtering

    • Autofill

    Correct Answer
    A. Sorting
  • 9. 

    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

    Correct Answer
    A. Click the AutoSum button on the Home or Formulas Tab
  • 10. 

    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

    Correct Answer
    A. Absolute cell reference
  • 11. 

    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

    Correct Answer
    A. The number is copied into each cell
  • 12. 

    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

    Correct Answer
    A. =(D4+C2)*B2
  • 13. 

    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

    Correct Answer
    A. A chart
  • 14. 

    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

    Correct Answer
    A. P - E - M - D - A - S
  • 15. 

    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

    Correct Answer
    A. Press CTRL + Home
  • 16. 

    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

    Correct Answer
    A. True
  • 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

    Correct Answer
    A. Cycle Diagram
  • 18. 

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

    • Chart sheet

    • Embedded chart

    • Category

    • Linked object

    Correct Answer
    A. Embedded chart
  • 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

    Correct Answer
    A. Inserting new columns and rows
  • 20. 

    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)

    Correct Answer
    A. =D5-E5
  • 21. 

    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

    Correct Answer
    A. The date is increased by one day into each cell
  • 22. 

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

    • Activating

    • Grouping

    • Attaching

    • None of the above

    Correct Answer
    A. Grouping
  • 23. 

    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

    Correct Answer
    A. Noncontiguous ranges
  • 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

    Correct Answer
    A. New
  • 25. 

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

    • True

    • False

    Correct Answer
    A. True
  • 26. 

    Values, by default, are aligned _____.

    • To the left

    • To the right

    • Centered in the cell

    • At the top of the cell

    Correct Answer
    A. To the right
  • 27. 

    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

    Correct Answer
    A. Can be easily updated
  • 28. 

    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

    Correct Answer
    A. =SUM(B13:B15)*0.83
  • 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

    Correct Answer
    A. 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

    Correct Answer
    A. $100,000, $90,600
  • 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

    Correct Answer
    A. To the left of the active cell/column
  • 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

    Correct Answer
    A. =A1*B1; =A1-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

    Correct Answer
    A. Range
  • 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

    Correct Answer
    A. Insert, Object, Microsoft Excel Worksheet
  • 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

    Correct Answer
    A. =C2*5%, =C1+C3
  • 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

    Correct Answer
    A. =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

    Correct Answer
    A. =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

    Correct Answer
    A. Conditional formatting
  • 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

    Correct Answer
    A. Roll the mouse over the red triangle
  • 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

    Correct Answer
    A. Both B and C 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

    Correct Answer
    A. Microsoft.com
  • 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

    Correct Answer
    A. =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

    Correct Answer
    A. =F10-E10; =G10/E10
  • 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( )

    Correct Answer
    A. =COUNT( )
  • 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

    Correct Answer
    A. Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9
  • 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%

    Correct Answer
    A. =B10*6%+B10
  • 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

    Correct Answer
    A. True
  • 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")

    Correct Answer
    A. =IF(C5>=70%,"Pass","Fail")
    Explanation
    This teacher does not round up the grades in her class.

    Rate this question:

  • 49. 

    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).

    • =MAX(B5:B7)

    • =AVERAGE(B5:B7)

    • =SUM(B5:B7)

    • Both A and B are correct

    • None of the above is correct

    Correct Answer
    A. Both A and B are correct

Quiz Review Timeline (Updated): Jan 9, 2013 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jan 09, 2013
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 29, 2009
    Quiz Created by
    Angievance
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.