Spreadsheet Management
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")
Correct Answer
D. =IF(C5>=70%,"Pass","Fail")Explanation
This teacher does not round up the grades in her class.Rate this question:
-
- 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)
Correct Answer
B. =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%
Correct Answer
C. =B10*6%+B10 -
- 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
Correct Answer
A. $100,000, $90,600 -
- 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
Correct Answer
D. Both B and C 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
Correct Answer
C. Save as -
- 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
Correct Answer
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
Correct Answer
D. Both A and B are 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
Correct Answer
B. Inserting new columns and rows -
- 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
Correct Answer
B. The date is increased by one day into each cell -
- 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
Correct Answer
B. Alignment -
- 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
Correct Answer
B. To the right -
- 13.
Mathematical operations are carried out in the following order:
- 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
Correct Answer
D. P - E - M - D - A - S -
- 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
Correct Answer
C. Can be easily updated -
- 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
Correct Answer
A. To the left of the active cell/column -
- 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
Correct Answer
C. Microsoft.com -
- 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
Correct Answer
B. Data, Sort -
- 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
Correct Answer
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
Correct Answer
A. Press CTRL + Home -
- 20.
The feature that allows you to arrange rows in alphabetical order is _____.
- A.
Sorting
- B.
Conditional formatting
- C.
Filtering
- D.
Autofill
Correct Answer
A. Sorting -
- 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
Correct Answer
B. The column is too narrow to display all the digits of the number -
- 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
Correct Answer
C. Click the AutoSum button on the Home or Formulas Tab -
- 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
Correct Answer
A. Roll the mouse over the red triangle -
- 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
Correct Answer
B. Embedded chart -
- 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
Correct Answer
D. Pie -
- 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
Correct Answer
B. Grouping -
- 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
Correct Answer
C. A chart -
- 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
Correct Answer
B. Range -
- 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
Correct Answer
B. =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
Correct Answer
B. =C2*5%, =C1+C3 -
- 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
Correct Answer
C. =A1*B1; =A1-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
Correct Answer
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
Correct Answer
B. =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
Correct Answer
C. =F10-E10; =G10/E10 -
- 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
Correct Answer
C. Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9 -
- 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
Correct Answer
C. Freeze Panes -
- 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
Correct Answer
B. New -
- 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
Correct Answer
C. Insert, Object, Microsoft Excel Worksheet -
- 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
Correct Answer
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
Correct Answer
B. Noncontiguous 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
Correct Answer
C. Currency 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
Correct Answer
B. Absolute 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( )
Correct Answer
B. =COUNT( ) -
- 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
Correct Answer
A. The number is copied into each cell -
- 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
Correct Answer
B. Conditional formatting -
- 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
Correct Answer
A. True -
- 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
Correct Answer
A. True -
- 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
Correct Answer
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
Correct Answer
C. =SUM(B13:B15)*0.83 -
- 50.
Control plus the ` key will show your formulas in a spreadsheet so that you can check for accuracy
- A.
True
- B.
False
Correct Answer
A. True -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 09, 2013Quiz Edited by
ProProfs Editorial Team -
Dec 29, 2009Quiz Created by
Angievance
- Account Management Quizzes
- Business Management Quizzes
- Classification Quizzes
- Conflict Management Quizzes
- Coordination Quizzes
- Document Management System Quizzes
- ERP Quizzes
- Event Management Quizzes
- File Management Quizzes
- Financial Management Quizzes
- Integrated Solid Waste Management Quizzes
- Operation Management Quizzes
- Principles Of Management Quizzes
- Principles Of Supervision Quizzes
- Process Management Quizzes
- Procurement Quizzes
- Product Management Quizzes
- Property Management Quizzes
- QMS Quizzes
- Quality Management Quizzes
- Resource Management Quizzes
- Responsibility Quizzes
- Risk Management Quizzes
- Scope Management Quizzes
- Security Management Quizzes
- Strategic Management Quizzes
- Supervisory Management Quizzes
- Time Management Quizzes
Back to top