Microsoft Excel Questions… 9 pages of questions.

Need to have this done by Midnight. Simple questions for Excel.

Name _________________________

Date ___________

Excel 2010: Chapter 4 – Multiple Choice

Instructions: Circle the correct response.

1. You use a(n) ____________ to automate data analyses and organize the answers returned by Excel.

a. Cell
b. data table
c. formula
d. annuity

2. ____________ formatting is when you assign a format to all the cells in all the worksheets in a workbook.

a. Class inheritance
b. Absolute
c. Global
d. Frontline

3. The ____________ can help add clarity to your formulas by allowing you to assign names to cells.

a. Office Clipboard
b. Formula Documenter
c. Assignment Wizard
d. Name Manager

4. Which of the following will display when you enter .5 in a cell that is formatted as percent?

a. .5%
b. 5%
c. 50%
d. 500%

5. The ___________ function returns the present value of an investment.

a. FV
b. PMT

c. PV
d. INV

6. A(n) ____________ data table allows you to vary the values in two cells.

a. absolute
b. relative
c. mixed
d. two-input

7. ____________ cell references are cells with a dollar sign.

a. Absolute
b. Relative
c. Function
d. Hidden

8. To save toner or ink, instruct Excel to print ____________ documents.

a. draft quality
b. save mode
c. page setup
d. weak print

9. ____________ cells are cells whose values you can change at any time.

a. Non-hidden
b. Open
c. Unprotected
d. Unlocked

10. You can create a(n) ____________ when you want to keep others from changing your worksheet.

a. global format
b. password
c. assumption table
d. sheet button

Name ____________________________
Date ___________________

Excel 2010: Chapter 4 – Short Answer

Instructions: Fill in the best answer.

1. _______________ portions of a worksheet lets you show only parts of the workbook that the user needs to see.

2. _______________ ensures that users do not change values inadvertently that are critical to the worksheet.

3. A cell _______________ often is created from column and row titles.

4. A(n) _______________ function returns the future value of an investment based on periodic, constant payments, and a constant interest rate.

5. A(n) _______________ function calculates the payment for a loan based on the loan amount, constant payments, and a constant interest rate.

6. With a(n) _______________ data table, you can vary the value in one cell in a worksheet.

7. _______________ have one purpose: to organize the answers to what-if questions.

8. A(n) _______________ shows the beginning and ending balances of a loan and the amount of payment that applies to the principal and interest for each year over the life of the loan.

9. A(n) _______________ is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.

10. _______________ are cells that you cannot change.

Name _________________________

Date ___________

Excel 2010: Chapter 4 –

T

rue/

F

alse

Instructions: Circle T if the statement is true or F if the statement is false.

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

1. Excel allows you to format cells before or after you enter data.

2. If you enter the number 25 in a percent formatted cell, Excel interprets the number as 2500%.

3. A cell name can begin with any character.

4. The PMT function has five arguments: rate, payment, interest, recursion, and loan amount.

5. You can double-click a cell with a formula and Excel will use Range Finder to highlight the cells that provide data for the formula.

6. You can create a series by dragging the Series Maker Filler.

7. You can add up to five conditional formats to a range.

8. Even if your printer is a color printer, printing in black and white speeds up the printing process and saves ink.

9. When a workbook is made available to users, they will be able to enter data in only the unprotected cells.

10. You can hide worksheets, but you cannot hide an entire workbook.

Name _________________________

Date ___________

Excel 2010: Chapter 5 – Multiple Choice

Instructions: Circle the correct response.

1. A ____________ is an organized collection of data.

a. cell
b. database
c. formula
d. key

2. A range of blank rows or columns on the side of a table is called a(n) ____________.

a. moat of cells
b. class
c. range line
d. column margin

3. ____________ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

a. Merging
b. Sorting
c. Row banding
d. AutoFilter

4. Excel allows you to refer to the column headings in formulas by placing the column heading in brackets and adding ____ to the beginning of the column name.

a. *
b. @
c. #
d. $

5. A value being looked up outside the range of the table causes the VLOOKUP function to return as error message ___________.

a. 0
b. -1

c. #ERROR#
d. #N/A

6. Excel includes which of the following conditional formats?

a. absolute
b. relative
c. mixed
d. data bars

7. Arranging records in a specific sequence is called ____________.

a. ranging
b. merging
c. sorting
d. keying

8. When Excel sorts, which of the following has the highest priority?

a. Blanks
b. Special characters
c. Text
d. Numbers

9. The query technique that uses the column heading arrows is called ____________.

a. AutoFilter
b. OpenCriterion
c. Name Manager
d. Query Wizard

10. Which of the following operators would you use if you wanted each and every comparison criteria to be true?

a. EACH
b. AND
c. OR
d. ALL

Name ____________________________
Date ___________________

Excel 2010: Chapter 5 – Short Answer

Instructions: Fill in the best answer.

1. A(n) _______________ column is a column in a table in which each row uses a common formula that references other fields in the table.

2. The _______________ function is used when a table direction is horizontal across a worksheet.

3. _______________ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

4. _______________ columns provide alternating colors every other column.

5. The field or fields you select to sort the records are called _______________.

6. The process of filtering activity based on one or more filter criteria is called a(n) _______________.

7. When copying records that meet a comparison criteria range to another part of a worksheet, the location to where the records are copied is called the _______________.

8. Excel’s _______________ function tells you the relative position of an item in a range or table that matches a specified value in a specified order.

9. The _______________ function returns the value or reference of a cell at the intersection of a particular row and column in a table or range.

10. By utilizing the _______________ features of Excel, you quickly can hide and show detail rows.

Name _________________________

Date ___________

Excel 2010: Chapter 5 –

T

rue/

F

alse

Instructions: Circle T if the statement is true or F if the statement is false.

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

1. The individual data items that make up a record are called fields.

2. Excel is considered a true database management system.

3. You can hide columns by selecting them and then pressing CTRL+H.

4. The Conditional Formatting Rules Manager dialog box allows you to view all of the rules for the current selection or for an entire worksheet.

5. Excel allows you to sort on a maximum of 100 fields in a single sort operation.

6. The OR operator indicates that both parts of a criteria must be true.

7. If the criteria range contains a blank row, it means that no comparison criteria have been defined.

8. The Index function can search for values in multiple ranges at the same time.

9. The field on which you sort prior to clicking the Subtotal button is called the Record Range Check field.

10. Items that are dimmed are selections or buttons that are unavailable.

Name _________________________

Date ___________

Excel 2010: Chapter 6 – Multiple Choice

Instructions: Circle the correct response.

1. The process of summarizing data included on multiple worksheets on one worksheet is called ____________ .

a. merging
b. consolidation
c. formula linking
d. format code

2. If a date does not fit in the width of a cell, which of the following will be displayed?

a. ??????
b. ******
c. ######
d. ——–

3. Which of the following represents a linear series?

a. 2, 4, 6, 8, etc.
b. 1, 1, 1, 1, etc.
c. Jan, Feb, Mar, etc.
d. 2, 4, 8, 16, 32, etc.

4. A format code can have which of the following sections?

a. Positive numbers
b. Zeros
c. Text
d. All of the above

5. The ___________ style is the format style that Excel initially assigns to all cells in a workbook.

a. Normal
b. Basic

c. Easy
d. Standard

6. To reference cells in other sheets in a workbook, you use the ___________, which serves as the sheet reference, and the cell reference.

a. absolute link
b. relative link
c. sheet name
d. cell number

7. You can change the ____________ to increase or decrease the white space surrounding the printed worksheet or chart.

a. ranges
b. margins
c. footers
d. headers

8. When pasting, which of the following will copy formulas and format for numbers and formulas of the source area, but not the contents?

a. CTRL+A
b. CTRL+V
c. CTRL+F
d. CTRL+O

9. Excel inserts ____________ that show the boundaries of what will print on each page of the printed workbook.

a. keywords
b. page breaks
c. links
d. format codes

10. A ____________ is a reference to a cell or range of cells in another workbook.

a. style
b. keyword
c. link
d. code

Name ____________________________
Date ___________________

Excel 2010: Chapter 6 – Short Answer

Instructions: Fill in the best answer.

1. _______________ allow you to specify how a cell entry assigned a format will appear.

2. A(n) _______________ multiples values by a constant factor.

3. The _______________ function should be used on formulas that potentially can result in more decimal places than the applied format displays in a given cell.

4. To copy the contents of a cell to the cell directly below it, click in the target cell and press _______________.

5. A(n) _______________ is a series of format symbols that defines how a cell entry assigned a format will appear.

6. A(n) _______________ is a group of format specifications that are assigned to a style name.

7. You can instruct Windows to open a workbook automatically when you turn on your computer by adding the workbook to the _______________ folder.

8. Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is a technique called _______________.

9. A(n) _______________ is a formula that depends on its own value.

10. A(n) _______________ appears at the bottom of every page.

Name _________________________

Date ___________

Excel 2010: Chapter 6 –

T

rue/

F

alse

Instructions: Circle T if the statement is true or F if the statement is false.

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

1. You can select any range of cells with entries surrounded by blank cells by clicking a cell in the range and pressing CTRL+SHIFT+ASTERISK.

2. The result of an arithmetic operation is accurate to the factor with the greatest number of decimal places.

3. If you type 1/2 without a preceding zero, Excel will store the value in the cell as the date January 2.

4. A floating dollar sign always appears immediately to the right of the first significant digit in the cell.

5. Excel limits the number of worksheets you can have in a workbook to 100.

6. Besides drilling a number down through a workbook, you can drill a format, a function, or a formula down through a workbook.

7. If you are summing numbers on noncontiguous sheets, hold down the CTRL key when selecting the sheets.

8. The header defines the appearance and format of a printed worksheet.

9. To copy the contents, format, and styles of the source area, press CTRL+K.

10. By default, the header and footer contain the title and page number.