Accounting Spreadsheet Fundamentals Lesson 8

Question 1 of 20

5.0 Points

To enter a number as text, you should precede it with:

A. a comma.

B. a period.

C. a parenthesis.

D. an apostrophe.

Question 2 of 20

5.0 Points

The shortcut for Repeat is:

A. Ctrl+Y.

B. Ctrl+R.

C. Ctrl+N.

D. Ctrl+H.

Question 3 of 20

5.0 Points

The first thing you must do when entering a formula is:

A. Start the formula with an equal sign.

B. Select the cell where the formula is to be located.

C. Type the formula.

D. Click the Enter box or press the ENTER key.

Question 4 of 20

5.0 Points

Which of the following CANNOT be used to exit Microsoft Excel?

A. Ctrl+Z

B. keyboard

C. arrow keys

D. mouse

Question 5 of 20

5.0 Points

The sum of cells E2, E3, E4, and E5 may be found by typing any of the formulas below EXCEPT:

A. (E2,E3,E4,E5).

B. (E2-E5).

C. (E2:E5).

D. =(E2+E3+E4+E5).

Question 6 of 20

5.0 Points

The shortcut Ctrl+A means:

A. Copy.

B. Select All.

C. New Workbook.

D. Undo.

Question 7 of 20

5.0 Points

__________ is the shortcut for the Repeat command.

A. Ctrl+H

B. Ctrl+Y

C. Ctrl+R

D. Ctrl+P

Question 8 of 20

5.0 Points

The shortcut Ctrl+K means:

A. Repeat.

B. Cut.

C. Insert Hyperlink.

D. New Workbook.

Question 9 of 20

5.0 Points

__________ an object deletes the data from the original area and transfers it to the new area.

A. Resizing

B. Copying

C. Deleting

D. Moving

Question 10 of 20

5.0 Points

A file may be saved by pressing:

A. Ctrl+V.

B. Ctrl+C.

C. Ctrl+S.

D. Ctrl+N.

Question 11 of 20

5.0 Points

To Cancel a Formula after pressing the ENTER key:

A. press ESC.

B. select Cancel from the Edit menu.

C. click the Cancel box.

D. click the Undo button on the Toolbar.

Question 12 of 20

5.0 Points

Which of the following numerical formats is appropriate for showing a total on a financial statement?

A. general

B. accounting

C. date

D. percentage

Question 13 of 20

5.0 Points

Using either the Toolbar or the __________ saves the worksheet.

A. Shortcut list

B. Menu bar

C. Enter box

D. Confirm box

Question 14 of 20

5.0 Points

A __________ works the same way that a formula does.

A. function

B. calculation

C. command

D. shortcut

Question 15 of 20

5.0 Points

The shortcut Ctrl+W means:

A. Close.

B. Cut.

C. Undo.

D. New Workbook.

Question 16 of 20

5.0 Points

The result of the __________ will change when values in the worksheet change.

A. calculations

B. numeric entries

C. formula

D. data

Question 17 of 20

5.0 Points

__________ is the shortcut for the Cut command.

A. Ctrl+X

B. Ctrl+C

C. Ctrl+H

D. Ctrl+T

Question 18 of 20

5.0 Points

The __________ has several shortcuts for changing the appearance of data.

A. Shortcut list

B. Menu bar

C. Toolbar

D. Title bar

Question 19 of 20

5.0 Points

Using the __________ icon saves the worksheet.

A. clipboard

B. underlined U

C. paintbrush

D. diskette

Question 20 of 20

5.0 Points

The power of Excel is the ability to create and use formulas, which can be very long and complex. To simplify this process, Excel has some built-in formulas called:

A. functions.

B. syntaxes.

C. commands.

D. mathematical operators.

Accounting Spreadsheet Fundamentals Lesson 8 Question 1 of 20 5.0 Points To enter a number as text, you should precede it with: A. a comma. B. a period. C. a parenthesis. D. an apostrophe. Question 2 of 20 5.0 Points The shortcut for Repeat is: A. Ctrl+Y. B. Ctrl+R. C. Ctrl+N. D. Ctrl+H. Question 3 of 20 5.0 Points The first thing you must do when entering a formula is: A. Start the formula with an equal sign. B. Select the cell where the formula is to be located. C. Type the formula. D. Click the Enter box or press the ENTER key. Question 4 of 20 5.0 Points Which of the following CANNOT be used to exit Microsoft Excel? A. Ctrl+Z B. keyboard C. arrow keys D. mouse Question 5 of 20 5.0 Points The sum of cells E2, E3, E4, and E5 may be found by typing any of the formulas below EXCEPT: A. =SUM(E2,E3,E4,E5). B. =SUM(E2-E5). C. =SUM(E2:E5). D. =(E2+E3+E4+E5). Question 6 of 20 5.0 Points The shortcut Ctrl+A means: A. Copy. B. Select All. C. New Workbook. D. Undo. Question 7 of 20 5.0 Points __________ is the shortcut for the Repeat command. A. Ctrl+H B. Ctrl+Y C. Ctrl+R D. Ctrl+P Question 8 of 20 5.0 Points The shortcut Ctrl+K means: A. Repeat. B. Cut. C. Insert Hyperlink. D. New Workbook. Question 9 of 20 5.0 Points __________ an object deletes the data from the original area and transfers it to the new area. A. Resizing B. Copying C. Deleting D. Moving Question 10 of 20 5.0 Points A file may be saved by pressing: A. Ctrl+V. B. Ctrl+C. C. Ctrl+S. D. Ctrl+N. Question 11 of 20 5.0 Points To Cancel a Formula after pressing the ENTER key: A. press ESC. B. select Cancel from the Edit menu. C. click the Cancel box. D. click the Undo button on the Toolbar. Question 12 of 20 5.0 Points Which of the following numerical formats is appropriate for showing a total on a financial statement? A. general B. accounting C. date D. percentage Question 13 of 20 5.0 Points Using either the Toolbar or the __________ saves the worksheet. A. Shortcut list B. Menu bar C. Enter box D. Confirm box Question 14 of 20 5.0 Points A __________ works the same way that a formula does. A. function B. calculation C. command D. shortcut Question 15 of 20 5.0 Points The shortcut Ctrl+W means: A. Close. B. Cut. C. Undo. D. New Workbook. Question 16 of 20 5.0 Points The result of the __________ will change when values in the worksheet change. A. calculations B. numeric entries C. formula D. data Question 17 of 20 5.0 Points __________ is the shortcut for the Cut command. A. Ctrl+X B. Ctrl+C C. Ctrl+H D. Ctrl+T Question 18 of 20 5.0 Points The __________ has several shortcuts for changing the appearance of data. A. Shortcut list B. Menu bar C. Toolbar D. Title bar Question 19 of 20 5.0 Points Using the __________ icon saves the worksheet. A. clipboard B. underlined U C. paintbrush D. diskette Question 20 of 20 5.0 Points The power of Excel is the ability to create and use formulas, which can be very long and complex. To simplify this process, Excel has some built-in formulas called: A. functions. B. syntaxes. C. commands. D. mathematical operators