Functions
1.05-Q13: The location for the Insert Function button found in Microsoft Excel?
What is In the Formula Bar
1.08-Q11: John would like to remove a worksheet from his workbook. This is the option he chose.
What is Delete
1.06-Q6: Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. This alignment option should be selected?
What is Merge and Center
1.09-Q2: Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. This formatting style should be selected?
What is Format as Table
1.12-Q4: The ribbon that contains the commands for creating charts in Microsoft Excel?
What is Insert
1.05-Q8: Amanda has created a spreadsheet containing test grades for the first nine weeks. She used this function to estimate the grade on her next test?
What is the AVERAGE Function
1.08-Q6: Do this to move sheet tabs to a new position in the workbook?
What is Click and drag the sheet tab to the new location
1.06-Q2: This type of formatting appears only when the value in a cell meets conditions specified by a user?
What is Conditional Formatting
1.09-Q9: Apply this to be able to put the spreadsheet in alphabetical order by last name.
What is a Sort
1.12-Q15: Edward used this chart to show the trend in iPod sales over the past 2 years.
What is a Line Chart
1.05-Q7: The function used to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
What is the TODAY Function
1.03-Q4: John's workbook includes 3 worksheets. This option would allow him to print all of them?
What is Print Entire Workbook
1.06-Q7: This command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
What is Orientation
1.09-Q12: Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. She chose this sorting option?
What is Ascending
1.12-Q3: John used these to identify the exact value that each column in his chart represents.
what is Data Labels
1.10-Q6: Jill used this function to search her spreadsheet for a value in the first column of her table. ?
What is the VLOOKUP Function
1.02-Q4: The name of the list of frequently used Excel commands available when a user rightclicks an item in the worksheet?
What is the Shortcut Menu
1.06-Q17: The number style, other than currency, from the drop-down menu that formats numbers to display as currency in the worksheet?
What is Accounting
1.09-Q15: Joan has created a spreadsheet that displays sales of her employees. This allowed her to view only those employees with sales above $25,000 who are from Region 3.
What is a Custom Filter
1.12-Q23: This is the purpose of the /+ buttons that appear across the categories on a PivotTable?
What is Collapse and Expand
1.10-Q9: Jamal used this function to average a range of cells in his spreadsheet. He needed Excel to average only the cells in that range that are greater than 100 but less than 500.
What is the AVERAGEIFS Function
1.02-Q8: The Microsoft Excel feature that automatically inserts data into a cell that begins with the same characters as a previous entry?
What is AutoComplete
1.06-Q23: Carl notices that the data in cell E4 reads #######. He used this command to correct this problem?
What is AutoFit
1.09-Q13: Dylan is creating an Excel spreadsheet to organize all FBLA members based on their school schedules. He would like to know how many members are in the same first-period class. This feature would allow him to do this fast and easy?
What is Subtotal
1.12-Q31: The name of an interactive graphical representation of data that allows a user to change the groupings?
What is a PivotChart