Select Sort from the Data menu

There is no way to open it

Access. In what brackets must the parameter of the parameterized query be taken?

[ ]

Access. To set a password on a database, you must:

Open the database in an Exclusive mode, and then follow the steps in (a)

Access. Which Access database object selects records from one or more tables for viewing and analysis on a single datasheet?

Query

Access. Which of the following Access toolbar buttons would you use to perform a filter using the current selection?

Answer:

Access. Which of the following statements is true of an Access 2002 table?

A table can contain a single primary key and multiple indexes.

colon in the notation B6:B9 indicates a(n)_________?

Range.

computer-based information system relies on computer hardware and software for:

Processing and disseminating information.

COUNT function serves which of the following purposes in Excel?

Gives the total value of all the integers combined in the selection.

During a PowerPoint 2002 slide show which of the following is not available as a pointer option?

Cursor

defines the structure of the network.

Topology;

Excel. Which of the following symbols is used to represent division in a formula?

/

Excel. A workbook must contain:

All answers are wrong

Excel. After performing an ascending sort on a column of numbers where would the smallest numbers be located?

At the top

Excel. Cells from A1 to A12 contain the revenues of twelve branches of a company respectively for the first quarter; cells B1 to ?

You place =A1+B1 into C1, and use autofill to fill with similar formulas cells till C12.

Excel. Cells in column A contain the salaries of bank workers in tenge, and the cell D1 contains the current dollar rate (how much ...

You type =A1/$D$1 into B1, and use autofill for the rest cells in column B

Excel. How do numbers and text appear in the MS Excel cells by default?

Numbers to the right, text to the left of the cell

Excel. If in the range of =counta(range) and =count(range), there are 15 cells, out of which 5 contain text, 5 numbers, and the rest ?

10 , 5

Excel. If the conditional formatting pictured in the figure below is applied to a cell with the value 0 what will be the result?

The conditional format will have no effect

Excel. Pressing which of the following keys/key combinations in an Excel spreadsheet would move the cursor one cell to the left?

Shift-Tab

Excel. Pressing which of the following keys/key combinations would move the cursor one cell to the left?

Ctrl-Tab

Excel. Pressing which of the following keys/key combinations would move the cursor one cell to the right?

Tab

Excel. The print dialog box allows you to do which of the following?

All of these

Excel. To sort data using multiple columns what action must be performed?

Select Sort from the Data menu

Excel. VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Given that the lookup_value is not smaller than the smallest value in the table_array, if

Date: 2016-06-12; view: 179