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

Question

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

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

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

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

D. None of above

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

You can copy data or formulas

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

B. With commands on the shortcut menu

C. With buttons on the standard toolbars

D. All of the above

Discuss this answer

You can enter which types of data into worksheet cells?

A. Labels, values, and formulas

B. Labels and values but not formulas

C. Values and formulas but not labels

D. Formulas only

Discuss this answer

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

A. Press Ctrl +Home

B. Press Home

C. Press Shift + Home

D. Press Alt + Home

Discuss this answer

The command Edit >> Fill Across Worksheet is active only when

A. One sheet is selected

B. When many sheets are selected

C. When no sheet is selected

D. None of above

Discuss this answer

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

A. AutoFill

B. Auto correct

C. Auto sum

D. Auto format

Discuss this answer

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

Discuss this answer

To copy cell contents using drag and drop press the

A. End key

B. Shift key

C. Ctrl key

D. Esc key

Discuss this answer

Which of the following is not information you can specify using the solver?

A. Input cells

B. Constraints

C. Target cell

D. Changing cells

Discuss this answer

How do you wrap the text in a cell?

A. Format, cells, font

B. Format, cells, protection

C. Format, cells, number

D. Format, cells, alignment

Discuss this answer

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

Discuss this answer

What does `COUNTA ()` function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

Discuss this answer

Which of the following action removes a sheet from workbook?

A. Select the sheet, then choose Edit >> Delete Sheet

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

C. Both of above

D. None of above

Discuss this answer

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

A. Data will be entered in the adjacent cells

B. No data will be entered in the adjacent cells

C. There is no suitable abbreviation of the text

D. There is not time to format the next

Discuss this answer

An excel workbook is a collection of

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and charts

Discuss this answer

Which language is used to create macros in Excel?

A. Visual Basic

B. C

C. Visual C++

D. Java

Discuss this answer

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

Discuss this answer

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

A. 5430

B. 5436.80

C. 5436.8

D. 6.8

Discuss this answer

To view a cell comment

A. click the edit comment command on the insert menu

B. click the display comment command on the window menu

C. position the mouse pointer over the cell

D. click the comment command on the view menu

Discuss this answer

Rounding 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

Discuss this answer

Multiple calculations can be made in a single formula using

A. standard formulas

B. array formula

C. complex formulas

D. smart formula

Discuss this answer

We can save and protect the workbook by

A. Write Reservation Password

B. Protection Password

C. Read-only Recommended

D. Any of the above

Discuss this answer

Concatenation of text can be done using

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

Discuss this answer

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

Discuss this answer

Which menu option can be sued to split windows into two

A. Format > window

B. View > window > split

C. Window > split

D. View > split

Discuss this answer

Which of the following series type is not valid for Fill Series dialog box?

A. Linear

B. Growth

C. Autofill

D. Time

Discuss this answer

Tab scroll buttons are place on Excel screen

A. towards the bottom right corner

B. towards the bottom left corner

C. towards the top right corner

D. towards the top left corner

Discuss this answer

What is the short cut key to highlight the entire column?

A. Ctrl+C

B. Ctrl+Enter

C. Ctrl+Page Up

D. Ctrl+Space Bar

Discuss this answer

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

Discuss this answer

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

A. Number

B. Character

C. Label

D. Date/Time

Discuss this answer

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

Discuss this answer

Accepted Answer

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

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

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

You can copy data or formulas

You can enter which types of data into worksheet cells?

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

The command Edit >> Fill Across Worksheet is active only when

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

Comments put in cells are called .....

To copy cell contents using drag and drop press the

Which of the following is not information you can specify using the solver?

How do you wrap the text in a cell?

Which area in an excel window allows entering values and formulas

What does `COUNTA ()` function do?

Which of the following action removes a sheet from workbook?

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

An excel workbook is a collection of

Which language is used to create macros in Excel?

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

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

To view a cell comment

Rounding errors can occur

Multiple calculations can be made in a single formula using

We can save and protect the workbook by

Concatenation of text can be done using

When you copy a formula

Which menu option can be sued to split windows into two

Which of the following series type is not valid for Fill Series dialog box?

Tab scroll buttons are place on Excel screen

What is the short cut key to highlight the entire column?

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

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

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

Also checkout

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

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

You can copy data or formulas

You can enter which types of data into worksheet cells?

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

The command Edit >> Fill Across Worksheet is active only when

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

Comments put in cells are called .....

To copy cell contents using drag and drop press the

Which of the following is not information you can specify using the solver?

How do you wrap the text in a cell?

Which area in an excel window allows entering values and formulas

What does COUNTA () function do?

Which of the following action removes a sheet from workbook?

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

An excel workbook is a collection of

Which language is used to create macros in Excel?

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

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

To view a cell comment

Rounding errors can occur

Multiple calculations can be made in a single formula using

We can save and protect the workbook by

Concatenation of text can be done using

When you copy a formula

Which menu option can be sued to split windows into two

Which of the following series type is not valid for Fill Series dialog box?

Tab scroll buttons are place on Excel screen

What is the short cut key to highlight the entire column?

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

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

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

Also checkout

What does `COUNTA ()` function do?