How many worksheets can a workbook have?

Question

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

Which of the following is not the correct method of editing the cell content?

A. Press the Alt key

B. Press the F2 key

C. Click the formula bar

D. Double click the cell

Discuss this answer

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

Discuss this answer

How do you rearrange the data in ascending or descending order?

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

Discuss this answer

Which of the following formulas is not entered correctly?

A. =10+50

B. 10+50

C. =10+50

D. =B7+14

Discuss this answer

To create a formula, you can use:

A. Values but not cell references

B. Cell references but not values

C. Values or cell references although not both at the same time

D. Value and cell references

Discuss this answer

Which setting you must modify to print a worksheet using letterhead?

A. Paper

B. Margin

C. Layout

D. Orientation

Discuss this answer

To center worksheet titles across a range of cells, you must

A. Select the cells containing the title text plus the range over which the title text is to be centered

B. Widen the columns

C. Select the cells containing the title text plus the range over which the title text is to be enfettered

D. Format the cells with the comma style

Discuss this answer

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

A. Page Break Preview

B. Page Orientation

C. Margins

D. Headers and Footers

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

The short cut key Ctrl + R is used in Excel to

A. Right align the content of cell

B. Remove the cell contents of selected cells

C. Fill the selection with active cells to the right

D. None of above

Discuss this answer

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A. Square

B. Percentage

C. Goal Seek

D. Divide

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

In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

Discuss this answer

In Excel, a Data Series is defined as what?

A. A type of chart

B. A cell reference

C. A collection of related data

D. A division of results

Discuss this answer

Which of the following is the oldest spreadsheet package?

A. VisiCalc

B. Lotus 1-2-3

C. Excel

D. StarCalc

Discuss this answer

A worksheet can have a maximum of …. Number of rows

A. 256

B. 1024

C. 32000

D. 65535

Discuss this answer

Excel displays the current cell address in the ........

A. Formula bar

B. Status Bar

C. Name Box

D. Title Bar

Discuss this answer

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

A. An absolute cell address is created

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

C. The sheet tab is changed

D. The status bar does not display the cell address

Discuss this answer

You can select a single range of cells by

A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B. Pressing the Ctrl key while dragging over the desired cells

C. Pressing the Shift key and an arrow key

D. Dragging over the desired cells

Discuss this answer

You can auto fit the width of column by

A. double clicking on the column name on column header

B. Double click on the cell pointer in worksheet

C. Double clicking on column right border on column header

D. Double clicking on the column left border of column header

Discuss this answer

The name box

A. Shows the location of the previously active cell

B. Appears to the left of the formula bar

C. Appears below the status bar

D. Appears below the menu bar

Discuss this answer

What are the tabs that appear at the bottom of each workbook called?

A. Reference tabs

B. Position tabs

C. Location tabs

D. Sheet tabs

Discuss this answer

A circular reference is

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous

Discuss this answer

Which of the following format you can decide to apply or not in AutoFormat dialog box?

A. Number format

B. Border format

C. Font format

D. All of above

Discuss this answer

Which elements of worksheet can be protected from accidental modification

A. Contents

B. Objects

C. Scenarios

D. All of above

Discuss this answer

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

Discuss this answer

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A. XY Chart

B. Line Chart

C. Pie Chart

D. Column Chart

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

A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

Discuss this answer

MS-EXCEL is based on .........?

A. WINDOWS

B. DOS

C. UNIX

D. OS/2

Discuss this answer

Accepted Answer

D. none of above

How many worksheets can a workbook have?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Which of the following is not the correct method of editing the cell content?

A typical worksheet has …. Number of columns

How do you rearrange the data in ascending or descending order?

Which of the following formulas is not entered correctly?

To create a formula, you can use:

Which setting you must modify to print a worksheet using letterhead?

To center worksheet titles across a range of cells, you must

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

Which language is used to create macros in Excel?

The short cut key Ctrl + R is used in Excel to

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

What does `COUNTA ()` function do?

In a worksheet you can select

In Excel, a Data Series is defined as what?

Which of the following is the oldest spreadsheet package?

A worksheet can have a maximum of …. Number of rows

Excel displays the current cell address in the ........

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

You can select a single range of cells by

You can auto fit the width of column by

The name box

What are the tabs that appear at the bottom of each workbook called?

A circular reference is

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Which elements of worksheet can be protected from accidental modification

How many worksheets can a workbook have?

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

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

A worksheet range is a

MS-EXCEL is based on .........?

Also checkout

How many worksheets can a workbook have?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Which of the following is not the correct method of editing the cell content?

A typical worksheet has …. Number of columns

How do you rearrange the data in ascending or descending order?

Which of the following formulas is not entered correctly?

To create a formula, you can use:

Which setting you must modify to print a worksheet using letterhead?

To center worksheet titles across a range of cells, you must

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

Which language is used to create macros in Excel?

The short cut key Ctrl + R is used in Excel to

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

What does COUNTA () function do?

In a worksheet you can select

In Excel, a Data Series is defined as what?

Which of the following is the oldest spreadsheet package?

A worksheet can have a maximum of …. Number of rows

Excel displays the current cell address in the ........

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

You can select a single range of cells by

You can auto fit the width of column by

The name box

What are the tabs that appear at the bottom of each workbook called?

A circular reference is

Which of the following format you can decide to apply or not in AutoFormat dialog box?

Which elements of worksheet can be protected from accidental modification

How many worksheets can a workbook have?

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

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

A worksheet range is a

MS-EXCEL is based on .........?

Also checkout

What does `COUNTA ()` function do?