MICROSOFT EXCEL 2016

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

• a. Pressing an arrow key

• b. Pressing the Tab key

• c. Pressing the Esc key

• d. Clicking on the formula bar

Which of the following will not cut information?

• a. Pressing Ctrl + C

• b. Selecting Edit>Cut from the menu

• c. Clicking the Cut button on the standard

• d. Pressing Ctrl+X

When a label is too long to fit within a worksheet cell, you typically must

• a. Shorten the label

• b. Increase the column width

• c. Decrease the column width

• d. Adjust the row height

In MS-Excel you can use the drag and drop method to

• A.Copy cell contents

• B.Move cell contents

• C.Add cell contents

• D.(A) and (B)

In MS-Excel numeric value can be treated as a label value if it precedes with

• A. Apostrophe (')

• B. Exclamation (!)

• C. Hash (#)

• D. None of these

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

• A) Custom List

• B) Auto Fill Options

• C) Fill Across Worksheet

• D) Fill Series

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

• A. Insert

• B. Copy

• C. Undo

• D. Replace

What is the shortcut key to hide entire column?

• A. CTRL + −

• B. CTRL + 0

• C. CTRL + H

• D. CTRL + C

Comments put in a cell are called

• A. Smart tip

• B. Web tip

• C. Cell tip

• D. Soft tip

When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.

• A) AutoSum

• B) Custom Fill

• C)Fill Handle

• D)Ctrl+C