FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Joan has created a spreadsheet that displays the sales of her employees. She would like to view only those employees with sales above $25, 000. How can she do this?

A	Sort ascending
B	Sort descending
C	Custom sort
D	Filter to show only $25, 000 or above with a number filter

Explanation:

Detailed explanation-1: -The name box is the box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells.

Detailed explanation-2: -What is the process of bringing data containing text fields separated by commas into Excel called? Importing data.

Detailed explanation-3: -Select the Review tab, and then, in the Proofing section, select Workbook Statistics. You can also press CTRL+SHIFT+G. (Note that the CTRL+SHIFT+G shortcut won’t work in Excel for the web.) The Workbook Statistics dialog opens and displays counts and other information about the current worksheet and workbook.

There is 1 question to complete.