Excel 2013 notes

Which of these formulas will add three cells and then divide the sum by 4?

=(A1+A2+A3)/4

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

Conditional Formatting

Which two features will help him sort the list by counselor, and then print out a list containing only the campers' and counselors' names?

Custom Sorting and Hide Columns

While reviewing her worksheet, Megan noticed she had made a mistake in several places and used the color name "burgundy" when she should have used "maroon". Which feature will allow her to correct her mistake the fastest?

Find and replace

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

If the cell is changed, your formula will automatically update

True or false: In order to reference a cell from a different worksheet, you must copy and paste that cell into the current worksheet.

false

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

filter the data

What is the difference between formatting your spreadsheet as a table and creating a PivotTable?

formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet

Which feature will allow you to calculate the goal you want to reach?

goal seek

Which orientation is best for displaying a very wide chart?

landscape

What is a good suggestion when there is pound signs in a cell?

make the cell wider

Charles is creating a spreadsheet for work. Each time he opens Excel, he wants to be able to find the file quickly without having to browse for it. Which of the following options would you recommend to Charles?

pin the file to his back stage view

What is the purpose of the Document Inspector?

to inspect the document for hidden properties and personal information

True or false: Any changes made to an Excel document can be tracked in a separate worksheet.

true

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

true

True or false: Grouping worksheets allows the user to make changes to several worksheets at once.

true

True or false: Sparklines are tiny charts that fit into one cell.

true

What do you have to add in the beginning of a formula for it to function?

you have to add an equal sign before the formula