Flash Cards (current)
Games
Teachers

Excel Project 2 Continued

Test Description: Modifying a Worksheet in Excel

Instructions: Answer all questions to get your test result.

1) A function is a predefined range.

AFalse BTrue

2) An indicator that you already have the file open is that a border surrounds the selected filename in the Open dialog box.

AFalse BTrue

3) If cells A1 through A5 contain numbers one through five respectively, and you drag the fill handle from A5 through A50, the cells A5 through A50 will contain

Aall sixes Ball fives C one through five in A6 throue A10, then one through five, in A11 through A15 and one through five in A16 through A20 and so Dsix through 50

4) The default when inserting a row or column is

Athe row is inserted below; the column to the right Bthe row is inserted above; the column to the right Cthe row is inserted below; the column to the left Dthe row is inserted above; the column to the left

5) To select non-adjacent cells, click the first cell then press and hold

Ashift and click additional cells Bthe down arrow key and click additional cells CCtrl and click additional cells DAlt and click additional cells

6) Which of the following could be considered a cell range?

AA single cell BA group of cells in the same row CAll three of the the other answers DA group of cells in the same column

7) A white arrow with a four-headed black arrow attached indicates that you can?

AInsert one or more rows BCopy cell contents by dragging CMove cell contents by dragging DNone of the other answers

8) What happens when you right click on a select cell range?

AA shortcut menu appears BThe cell range is deselected CNone of the other answers DThe contents of the cell range are copied

9) Using Excel's ___________ feature, you can easily fill in a series of numbers, dates, or other items in a specified range.

AAutoSum BAutoComplete CAutoMatically DAutoFill

10) Cell B4 contains the number 10. What will be contained in cell B5 if you select B4 and use the fill handle to drag to B5

A15 Bnone of the other answers C10 D20

*select an answer for all questions

Play Games with the Questions Above

WAIT! Find what you needed?

Still Looking for the Answers? Have Another Question? Play a Review Game with These Questions? Want to Make Your Own Test Like This One?