Microsoft Excel mcq questions with answer – Set 4

Important Instructions:

• Total Number Of Questions : 10
• Passing Marks : 7
• Each Question Carry 1 Mark, No Negative Marking.
• Do Not Refresh The Page.
• This Is A FREE Online Test, DO NOT Pay Money To Anyone To Attend This Test.
• Best Of Luck…

Results

-

Congratulation…
You Have Passed The Test, You Should Try To The Next One…!!

Rate this post

You May Also Like :   Microsoft Excel mcq questions with answer - Set 1

Unfortunately…
You Did Not Pass. Why Not Try It Again?

Rate this post

You May Also Like :   Microsoft Excel mcq questions with answer - Set 2

#1. When you group worksheets?

You can enter variable data on multiple worksheets at one time

You can enter variable data on multiple worksheets at one time

You can print more than one worksheet at a time

You can print more than one worksheet at a time

You can enter common data, formats, and formulas on multiple worksheets at one time

You can enter common data, formats, and formulas on multiple worksheets at one time

b and c

b and c

#2. You can use the format painter multiple times before you turn it off by

You can use the format painter button only one time when you click it

You can use the format painter button only one time when you click it

Double clicking the format painter button

Double clicking the format painter button

Pressing the Ctrl key and clicking the format painter button

Pressing the Ctrl key and clicking the format painter button

Pressing Alt key and clicking the format painter button

Pressing Alt key and clicking the format painter button

#3. The default header for a worksheet is?

Your name

Your name

The date and time

The date and time

None

None

The sheet tab name

The sheet tab name

#4. Which is used to drag the selected range of data to another worksheet in the same workbook?

Tab key

Tab key

Alt key

Alt key

Shift key

Shift key

Ctrl key

Ctrl key

#5. When creating a vertical page break

The active cell must be A1

The active cell must be A1

The active cell can be anywhere in the worksheet

The active cell can be anywhere in the worksheet

The active cell must be in row 1

The active cell must be in row 1

The active cell must be in column A

The active cell must be in column A

#6. What term refers to a specific set of values saved with the workbook?

Range

Range

Scenario

Scenario

Trend line

Trend line

What-if analysis

What-if analysis

#7. Got functions? No? You need the insert function dialog box. How do you get it?

Right click a cell and then click insert

Right click a cell and then click insert

Click the insert menu and then click function

Click the insert menu and then click function

Type = in a cell

Type = in a cell

All of the above

All of the above

#8. Which of the following describes how to select all the cells in a single column?

Right click on column and select Pick from list

Right click on column and select Pick from list

Use data - text to columns menu item

Use data - text to columns menu item

Left click on the gray column title button

Left click on the gray column title button

Pressing Ctrl + A on the keyboard

Pressing Ctrl + A on the keyboard

#9. When you use the fill effects in the format data series dialog box, you can not?

rotate text on the chart

rotate text on the chart

select a fore ground color

select a fore ground color

select a pattern

select a pattern

select a background color

select a background color

#10. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

Rows and columns

Rows and columns

Headings

Headings

Speed

Speed

None

None

CHECK ANSWER