Computer App - Excel Review

By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.

• True

• False

The fill handle only allows you to copy formulas to one cell below the original formula's cell.

• True

• False

Luisa is creating a worksheet tracking her company's spending on a project. However, when viewing her document, she has noticed some of the cells contain pound signs/hashtags (as shown in the image). Which of the following suggestions would help Luisa?

• Make the cell wider

• Change the font format in the cell

• Change the number formatting in the cell

• Delete the data and retype it

What is an advantage, if any, to using cell references instead of just typing in values?

• It will automatically create a sparkline in the next cell

• If the cell is changed, the formula will automatically update

• It will allow you to format your spreadsheet more quickly

• There is no advantage

Petra placed all of her grades from science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is a quick way for her to do this?

• Page Layout

• Quick Format

• Auto-fit

• Conditional Formatting

Juan is the director of a summer camp. This spreadsheet contains campers' names, information, and their counselors. Which 2 features will help him sort the list by counselor, then print a list containing only the campers' and counselors' names?

• Sort and Track Changes

• Custom Sorting and Formatting

• Format and Hide Columns

• Custom Sorting and Hide Columns

Alex needs to add 3 cells then divide the sum by 4. Which of the following is an example of the correct formula to do this?

• =(A1+A2+A3)/4

• =A1+A2+A3^4

• A1+A2+A3/4

• (A1+A2)+A3/4

Mindy wants to find the average of all of her grades, but cannot get the function to work. Her spreadsheet is shown above. What error is Mindy making?

• She has the incorrect argument

• She is missing an equal sign at the beginning of her formula

• She has the wrong function name

• The colon (:) should be replaced with a dash (-)

When creating a table in Excel, what will clicking the drop-down arrows in the headings allow you to do?

• Fill the columns with color

• Format the cells

• Filter the data

• Hide the column

Which of the following is NOT a type of chart that can be inserted in Excel?

• Pie

• Doughnut

• Circle

• 2-D Bar