ACIS 1504 chapter 2 HW 1

Each worksheet in an excel workbook can hold a maximum of how many rows of data?

1,048,576 rows

When using the insert sheet rows command a blank row will be added ________ the activated cell

above

If the pound signs (###) appear in a cell location, which of the following is true?

The column width needs to be increased

Which of the following is true when working with an excel worksheet that was created by another person?

a data audit must be conducted before using an excel worksheet that was created by another person

After highlighting a range of cells, holding the CTRL key and tapping the X key on your keyboard will do which of the following?

cut the data in the highlighted range

The mouse pointer will turn into a black plus sign when it is dragged over the -

fill handle

The row numbers along the left side of a worksheet are as follows: 1 2 4 5 6. This indicates that row 3 is -

hidden

When entering numeric data into an excel worksheet, you should omit any symbols such as commas or dollar signs because -

it slows down the data entry process

When using the insert sheet columns command a blank column will be inserted to the ___________ of the activated cell

left

If the delete sheet command is used to delete a worksheet that contains data, what will happen if the undo command is used?

nothing will happen. The undo command will not restore the worksheet once it is deleted using the delete sheet command

The formula bar is located towards the top and the status bar is located towards the bottom of the excel worksheet

true