FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
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?
A
AutoFill
B
Filter
C
Find and Replace
D
Sort
Explanation: 

Detailed explanation-1: -Select View > View Side by Side. If you scroll up or down, the other scrolls as well. If you want them to scroll separately, select Synchronous Scrolling to turn it off.

Detailed explanation-2: -The Ribbon contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.

Detailed explanation-3: -What method is the most common way to select multiple cells? Click and drag.

There is 1 question to complete.