Use Font in Formatting bar

How can we insert numberings in MS Word?

Formatting bar > Numbering

How could you add a password to an existing PowerPoint presentation?

Select File>Properties, select the Security tab and enter the password

How do you add a needed panel in MS Office applications?

View->Toolbars

How many cells are included in the function =SUM(A1:C5)

15;

How would you import a presentation from PowerPoint 2.0 into PowerPoint 2002?

Open the file and PowerPoint 2002 will automatically convert it

In a Word document when the last line of a paragraph is printed by itself at the top of the page it is known as a/an ______________.

Widow

In 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

In Word, pressing the End key in a block of text does which of the following?

Moves the cursor to the end of the line

Information systems can be described as:

Organizational and management solutions to problems posed by the environment;

MS Access: A select query:

Retrieves data from one or more tables and displays the results in a datasheet;

MS Access: An action query is a query that:

Makes changes to or moves many records in just one operation;

MS Access: Datasheet view: is a windows that displays data from ______:

A table, form, query, view, or stored procedure in a row-and-column format;

MS Access: You can use the navigation toolbar to ___________:

Move through the records in a datasheet;

MS Excel: _____________________ is a command that lets you change your worksheet?s appearance by selecting from a collection of predesigned worksheet formats.

AutoFormat;

MS Excel: A formula containing the entry =$A$4 is copied to a cell one column over and two rows down. How will the entry appear in its new locations?

Neither the row nor column will change;

MS Excel: Cell F6 contains the formula =AVERAGE(B6:D6). What will be the contents of cell F7 if the entry in cell F6 is copied to cell F7?

=AVERAGE(B7:D7);

MS Excel: Determine which kind of sequence is true by default for the given cell entries =SUM(B6:B10); 56; profit, respectively

Formula, number, text;

MS Excel: Given that cells B6, C6 and D6 contains the numbers 10, 20 and 30, respectively, what value will be returned by function =IF(B6>10;C6*2;D6*3)?

90;

MS Excel: How can you enter a comment into a cell?

Right click in the cell, then select the Insert Comment command;

MS Excel: How many cells are chosen, if range C5:D10 is selected in MS Excel:

12.

MS Excel: In MS Excel the entering of ______ starts from sign ?=?:

Formula;

MS Excel: Let A=25 and B=125. What does the function ?=IF(A*5<B;?Profit?;?Loss?)? return?

Loss;

MS Excel: The cell at the intersection of the second column and third row has the cell reference:

B3;

MS Excel: The reference CIS120!$A$2:

Is an absolute reference to cell A2 in the CIS120 worksheet;

MS Excel: To combine two adjacent cells we use

Format/Cells menu;

MS Excel: What is a base element of spreadsheet?

Cell;

MS Excel: What is the effect of typing F5+F6 into cell without a beginning equal sign?

The entry will be treated as a text entry and display F5+F6 in the cell;

MS Excel: Which function key change the cell reference type from relative to absolute?

F4;

MS Excel: Which of the following is done prior to invoking the Chart Wizard?

Date: 2016-06-12; view: 411