USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
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?
|
|
Ascending
|
|
|
Descending
|
|
|
Filter
|
|
|
Custom Filter
|
Explanation:
Detailed explanation-1: -Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.
Detailed explanation-2: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-3: -Add numbers using cell references Type a number, such as 5, in cell C1. Then type another number, such as 3, in D1. In cell E1, type an equal sign (=) to start the formula. After the equal sign, type C1+D1.
There is 1 question to complete.