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)?
Correct Answer
D. =IF(C5>=70%,"Pass","Fail")
Explanation
This teacher does not round up the grades in her class.
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?
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?
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 _____.
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?
Correct Answer
D. Both B and C are correct
6.
To save an existing file using a different name, you would choose the _____ command.
Correct Answer
C. Save as
7.
When you choose the Alignment drop-down arrow, and the Number Category, the 1000 Separator _____.
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).
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?
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 _____.
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.
Correct Answer
B. Alignment
12.
Values, by default, are aligned _____.
Correct Answer
B. To the right
13.
Mathematical operations are carried out in the following order:
Correct Answer
D. P - E - M - D - A - S
14.
It is best to write formulas using cell references so that a spreadsheet _____.
Correct Answer
C. Can be easily updated
15.
When inserting a column, it will always appear _____.
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?
Correct Answer
C. Microsoft.com
17.
To arrange rows in alphabetical order based on Column A, you need to use the command _____.
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 _____.
Correct Answer
D. =(D4+C2)*B2
19.
A quick way to get to Cell A1 (Home) is to _____.
Correct Answer
A. Press CTRL + Home
20.
The feature that allows you to arrange rows in alphabetical order is _____.
Correct Answer
A. Sorting
21.
If a cell displays #######, it means that _____.
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 _____.
Correct Answer
C. Click the AutoSum button on the Home or Formulas Tab
23.
To display a comment in a worksheet _____.
Correct Answer
A. Roll the mouse over the red triangle
24.
A chart placed as an object within a worksheet is called a/an _____.
Correct Answer
B. Embedded chart
25.
All charts use an X-axis and a Y-axis EXCEPT a _____ chart.
Correct Answer
D. Pie
26.
When you select worksheets as a unit, all actions performed affect all the worksheets. This is called _____.
Correct Answer
B. Grouping
27.
A graphic that allows you to compare and contrast data in a visual format is called _____.
Correct Answer
C. A chart
28.
A block of cells in an Excel worksheet is called the _____.
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?
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 _____.
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).
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?
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?
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?
Correct Answer
C. =F10-E10; =G10/E10
35.
To select Cells A3-A9 and Cells D3-D9 simultaneously, you would _____.
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.
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?
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?
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?
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 _____.
Correct Answer
B. Noncontiguous ranges
41.
The format that aligns the dollar signs next to the dollar amount is called a/an _____.
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 _____.
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)?
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 _____.
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 _____.
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.
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.
Correct Answer
A. True
48.
The Format button allows you to do all of the following EXCEPT _____.
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?
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
Correct Answer
A. True