Joan has created a spreadsheet that displays sales of her employees.She would like to view only those employees with sales above 25,000 who are from region 3.what option will allow her to do that?
custom filter
100
Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top.Which sorting option should she choose?
ascending
100
David wants to arrange the employee salaries in column A of his spreadsheet from lowest to highest.What command should he use to complete this task?
sort
100
David only wants to view the employees in the marketing department who earn a salary of more than $25,000.What command should he use to complete this task?
Filter
100
Which ribbon includes the commands to apply a quick table style to a range of cells?
Home
200
What home ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
Styles
200
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Query
200
Which command on the home Ribbon do you use to organize data in ascending or descending order?
sort&filter
200
What is the process of bringing data containing text fields separated by commas into excel?
Importing data
200
How do you quickly modify a table style to meet user preferences?
Right-click on a style and choose duplicate
300
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
sort&filter
300
Trey would like to apply a rule to the data in cell range a1:f20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text.Which formatting style should he select?
Conditional&formatting
300
Which group on the formulas Ribbon contains the common errors found in a formula?
Formulate Auditing
300
What command limits structural changes,such as adding ,deleting,or moving sheets,that can be made in a workbook?
Protect Workbook
300
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
Review
400
In a worksheet,which command suggests other words with a similar meaning that can be used?
Thesaurus
400
Where is the spellchecker located?
Review Ribbon
400
Which command on the page layout Ribbon enables a user to flip objects on a worksheet
Rotate
400
Which command on the page layout Ribbon enables a user to flip objects on a worksheet?
Clip Art
400
Which command on the insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
Screen Clipping
500
Which command on the insert Ribbon enables a user to insert a picture of a program window into a worksheet
screenshot
500
Which command creates decorative text in a worksheet?
WordArt
500
Which tab in the pivotchart tools Ribbon allows a user to apply chart titles to the pivotchart?
Layout
500
Which tab in the pivotchart tools Ribbon allows a user to apply a chart style to the pivotchart?
Design
500
In order to directly report the data,what must a Pivotchart always be associated with?