MS Excel mcq Questions and Answer | Microsoft Excel-5

Excell- 5

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question 1

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

A	Press Ctrl +Home
B	Press Home
C	Press Shift + Home
D	Press Alt + Home

Question 2

Which of the following methods can not be used to edit the contents of a cell?

A	Press the Alt key
B	Clicking the formula bar
C	Pressing the F2 key
D	Double clicking the cell

Question 3

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you

A	Press the Erase key
B	Press Esc
C	Press the Enter button
D	Press the Edit Formula button

Question 4

Which of the following methods can not 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

Question 5

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

Question 6

Which of the following is not a way to complete a cell entry?

A	Pressing enter
B	Pressing any arrow key on the keyboard
C	Clicking the Enter button on the Formula bar
D	Pressing spacebar

Question 7

You can activate a cell by

A	Pressing the Tab key
B	Clicking the cell
C	Pressing an arrow key
D	All of the above

Question 8

Text formulas:

A	Replace cell references
B	Return ASCII values of characters
C	Concatenate and manipulate text
D	Show formula error value

Question 9

How do you insert a row?

A	Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B	Select the row heading where you want to insert the new row and select Edit > Row from the menu
C	Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D	All of the above

Question 10

Which of the following is not a basic step in creating a worksheet?

A	Save workbook
B	Modifiy the worksheet
C	Enter text and data
D	Copy the worksheet

Question 11

How do you select an entire column?

A	Select Edit > Select > Column from the menu
B	Click the column heading letter
C	Hold down the shift key as you click anywhere in the column,
D	Hold down the Ctrl key as you click anywhere in the column

Question 12

How can you print three copies of a workbook?

A	Select File>Properties form the menu and type 3 in the Copies to print text box.
B	Select File >Print from the menu and type 3 in the Number of copies text box.
C	Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made
D	Press Ctri+P+3

Question 13

To create a formula, you first:

A	Select the cell you want to place the formula into
B	Type the equals sign (-) to tell Excel that you're about to enter a formula
C	Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D	Choose the new command from the file menu

Question 14

To center 'worksheet titles across a range of cells, you must

A	Select the cells containing the title text plus the range over which the title text is to be centered
B	Widen the columns
C	Select the cells containing the title text plus the range over which the title text is to be enfettered
D	Format the cells with the comma style

Question 15

How do you delete a column?

A	Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B	Select the column heading you want to delete and select Insert Delete from the menu
C	Select the row heading you want to delete "and select Edit>Delete from the menu
D	Right click the column heading you want to delet and select delete from .the shortcut menu

Question 16

How can you find specific information in a list?

A	Select Tools > Finder from the menu
B	Click the Find button on the standard toolbar
C	Select Insert > Find from the menu
D	Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Question 17

When integrating word and excel, word is usually the

A	Server
B	Destination
C	Client
D	Both b and c

Question 18

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

Question 19

The name box

A	Shows the location of the previously active cell
B	Appears to the left of the formula bar
C	Appears below the status bar
D	Appears below the menu bar

Question 20

Comments put in cells are called

A	Smart tip
B	Cell tip
C	Web tip
D	Soft tip

Question 21

Which is used to perform what if analysis?

A	Solver
B	Goal seek
C	Scenario Manager
D	All of above

Question 22

You can use the horizontal and vertical scroll bars to

A	Split a, worksheet into two panes
B	View different rows and columns edit the contents of a cell
C	Edit the contents of a cell
D	view different worksheets

Question 23

Hyperlinks can be

A	Text
B	Drawing objects
C	Pictures
D	All of above

Question 24

To activate the previous cell in a pre-selected range, press

A	The Alt key
B	The Tab key
C	The Enter key
D	All of the above
E	None of these

Question 25

Which button do you click to add up a series of numbers?

A	The autosum button
B	The Formula button
C	The quicktotal button
D	The total button

Question 26

When the formula bar is active, you can see

A	The edit formula button
B	The cancel button
C	The enter button
D	All of the above

Question 27

To copy formatting from one area in a worksheet and apply it to another area you would use:

A	The Edit>Copy Format and Edit>Paste Format commands form the menu.
B	The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
C	There is no way to copy and apply formatting in Excel You have to do it manually
D	The Format Painter button on the standard toolbar

Question 28

In a worksheet you can select

A	The entire worksheet
B	Rows
C	Columns
D	All of the above

Question 29

When you link data maintained in an excel workbook to a word document

A	The word document can not be edit
B	The word document contains a reference to the original source application
C	The word document must contain a hyperlink
D	The word document contains a copy of the actual data

Question 30

Which area in an excel window allows entering values and formulas

A	Title bar
B	Menu bar
C	Formula bar
D	Standard toolbar

Question 31

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A	Unfreeze panes command on the window menu
B	Freeze panes command on the window menu
C	Hold titles command on the edit menu
D	Split command on the window menu

Question 32

To edit in an embedded excel worksheet object in a word document

A	Use the excel menu bar and toolbars inside the word application
B	Edit the hyperlink
C	Edit the data in a excel source application
D	Use the word menu bar and toolbars

Question 33

To create a formula, you can use:

A	Values but not cell references
B	Cell references but not values
C	Values or cell references although not both at the same time
D	Value and cell references

Question 34

Status indicators are located on the

A	Vertical scroll bar
B	Horizontal scroll bar
C	Formula bar
D	Standard toolbar

Question 35

Which of the following is the oldest spreadsheet package?

A	VisiCalc
B	Lotus 1-2-3
C	Excel
D	StarCalc

Question 36

Pounding errors can occur

A	When you use multiplication, division, or exponentiation in a formula
B	When you use addition and subtraction in a formula
C	Because excel uses hidden decimal places in computation
D	When you show the results of formulas with different decimal places that the calculated results