Ms Excel Questions with solutions MCQs

1. Which one among the following MS Excel functions is used to remove extra spaces from a ceil / string?

A

LEN

B

TRIM

C

REPLACE

D

SPACE

Ms Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

The Excel TRIM function removes all the spaces in a text string, except for single spaces between words.

Correct Answered :

Wrong Answered :

2. What will the function ROUND(1363.45 , -2) return in an Excel cell?

A

1400

B

-1364

C

1363.45

D

1464

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Round(1363.45, -2 ) returns 1400 that is round off to nearest hundred

Correct Answered :

Wrong Answered :

3. The formula in cell A2 is = B2 + C3. What will be the resulting formula on copying the formula = B2 + C3 from cell A2 to cell C2?

A

=D2+E4

B

=D2+E3

C

=D2+E5

D

=D3+E3

MS Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

As per given question statement, we are given a formula for a cell A2; A2 is = B2 + C3
Now if we copy this A2 formula to a new cell C2, the new formula in C2 becomes as D2+E3 when we select the normal option of paste

Correct Answered :

Wrong Answered :

4. What is the tool used to construct formulas in Excel called?

A

Auditing Toolbar

B

Format Printer

C

Formula Bar

D

Filter

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

Formula Bar

Correct Answered :

Wrong Answered :

5. Which of the following is the command used to merge number of selected cells into one cell in Excel is called?

A

Merge

B

Split

C

Merge and Center

D

One Unit

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

Merge and Center

Correct Answered :

Wrong Answered :

6. What is the wizard found in Microsoft Excel program that takes care step by step through process of creating a chart in Ms Excel called?

A

Graphical Master Wizard

B

Chart Wizard

C

Chart Tool Wizard

D

Graph Workshop Wizard

MS Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

Chart Wizard

Correct Answered :

Wrong Answered :

7. Which of the following is not a What if Analysis tool in Excel?

A

Scenario Manager

B

Goal Seek

C

Pivot Table

D

Data Table

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.

Correct Answered :

Wrong Answered :

8. What is the default alignment of numbers and text in excel?

A

Both to the left

B

Both to the right

C

Number to left and text to right

D

Number to right and text to left

MS Excel Computer Science VERIFIED
Correct Answer : D
Explanation :

As a default in Microsoft Excel, text typed into a cell is aligned to the left border of the cell while numbers are aligned to the right.

Correct Answered :

Wrong Answered :

9. Which function is used to count the number of cells having any data?

A

Count()

B

Counta()

C

Counts()

D

Countb()

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). If five of the cells in the range contain numbers, the result is 5.

Correct Answered :

Wrong Answered :

10. If you press ___, the cell accepts your typing as its contents ?

A

Alt + Enter

B

Enter

C

Ctrl + Enter

D

Tab

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Enter

Correct Answered :

Wrong Answered :

11. Which of these will not select all the cells in a document?

A

Using the Edit – Select All menu

B

Pressing Ctrl + A on the keyboard

C

Clicking three times with the right mouse button in the spreadsheet

D

None of above

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

Clicking three times with the right mouse button in the spreadsheet

Correct Answered :

Wrong Answered :

12. How can we view a cell comment?

A

Position the mouse pointer over the cell

B

Click the comment command on the view menu

C

Click the edit comment commands on the Insert menu

D

Click the Display comment command on the window menu

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Position the mouse pointer over the cell

Correct Answered :

Wrong Answered :

13. What term describes explanatory text attached to a cell?

A

Context

B

Callout

C

Comment

D

Dialog

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

Comment

Correct Answered :

Wrong Answered :

14. On an excel sheet the active cell in indicated by ?

A

A dotted border

B

A dark wide border

C

A blinking border

D

By italic text

MS Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

A dark wide border

Correct Answered :

Wrong Answered :

15. Which of the following keyboard shortcut can be used for creating a chart from the selected cells?

A

F11

B

F10

C

F4

D

F2

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

F11

Correct Answered :

Wrong Answered :

16. Formula palette is used to?

A

format cells containing numbers

B

create and edit formulas containing functions

C

entered assumptions data

D

copy all cells

MS Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

create and edit formulas containing functions

Correct Answered :

Wrong Answered :

17. A value used in a formula that does not change is called a?

A

Constant

B

Cell address

C

Variable

D

Static

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Constant

Correct Answered :

Wrong Answered :

18. A Spreadsheet contains?

A

columns

B

rows

C

rows and columns

D

None of above

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

rows and columns

Correct Answered :

Wrong Answered :

19. To open an existing workbook, click the Open button on the ___ toolbar?

A

Form

B

Standard

C

Drawing

D

Formatting

MS Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

Standard

Correct Answered :

Wrong Answered :

20. Which among following is not associated with spelling dialogue box?

A

Edit

B

Ignore

C

Ignore All

D

Change

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Edit

Correct Answered :

Wrong Answered :

21. What term describes a background that appears as a grainy, non-smooth surface?

A

Pattern

B

Gradient

C

Texture

D

Velvet

MS Excel Computer Science VERIFIED
Correct Answer : B
Explanation :

Gradient

Correct Answered :

Wrong Answered :

22. Macros can be executed from the which of the following menu?

A

Format

B

Home

C

Insert

D

Tools

MS Excel Computer Science VERIFIED
Correct Answer : D
Explanation :

Tools

Correct Answered :

Wrong Answered :

23. What function displays row data in a column or column data in a row?

A

Transpose

B

Index

C

Rows

D

Hyperlinks

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Transpose

Correct Answered :

Wrong Answered :

24. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

A

HTML

B

Pivot Table Field List

C

Pivot Table Report

D

Pivot Table List

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

Pivot Table Report

Correct Answered :

Wrong Answered :

25. You can convert existing Excel worksheet data and charts to HTML document by using the?

A

Internet Assistant Wizard

B

Intranet Wizard

C

Import Wizard

D

Export Wizard

MS Excel Computer Science VERIFIED
Correct Answer : A
Explanation :

Internet Assistant Wizard

Correct Answered :

Wrong Answered :

26. The intersection of columns and rows is called a?

A

Data

B

Table

C

Cell

D

Schema

MS Excel Computer Science VERIFIED
Correct Answer : C
Explanation :

cell

Correct Answered :

Wrong Answered :

27. Which of the following tools menu is used to view the results of what-if-analyses in Excel?

A

AutoCorrect

B

Track changes

C

Auditing

D

Scenarios

MS Excel Health Educator set 1 VERIFIED
Correct Answer : D
Explanation :

Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results. A Data Table works with only one or two variables, but it can accept many different values for those variables.

Correct Answered :

Wrong Answered :

28. When you press CTRL+9 in excel, which of the following activities will be performed

A

rename the sheet

B

unhide the sheet

C

Hides the column

D

Hides the row

MS Excel Health Educator set 1 VERIFIED
Correct Answer : D
Explanation :

In Excel, move somewhere in a row you want to hide and press Ctrl+9. The entire current row is hidden (and you don`t need to select the entire row, just have your cursor somewhere in the row). ... Once you have cells from more than one row selected, all of those rows are hidden when you press Ctrl+9.

Correct Answered :

Wrong Answered :

29. Which of the following steps in Excel is suitable for filtering the data?

A

Page Layout menu>Arrange group >Align Command> click ok

B

Review Menu>Advanced Filter>Auto Filter Command>Drop down list appear.

C

Data Menu->Filter->drop down list appears

D

View menu>Sort>Add level Command>Drop down list appear.

MS Excel Health Educator Set 2 VERIFIED
Correct Answer : C
Explanation :

Data Menu->Filter->drop down list appears

Correct Answered :

Wrong Answered :

30. The column sparkline is present in which of the following menus in Excel?

A

Insert menu

B

Data menu

C

Home menu

D

Page Layout menu

MS Excel Health Educator Set 2 VERIFIED
Correct Answer : A
Explanation :

Insert Menu

Correct Answered :

Wrong Answered :

31. Which shortcut key is used to Insert Hyperlink in Excel?

A

Shift+I

B

Ctrl+K

C

Ctrl+H

D

Ctrl+shift+K

MS Excel Health Educator Set 2 VERIFIED
Correct Answer : B
Explanation :

Ctrl+K

Correct Answered :

Wrong Answered :

32. You can activate a cell in Microsoft Excel by:

A

Pressing the Tab key

B

Clicking the cell

C

Pressing an arrow key

D

All of the above

MS Excel Accounts Assistant LAHDC VERIFIED
Correct Answer : D
Explanation :

All of the above

Correct Answered :

Wrong Answered :

33. The complete syntax for TIME function in MS Excel is :

A

TIME(day, hour, min)

B

TIME(hour, min, sec)

C

TIME(hour, min, sec, ms)

D

TIME(hour, min, day)

MS Excel JKPSI 2022 CBT
Correct Answer : B
Explanation :

TIME(hour, min, sec)

Correct Answered :

Wrong Answered :

34. A Doughnut chart in Excel is similar to :

A

Bar Char

B

Scatter chart

C

Area chart

D

Pie chart

MS Excel JKPSI 2022 CBT
Correct Answer : D
Explanation :

A donut chart is almost identical to a pie chart, but the center is cut out (hence the name donut). Donut charts are also used to show proportions of categories that make up the whole, but the center can also be used to display data.

Correct Answered :

Wrong Answered :

35. Which of the following methods cannot be used to edit the content of cell?

A

Double clicking the cell

B

Pressing F2

C

Clicking the formula bar

D

Pressing the Esc key

MS Excel JKPSI 2022 CBT
Correct Answer : D
Explanation :

Pressing the Esc key

Correct Answered :

Wrong Answered :

CONTACT US

  • J & K

  • admin@prepmart.in

  • LIKE AND SHARE YOUR EXPERIENCE

    Like Us on Facebook Join Us on Telegram
    VISITORS COUNT 9 5 6 2 7 3
    Developed By : Azhar Rashid Teli