Excel 2010
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?
=(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. How can she do this easily?
Conditional Formatting
Jun is the director of a summer camp. He has a spreadsheet that contains campers' names, information, and their counselors. Which two features will help him sort the list by counselors, and then print out a list containing only the campers' and counselors' names?
Custom Sorting and Hide columns
The Subtotals command adds numbers in a designated column.
False
The fill handle only allows you to copy formulas to several different cells.
False
When creating a table in Excel, what will clicking the drop down arrows in the heading allow you to do?
Filter the data
What are Advanced Text Filters used for?
Filtering cells that meet very specific requirements
Which of the following best explains 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.
Lauren currently has each month's sales entered into a spreadsheet. She wants to know what she will need to sell in the month of June in order to meet her quarterly average sales goal of $40,000.Which of the following features will allow her to easily calculate what she would need to make in June?
GoalSeek
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.
What should you do when your cells are full of pound signs?
Make the cell wider
What are predesigned spreadsheets called and where can they be found?
Templates; Backstage view
What is the purpose of the Document Inspector?
To inspect the document for hidden properties and personal information
Any changes made to an Excel document can be tracked in a separate worksheet.
True
By Default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes
True
Grouping worksheets will allow the user to make changes to several worksheets at once.
True
Sparklines are tiny charts that fit into one cell.
True
