MS EXCEL QUIZ | EXAMIANS

Which of the following methods cannot be used to enter data in a cell

Pressing the Esc key

Pressing the Tab key

Pressing an arrow key

Clicking on the formula bar

TRUE ANSWER : ?
YOUR ANSWER : ?

When the formula bar is active, you can see

The enter button

All of these

The edit formula button

The cancel button

TRUE ANSWER : ?
YOUR ANSWER : ?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?

Press Home

Press Alt + Home

Press Shift + Home

Press Ctrl + Home

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is invalid statement?

The width of a row and be specified manually or fit automatically

You can set the column width automatically fit the amount of text

Sheet tabs can be colored

Some picture can be applied as a background of a sheet

TRUE ANSWER : ?
YOUR ANSWER : ?

The shortcut key Ctrl + R is used in Excel to

Right align the content of cell

None of above

Remove the cell contents of selected cells

Fill the selection with active cells to the right

TRUE ANSWER : ?
YOUR ANSWER : ?

A circular reference is

Always erroneous

A cell that points to a drawing object

Geometric modeling tool

A formula that either directly or indirectly depends on itself

TRUE ANSWER : ?
YOUR ANSWER : ?

How do you wrap the text in a cell ?

Format, cells, number

Format, cells, protection

Format, cells, font

Format, cells, alignment

TRUE ANSWER : ?
YOUR ANSWER : ?

How can you print three copies of a workbook?

Select File > Properties form the menu and type 3 in the Copies to print text box

Select File > Print from the menu and type 3 in the Number of copies text box

Press Ctrl+P+3

Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

TRUE ANSWER : ?
YOUR ANSWER : ?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Press Shift + Home

Press Alt + Home

Press Home

Press Ctrl + Home

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following you can paste selectively using Paste Special command?

Formulas

All of above

Validation

Formats

TRUE ANSWER : ?
YOUR ANSWER : ?