1. Every Command in Excel Operates on a Rectangular Group of Cells Known As a (N) ______

Excel Questions

1. Every command in Excel operates on a rectangular group of cells known as a (n) ______.

Ans. range

2. Cell B1 contains the formula =A1*C1. If the formula is copied to cell B2, what will the result in B2 be?

______

Ans. A2*C2

3. Cells F5 and F6 contain the values 10 and 20 respectively. After typing F5+F6 into cell F7 without a beginning equal sign, cell F7 will display

______

Ans. F5+F6

4. To select two non-contiguous (not adjacent) ranges, we use the ______key.

Ans. control

5. Excel has the ability to keep a cell reference constant when it copies a formula or function by ______

Ans. Specifying with a dollar sign in front of the column and row designation

6.In my spread sheet the first four cells in a row 1 contain the values 1, 2, 3, and 4 respectively. If cell B2 contains the formula =$A$1+$B$1 and I copy this formula to cell B4, what value will show in B4?

Ans.3

7. Cell F6 contains the formula =AVERAGE(B6:D6). If the entry in cell F6 is copied to cell F7, then the contents of the cell F7 will be ______

Ans. =AVERAGE(B7:D7)

8. Given that the percentage format is in effect, and that the number 0.056 has been entered into the active cell, then the contents of the cell will appear as ______

Ans.5.6%

9.______format displays a number with the 1000 separator and an optional dollar sign which is placed immediately to the left of the number.

Ans. Currency

10. In the scientific format the number 12345 will appear as ______

Ans.1.2345E+04

11. Commands that are necessary to implement a move are ______

Ans. Cut and paste

12.The PMT function requires three arguments that are the interest rate per period, the number of periods, and ______.

Ans. the amount of loan

13. The preferred function used to total the values contained in a range of cells is ______

Ans. =SUM

14.The syntax of the IF function is:

=IF( ______, ______, ______)

Ans. =IF(logical test, value if true, value if false)

15. ______function returns the number of cells containing a numeric entry, including formulas that evaluate to numeric results.

Ans. COUNT

16. ______function searches for a value in the left most column of a table, and then returns a value in the same row for a column you specify.

Ans. VLOOKUP

17. ______command lets you enter the desired end result of a spreadsheet model (such as monthly payment on a car loan) and determines the input (the price of the car) to produce that result.

Ans. Goal Seek

18. A series of entries such as Monday, Tuesday, Wednesday, etc., is readily entered to the adjacent cells using the ______feature of Excel.

Ans. AutoFill

19. Using ______is the easiest way to create a chart.

Ans. Chart Wizard

19. ______type of chart is best to portray proportion or market share.

Ans. Pie chart

20. ______chart types is not suitable to display multiple data series.

Ans. Pie chart

21. ______is best to display time related information, such as the five-year trend of revenue and profit.

Ans. Line chart

22. When you select a chart, it is surrounded by a border with eight small solid boxes. These are called ______, and may be used to change the ______of a chart.

Ans. Chart area, size

Test Bank - Chapter 1

Introduction to Microsoft Excel:

What is a Spreadsheet?

Chapter Objectives

Describe a spreadsheet and suggest several potential applications; explain how the rows and columns of a spreadsheet are identified, and how its cells are labeled.

Distinguish between a formula and a constant; explain the sue of a predefined function within a formula.
Open an Excel workbook; insert and delete rows and columns of a worksheet; save and print the modified worksheet.
Distinguish between a pull-down menu, a shortcut menu, and a toolbar.
Describe the three-dimensional nature of an Excel workbook; distinguish between a workbook and a worksheet.
Print a worksheet two ways; to show the computed values or the cell formulas.
Use the Page Setup command to print a worksheet with or without gridlines and/or row and columns headings; preview a worksheet before printing.

Multiple Choice

The purpose of a spreadsheet can best be described as

(a) A professor’s grade book

(b) A calculator

(d) None of the above

answer: c

Which of the following may be included in a formula?

(a) Cell references

(b) Functions

(d) All of the above

answer: d

Which statement is true regarding a formula:

(a) It is a combination of numeric constants and cell references

(b) It is a combination of numeric constants, cell references, arithmetic operators and/or functions

(d) It is a combination of numbers and arithmetic operators

answer: b

Which part of the formula =B9/4+(C6*D7) is considered a constant?

(a) B9

(b) 4

(d) D7

answer: b

Which of the following is a false statement about workbooks and worksheets?

(a) A workbook contains one or more worksheets

(b) The Open command references a worksheet rather than a workbook

(d) Cell A1 is a valid reference for every worksheet within a workbook

answer: b

How can you determine that a workbook contains more than one worksheet?

(a) Check the worksheet tabs at the bottom of the window

(b) Check the worksheet tabs at the top of the window

(d) Pull down the View menu

answer: a

How can you tell which cell in a worksheet is the active cell?

(a) It is blinking

(b) It is displayed in reverse video

(d) All of the above

answer: c

How can you change the active cell?

(a) Only by clicking in a different cell

(b) Only by using the arrow keys to move to a different cell

(d) By using the Taskbar

answer: c

Assume that cell C4 contains a formula. Where would you see the formula displayed?

(a) In cell C4

(b) In the formula bar

(d) In the status bar

answer: b

Where is the address of the active cell displayed?

(a) In the Name box to the left of the formula bar

(b) In the status bar at the bottom of the window

(d) All of the above

answer: a

How do you display a Context-sensitive or shortcut menu?

(a) By clicking the Context- Sensitive Menu button on the Standard toolbar

(b) By clicking the Office Assistant button on the Standard toolbar

(d) By clicking the right mouse button on the part of the worksheet for which you want to see a shortcut menu

answer: d

What happens if you point to a cell and click the right mouse button?

(a) The cell contents are erased

(b) The entire row is erased

(d) The Office Assistant tip that relates to the current operation is displayed

answer: c

Which of the following pull-down menus is used to print an Excel workbook?

(a) File

(b) Edit

(d) Window

answer: a

Which of the following commands will save the current workbook so that it is readable in both Excel 97 and 5.0/95 format?

(a) File New

(b) Save

(d) Open

answer: c

Which of the following commands will automatically adjust formulas in the affected cells?

(a) Insert

(b) Delete

(d) Neither Insert nor Delete

answer: c

Which of the following options is changed through the Page Setup command?

(a) Margins

(b) Orientation (portrait or landscape)

(d) All of the above

answer: d

Which command enables you to change the margins and/or orientation for a printed worksheet?

(a) Options

(b) Page Setup

(d) Edit

answer: b

Which of the following worksheet options is controlled through the Page Setup command?

(a) Centering the worksheet horizontally on the page

(b) Printing in landscape mode

(d) All of the above

answer: d

Which of the following is the easiest way to reopen a workbook from the previous session?

(a) Select the worksheet from the appropriate folder using the Open command

(b) Pull down the File menu and select the file from the list at the bottom of the menu

(d) All of these methods open the workbook with equal ease

answer: b

What is the limit on Excel filenames?

(a) 8 characters

(b) 16 characters

(d) 255 characters

answer: d

Which command will erase the contents of cell B10 without changing cell references throughout the rest of the worksheet?

(a) Edit Clear

(b) Edit Delete

(d) Neither Edit Clear nor Edit Delete

answer: a

Which command will delete cell B10 from a worksheet which in turn changes cell references throughout the rest of the worksheet?

(a) Edit Clear

(b) Edit Delete

(d) Neither Edit Clear nor Edit Delete

answer: b

When you move to a button on a Tool bar and a message appears detailing the contents of the button. What is that called?

(a) A tip from Office Assistant

(b) A Screen Tip

(d) Neither of the above

Answer: b

Which of the following is true regarding a printed worksheet?

(a) It may be printed with or without the row and column headings

(b) It may be printed with or without the gridlines

(d) All of the above

answer: d

The purpose of Office Assistant is to

(a) Place a button on the Standard Toolbar which allows you to ask questions

(b) Answer questions

(d) All of the above

Answer: d

Office Assistant can be found

(a) In the Tools menu

(b) On the Formatting Toolbar

(d) Under the Insert menu

Answer : c

What happens if you press the Ctrl+` key combination given that the displayed values for each cell are shown in the worksheet?

(a) The worksheet formulas are displayed

(b) A new column is inserted in the worksheet

(d) A duplicate worksheet is created in the workbook

answer: a

A worksheet currently displays the cell contents rather than the displayed (computed) values of each cell. Which keystroke combination will change from the cell contents to the displayed values?

(a) Ctrl+`

(b) Ctrl+F

(d) None of the above

answer: a

What happens if you press the Ctrl+` keystroke combination twice in a row?

(a) The worksheet shows the displayed (computed) values in each cell

(b) The worksheet shows the cell contents for each cell

(c) There is no visual change since Ctrl+` functions as a toggle switch to alternate between the displayed values and cell contents

(d) The answer is impossible to determine from the information given

answer: c

Which of the following actions will increase the column width of column B to fit the widest entry?

(a) Click the border between columns A and B

(b) Double click the border between columns A and B

(d) Double click the border between columns B and C

answer: d

What happens if you double click the border between columns C and D?

(a) Column C is hidden

(b) Column D is hidden

(d) The width of column D is changed to accommodate the widest entry in that column

answer: c

Which of the following actions will display the cell formulas in a worksheet?

(a) Double click the border between any two columns

(b) Select Unhide from the shortcut menu

(d) None of the above

answer: d

A cell at the intersection of the first row and third column has the cell reference

(a) A3

(b) 3A

(d) 1C

answer: c

The formula =B3+C4 is stored in cell D5. What will the formula be if a row is inserted above the second row in the worksheet?

(a) =B3+C4

(b) =B4+C5

(d) =B2+C3

answer: b

The formula =B3+C4 is stored in cell D5. You wish to change the formula to =(B3 + C4)/2. How do you best do that?

(a) Reenter the entire formula in D5

(b) Choose Edit Delete and reenter correctly

(d) Click on the Formula bar, edit and hit enter

answer: d

The cell contents of B3 and B4 are 4 and 5 respectively. What will be displayed in cell B5 if you enter the characters =B3+B4 in cell B5 and then press the enter key?

(a) B3+B4

(b) =B3+B4

(d) It is not possible to determine from the information given

answer: c

Which of the following is a valid Excel formula?

(a) =C4*D4

(b) C4*D4

(d) Neither =C4*D4 nor C4*D4

answer: a

Which command in which menu enables you to display the row and column headings when printing a worksheet?

(a) View command in the Print menu

(b) View command in the File menu