ACCT 186

What is another name for an Excel file?

• folder

• tab

• workbook

• worksheet

You can reverse to up 100 of your last actions in Excel. What keystroke should you use?

• Ctrl + Z

• Ctrl + C

• Ctrl + V

• Alt + C

What does the concatenate function do?

• sums up the cells

• averages the cells

• merges the cells keeping only the first cell's contents

• joins two cells together

What tab would you protect a worksheet so that it cannot be edited?

• Home

• Review

• Insert

• Data

What tab would you insert a chart ?

• Home

• Review

• Insert

• Data

Excel CAN NOT hold what type of information?

• a paper file

• a numeric value

• a formula

• an error

What function would you use to find a payment on a mortgage?

• =mortgage()

• =loan()

• =pmt()

• =pay()

If you push the shortcut "Control + b" what will happen?

• the cell will be bolded

• the cell will be italicized

• the cell will be strikethrough text

• the cell will be underlined

If you push the shortcut "Control + tab" or "alt + tab" what will happen?

• the cell will be bolded

• you will cycle through open Excel windows

• you will close the workbook

• you will select the whole row

To highlight cells that are greater than the average, what feature should I use?

• Page layout settings

• Protect sheet

• Conditional formatting

• Find and select