50 Questions | Total Attempts: 100  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!

Related Topics
• 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.

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

• C.

Microsoft.com

• D.

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

• 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