Office Applications

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

• IF

• AND

• OR

• NOT

A function inside another function is called a ….. function.

• Nested

• Round

• Sum

• Text

Which of the following methods can not be used to enter data in a cell?

• Pressing an arrow key

• Pressing the tab key

• Pressing the Esc key

• Clicking the enter button to the formula bar

Which command will you choose to convert a column of data into row?

• Cut and Paste

• Edit >> Paste Special >> Transpose

• Both of above

• None of above

You can auto fit the width of column by

• double clicking on the column name on column header

• Double click on the cell pointer in worksheet

• Double clicking on column right border on column header

• Double clicking on the column left border of column header

Long text can be broken down into many lines within a cell. You can do this through

• Wrap Text in Format >> Cells

• Justify in Edit >> Cells

• Text Wraping in Format >> Cells, Layout tab

• All of above

The short cut key Ctrl + R is used in Excel to

• Right align the content of cell

• Remove the cell contents of selected cells

• Fill the selection with active cells to the right

• None of above

To remove the content of selected cells you must issue ______ command

• Edit >> Delete

• Edit >> Clear >> Contents

• Edit >> Clear >> All

• Data >> Delete

Which file format can be added to a PowerPoint show?

• .jpg

• .gif

• .wav

• All of the above

In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are

• .wav files and .mid files

• .wav files and .gif files

• .wav files and .jpg files

• .jpg files and .gif files