MS Excel Practice Set-2 | Free MCQ Quiz

MS Excel Practice Set-2 covers formulas, functions, and shortcuts, useful for the Computer Operator exam, Loksewa, and other office-skills tests.

Start the quiz below and see where you stand.

Haven’t tried the earlier sets? Practice Set-1, MCQ Set-1, and MCQ Set-2 are here, or check the full list of MCQ categories for other topics.

/50

Created by

Computerkite

MS Excel Practice Set-2

Welcome to MS Excel Practice Set-2

Quiz सुरु गर्न Start मा Click गर्नुहोला र सकिएपछि Submit गर्नुहोला ।

यो Quiz Unlimited दिन पाएनेछ ...

***Best of Luck***

1 / 50

when you work with large worksheets, you may need to

size the worksheet to fit on the specific number of pages

add and remove page breaks

specifies only certain print areas

all of above

2 / 50

Which of the following is not an option of the spelling dialog box?

Ignore

Ignore all

Edit

Change

3 / 50

You can use drag-and-drop to embed excel worksheet data in a word document

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

By dragging a range of excel data to the word button on the taskbar while pressing Shift key

By dragging a range of excel data to the word button on the taskbar while pressing Alt key

None of above

4 / 50

The Delete key of keyboard is assigned to which command in Excel?

Edit >> Clear >> Contents

Edit >> Clear >> All

Edit >> Delete

All of above

5 / 50

How to restrict to run a macro automatically when starting Microsoft Excel?

Hold down the SHIFT key during startup

Hold down the CTRL key during startup

Hold down the ESC key during startup

Hold down the ALT key during startup

6 / 50

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

Use the excel menu bar and toolbars inside the word application

Edit the hyperlink

Edit the data in a excel source application

Use the word menu bar and toolbars

7 / 50

All formulae start with in Excel is

–

8 / 50

MS Excel provides the default value for step in Fill Series dialog box

9 / 50

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

An absolute cell address is created.

Cell address will change when it is copied to another cell.

The sheet tab is changed.

The status bar does not display the cell address.

10 / 50

Which function converts miles to kilometers, kilograms to pounds, and so on?

CONVERT

PRODUCT

CHANGE

All of the above

11 / 50

Which of the following action removes a sheet from workbook?

Select the sheet, then choose Edit >> Delete Sheet

Select the sheet then choose Format >> Sheet >> Hide

Both of above

None of above

12 / 50

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

Press the Erase key

Press Esc

Press the Enter button

Press the Edit Formula button

13 / 50

How many worksheets can a workbook have?

255

none of above

14 / 50

If particular workbook have to open each time Excel started, where that workbook should be placed?

AUTOEXEC Folder

AUTOSTART Folder

EXCELSTART Folder

XLSTART Folder

15 / 50

You can copy data or formulas

With the copy, paste and cut commands on the edit menu

With commands on the shortcut menu

With buttons on the standard toolbars

All of the above

16 / 50

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

Page Break Preview

Page Orientation

Margins

Headers and Footers

17 / 50

When a range is selected, how can you activate the previous cell?

Press the Alt key

Press Tab

Press Enter

None of above

18 / 50

While Finding and Replacing some data in Excel, which of the following statement is valid? 16

You can Find and Replace within the sheet or workbook

Excel does not have option to match case for find

Both are valid

None are valid

19 / 50

Which elements of a worksheet can be protected from accidental modification?

Contents

Objects

Scenarios

All of the above

20 / 50

What do you mean by a Workspace?

Group of Columns

Group of Worksheets

Group of Rows

Group of Workbooks

21 / 50

When you are typing an equation into a cell the first thing that must be entered is

The first cell referenced

Parenthesis

Quotation marks

An equal sign

22 / 50

In Excel _______ may not contain in Formula

Text Constant

Number Constant

Circular Reference

All of them

23 / 50

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

Pressing enter

Pressing any arrow key on the keyboard

Clicking the Enter button on the Formula bar

Pressing spacebar

24 / 50

Merge cells option can be applied from

Format Cells dialog box Alignment Tab

Formatting toolbar

Both of above

None of above

25 / 50

How can you delete a record?

Delete the column from the worksheet

Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

Select Data > Delete Record from the menu

Click the Delete button on the Standard toolbar

26 / 50

To create a formula, you first:

Select the cell you want to place the formula into

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

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

Choose the new command from the file menu

27 / 50

When you copy a formula

Excel erases the original copy of the formula

Excel edits cell references in the newly copied formula

Excel adjusts absolute cell references

Excel doesn’t adjust relative cell references

28 / 50

Getting data from a cell located in a different sheet is called….

Accessing

Referencing

Updating

Functioning

29 / 50

You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

Edit

View

Format

Tools

30 / 50

How do you display current date only in MS Excel?

date ()

Today ()

now ()

time ()

31 / 50

Which of the following is not a valid data type in excel?

Number

Character

Label

Date/time

32 / 50

Excel uniquely identifies cells within a worksheet with a cell name

Cell names

Column numbers and row letters

Column letters and row numbers

Cell locator coordinates

33 / 50

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?

Custom List

Auto Fill Options

Fill Across Worksheet

Fill Series

34 / 50

Which of following is not one of Excel’s what-if function?

Goal seek

Solver

Scenario manager

Auto Outline

35 / 50

In Excel, by default Numeric Values appears in

Left aligned

Right aligned

Center aligned

Justify aligned

36 / 50

Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

Enclose the number is brackets

Place the character T before the number

Place the character TX before the number

Apply the Text format in the cell and type the numbers

37 / 50

Which of the following syntax is correct regarding to SUM function in Excel?

=@SUM (#REF! ,#REF!)

=@SUM (A1:B8)

=@SUM (A1:A8, B1:B8)

All of the above

38 / 50

Excel files have a default extension of

Xls

Xlw

Wk1

123

39 / 50

If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

Re-format the spreadsheet

Insert a row

Increase the column width

Use the spacebar

40 / 50

You can automatically adjust the size of text in a cell if they do not fit in width by

Double clicking on the right border of column header

From Format chooses Columns and then Autofit Selection

From Format Cells dialog box mark Shrink to fit check box

All of above

41 / 50

In Excel, a Data Series is defined as what?

A type of chart

A cell reference

A collection of related data

A division of results

42 / 50

Multiple calculations can be made in a single formula using…..

Standard Formulas

Array Formula

Complex Formulas

Smart Formula

43 / 50

You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.

View

Insert

Format

Tools

44 / 50

If you need a text to show vertically in a cell. How will you achieve this?

Choose Vertical on Text alignment in Format Cells dialog box

Choose 90 Degrees in Orientation of Format Cells dialog box

Choose Distributed from the Vertical drop down list of Format Cells dialog box

Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

45 / 50

You can auto fit the width of column by

Double clicking on the column name on column header

Double click on the cell pointer in worksheet

Double clicking on column right border on column header

Double clicking on the column left border of column header

46 / 50

You can move a sheet from one workbook into new book by

From Edit menu choose Move or Copy sheet, mark the Create a copy and Click OK

From Edit menu choose Move of Copy then choose (Move to end) and click OK

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

None of above

47 / 50

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

Point to speech on the tools menu, and then click show text to speech toolbar.

Click validation on the data menu

Point to speech on the tools menu, and then click speech recognition

All of above

48 / 50

You can print only an embedded chart by

Moving the chart to a chart sheet before you print.

Formatting the chart before you print

Selecting the chart before you print

a and c

49 / 50

A numeric value can be treated as a label value if it precedes with

Apostrophe (')

Exclamation (!)

Hash (#)

Ampersand (&)

50 / 50

Comments can be added to cells using …..

Edit -> Comments

Insert -> Comment

File -> Comments

View –> Comments

Your score is

Post Views: 19

MS Excel Practice Set-2 | Free MCQ Quiz – ComputerKite

Start the quiz below and see where you stand.

Welcome to MS Excel Practice Set-2

Leave a Comment Cancel Reply

Start the quiz below and see where you stand.

Welcome to MS Excel Practice Set-2

Related Posts

Leave a Comment Cancel Reply