The Basics of EXCEL PART 2

Question 1

In Excel, each cell has its own name or __________.

Answer 1

CELL ADRESS

Question 2

Another way to cut and paste the contents of a cell or cells is to drag and _____.

Answer 2

DROP

Question 3

The Increase/Decrease Decimal commands don’t work with Date formats.

Answer 3

TRUE

Question 4

To change the column width, you can position your mouse over the column line in the column heading, drag or double click. In addition, you can AutoFit one or more columns by selecting AutoFit Column Width from the __________ drop-down menu on the Home Tab.

Answer 4

FORMAT

Question 5

If you type November into a cell, the spreadsheet will know you are entering a date so it will treat it like a date formatted cell.

Answer 5

FALSE

Question 6

When inserting a row, the new row will appear above the selected row.

Answer 6

TRUE

Question 7

The Merge Cells command merges the selected cells into one cell and centers the text.

Answer 7

FALSE

Question 8

To modify all rows or columns at the same time, click the _ button located just below the name box to select every cell in the worksheet.

Answer 8

SELECT ALL

Question 9

In Excel, columns are identified by numbers.

Answer 9

FALSE

Question 10

The Increase Decimal command button has an arrow pointing left.

Answer 10

TRUE

Question 11

The keyboard’s short-cut to paste data.

Answer 11

CRTL + V

Question 12

The intersection of a row and a column.

Answer 12

CELL

Question 13

If you type a percent sign (%) after a number, the percentage number format will be applied to that cell automatically.

Answer 13

TRUE

Question 14

The Wrap Text command is located in the Alignment group on the _ tab.

Answer 14

HOME

Question 15

With numerical data, the cell will display _ if the column is too narrow.

Answer 15

POUND SIGNS

Question 16

When inserting a column, the new column will appear _______ the selected column.

Answer 16

TO THE LEFT OF

Question 17

The keyboard short-cut to Cut.

Answer 17

CRTL + X

Question 18

To access other date formatting options, select the ________ drop-down menu and choose More Number Formats.

Answer 18

NUMBER FORMAT

Question 19

To delete contents from a cell you can use the delete key or select ________ on the the Home tab.

Answer 19

CLEAR

Question 20

To unhide columns you must first _________.

Answer 20

SELCET THE COLUMNS TO THE RIGHT AND TO THE LEFT OF THE HIDDEN COLUMNS

Question 21

Cells is a range a separated by a semi-colon.

Answer 21

FALSE

Question 22

The Fill handle looks like _________.

Answer 22

A BLACK PLUS SIGN

Question 23

A cell’s location will also appear in the ________ in Excel.

Answer 23

NAME BOX

Question 24

There is no difference between deleting a row or column and deleting its contents.

Answer 24

FALSE