Microsoft Excel Quiz

April 12, 2022April 29, 2022admin1 Comment

This portion is focus on Microsoft Excel Quiz for those who are preparing Computer Operator Examination for Loksewa aayog (Public Service Commission) PSC, and other organizational examination.

127

Created on April 12, 2022 By

admin

Microsoft Spreadsheet (Excel) MCQ Quiz

Here we are upload 500+ Multiple Choice Question (MCQ) form Excel you can play All Question for this You Need To Click On Restart Quiz Button on Result Page

1 / 10

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

a) Adjust the row height

b) Shorten the label

c) Increase the column width

d) Decrease the column width

2 / 10

2. To create a formula, you first

a) Select the cell you want to place the formula into

b) Enter the formula using any input values and the appropriate mathematical operators that make up your formula

c) Type the equals sign (=) to tell Excel that you are about to enter a formula

d) Choose the new command from the file menu

3 / 10

3. All worksheet formula

a) Use the addition operator

b) Return a formula result

c) Manipulate values

d) Manipulate labels

4 / 10

4. It is acceptable to let long text flow into adjacent cells on a worksheet when

a) No data will be entered in the adjacent cells

b) There is not suitable abbreviation of the text

c) There is not time to format the next

d) Data will be entered in the adjacent cells

5 / 10

5. Which menu option can be sued to split windows into two

a) Window > split

b) Format > window

c) View > split

d) View > window > split

6 / 10

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

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

b) Pressing the Ctrl key and clicking the format painter button

c) Pressing the Alt key and clicking the format painter button

d) Double clicking the format painter button

7 / 10

7. Which of the following is an absolute cell reference?

a) $a#1

b) !A!1

c) A1

d) $A$1

8 / 10

8. The auto calculate feature

a) Automatically creates formulas and adds them to a worksheet

b) Provides a quick way to view the result of an arithmetic operation on a range of cells

c) Can only add values in a range of cells

d) None

9 / 10

9. Which of the following options is not located in the Page Setup dialog box?

a) Page Orientation

b) Page Break Preview

c) Headers and Footers

d) Margins

10 / 10

10. How do you delete a column?

a) Right click the column heading you want to delete and select delete from the shortcut menu

b) Select the row heading you want to delete and select Edit>Delete from the menu

c) Select the column heading you want to delete and select Insert Delete from the menu

d) Select the column heading you want to delete and select the Delete Row button on the standard toolbar

Your score is

The average score is 81%

Computer Operator Mock Test-1 Click Here

1 thought on “Microsoft Excel Quiz”

Nirmal Khadka says:

May 22, 2022 at 7:49 am

Q N. 2 ko all of the above hoin sir mistake x ans

Reply

Microsoft Excel Quiz

1 thought on “Microsoft Excel Quiz”

Leave a Reply Cancel reply

Computer Operator MCQ

Categories

Popular Posts

Computer Operator MCQ Dugdha Bikash Sansthan 2077

Assistant Computer Operator Syllabus Pradesh 1

Computer Operator Syllabus Pradesh No 1

You May Like

Computer Operator Mock Test-6

Microsoft Access MCQ Quiz Part-1

Computer Operator Mock Test-10

1 thought on “Microsoft Excel Quiz”

Leave a Reply Cancel reply

Computer Operator MCQ Dugdha Bikash Sansthan 2077

Assistant Computer Operator Syllabus Pradesh 1

Computer Operator Syllabus Pradesh No 1