Flash Cards (current)
Games
Teachers

Excel Project 2

Test Description: Modifying a Worksheet in Excel

Instructions: Answer all questions to get your test result.

1) If cell A1 contains 41, A2 contains 63, adn A3 displays 104, which of the following diplays in the Formula bar for cell A3?

AA1+A2 B=A1+A2 C=SUM(A1+A2) Dboth =A1+A2 and =SUM(A1+A2) are correct

2) Several adjacent cells selected are called a

Acolumn Brange Crow Dgroup

3) A menu that pops up in the worksheet area and displays common commands is called a

Apopup menu Bdialog box Cshortcut menu Dtoolbar

4) If you click Ignore on a misspelled item, the spell check will

Aallow you to undo the last change Bleave the word spelled incorrectly Cdisplay the word the next time spelling is checked Dwill add the word to AutoCorrect

5) After a copy operation, the selected cell contents appear

Aonly in the new location Bin the original location Cboth in the original location and in the new location are correct Din the new location

6) AutoSum evaluates above and to the left of the

Arow Badjacent cell Ccolumn Dcurrent cell

7) The Select All button selects the entire worksheet.

AFalse BTrue

8) To delete a column, click in the column and press the Delete key.

ATrue BFalse

9) The spelling check highlights the first occurrence of a word not found in its dictionary.

AFalse BTrue

10) Copying and moving cells is a four-step process.

ATrue BFalse

*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?