Excel Construction Comp 100

Front 1

What is the first step in creating an effective work sheet?

Back 1

Understanding what is required

Front 2

To enter datain a cell, you must first select the___________

Back 2

Cell

Front 3

___________is/are used to place a work sheet, column, and row titles on a work sheet

Back 3

Text

Front 4

Clicking the____________ box completes an entry

Back 4

Enter

Front 5

The ___________is a blinking vertical line that indicates where the next typed character will appear.

Back 5

Insertion point

Front 6

The ______ feature works behind the scenes , fixing common typing or spelling mistakes when you complete a text entry.

Back 6

Auto correct

Front 7

Pressing the__________key to complete an entry activates the adjacent cell to the right

Back 7

Right arrow

Front 8

By default text is _______ placed in a cell

Back 8

Left alligned

Hint 8

Aligned

Front 9

In excel a number can contain character's $ - ( * )% 1 234567890 /

Back 9

Yes all

Front 10

The range of cells receiving copied content is called the _________ area

Back 10

Paste

Front 11

True or false: Both the cancel box and enter box appear on the formulas bar when you begin typing a cell.

Back 11

True

Front 12

The auto correct feature can automatically capitalize the first letters in the names of days. True or false?

Back 12

True

Front 13

True or false. When text is longer then the width of a column, Excel displays the over flow charactors in an adjacent cells to the right, as long as those cells contain no data.

Back 13

True

Front 14

True or false: When entering dollar vaules in a cell you must also type the dollar $ sign, commas and any trailing zeros?

Back 14

False

Front 15

True or false: you can turn off Bold formatting for selected text by clucking the roman button ( home tab/ font group)

Back 15

False

Front 16

True or false: If a major error is made when typing data into a cell, tap or click the cancle box in the formula bar or press the esc key to erase the entire entry, then re_enter data?

Back 16

True

Front 17

TRUE OR FALSE: With excel in edit mode you can edit a cell contents directly in a cell

Back 17

True

Front 18

TRUE OR FALSE: To clear an entire work sheet, tap or click the clear all button on the work sheet

Back 18

False

Front 19

True or false: you can clear contents and formatting by tappi g or clicking clear contents on the clear button menu.

Back 19

True

Front 20

TRUE OR FALSE: You should press the space bar to clear a cell?

Back 20

FALSE