B7:B9 indicates:

Question

B7:B9 indicates:

A. Cells B7 and cell B9 only

B. Cells B7 through B9

C. Cell B8 only

D. None of the above

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

How do you insert a row?

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

B. Select the row heading where you want to insert the new row and select Edit >Row from the menu

C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

D. All of the above

Discuss this answer

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

A. 0

B. 1

C. 5

D. 10

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

To select an entire column in MS-EXCEL, press?

A. CTRL + C

B. CTRL + Arrow key

C. CTRL + S

D. None of the above

Discuss this answer

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

A. Pie chart

B. Row chart

C. Line chart

D. Column chart

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

When you insert an excel file into a word document. The data are

A. Hyperlinked placed in a word table

B. Linked

C. Embedded

D. Use the word menu bar and toolbars

Discuss this answer

Which of the following is not true about Find and Replace in Excel

A. You can search for bold and replace with italics

B. You can decide whether to look for the whole word or not

C. You can search in formula too

D. You can search by rows or columns or sheets

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

A __________ is a grid with labeled columns and rows.

A. Dialog box

B. Worksheet

C. Clipboard

D. Toolbar

Discuss this answer

To remove the content of selected cells you must issue ______ command

A. Edit >> Delete

B. Edit >> Clear >> Contents

C. Edit >> Clear >> All

D. Data >> Delete

Discuss this answer

Excel probably considers the cell entry January 1, 2000 to be a

A. Label

B. Value

C. Formula

D. Text string

Discuss this answer

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

A. ROUND ( )

B. FACT ( )

C. MOD ( )

D. DIV ( )

Discuss this answer

What is represented by the small, black square in the lower-right corner of an active cell or range?

A. Copy handle

B. Fill handle

C. Insert handle

D. Border

Discuss this answer

You can check the conditions against __________ when applying conditional formatting

A. Cell value

B. Formula

C. Both of above

D. None of above

Discuss this answer

In help menu of Excel, which of the following tabs are found?

A. Contents tab

B. Answer Wizard tab

C. Index tab

D. all of the above

Discuss this answer

How can you print three copies of a workbook?

A. Select File > Properties form the menu and type 3 in the Copies to print text box

B. Select File > Print from the menu and type 3 in the Number of copies text box

C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made

D. Press Ctrl+P+3

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

Long text can be broken down into many lines within a cell. You can do this through

A. Wrap Text in Format >> Cells

B. Justify in Edit >> Cells

C. Text Wraping in Format >> Cells, Layout tab

D. All of above

Discuss this answer

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

A. Shorten the label

B. Increase the column width

C. Decrease the column width

D. Adjust the row height

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 setting you must modify to print a worksheet using letterhead?

A. Paper

B. Margin

C. Layout

D. Orientation

Discuss this answer

Which Chart can be created in Excel?

A. Area

B. Line

C. Pie

D. All of the above

Discuss this answer

Which of following is Not one of Excels what-if function?

A. Goal seek

B. Solver

C. Scenario manager

D. Auto Outline

Discuss this answer

To copy formatting from one area in a worksheet and apply it to another area you would use:

A. The Edit > Copy Format and Edit>Paste Format commands form the menu

B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C. There is no way to copy and apply formatting in Excel You have to do it manually

D. The Format Painter button on the standard toolbar

Discuss this answer

Tab scrolling button

A. Allow you to view a different worksheet

B. Allow you to view additional worksheet rows down

C. Allow you to view additional worksheet columns to the right

D. Allow you to view additional sheets tabs

Discuss this answer

Each excel file is called a workbook because

A. It can contain text and data

B. It can be modified

C. It can contain many sheets including worksheets and chart sheets

D. You have to work hard to create it

Discuss this answer

The Name box on to the left of formula bar

A. shows the name of workbook currently working on

B. shows the name of worksheet currently working on

C. shows the name of cell or range currently working on

D. None of above

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

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

Discuss this answer

Accepted Answer

B. Cells B7 through B9

B7:B9 indicates:

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

How do you insert a row?

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

Which of the following action removes a sheet from workbook?

To select an entire column in MS-EXCEL, press?

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Which menu option can be sued to split windows into two

When you insert an excel file into a word document. The data are

Which of the following is not true about Find and Replace in Excel

To copy cell contents using drag and drop press the

A __________ is a grid with labeled columns and rows.

To remove the content of selected cells you must issue ______ command

Excel probably considers the cell entry January 1, 2000 to be a

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

What is represented by the small, black square in the lower-right corner of an active cell or range?

You can check the conditions against __________ when applying conditional formatting

In help menu of Excel, which of the following tabs are found?

How can you print three copies of a workbook?

Tab scroll buttons are place on Excel screen

Long text can be broken down into many lines within a cell. You can do this through

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

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

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

Which Chart can be created in Excel?

Which of following is Not one of Excels what-if function?

To copy formatting from one area in a worksheet and apply it to another area you would use:

Tab scrolling button

Each excel file is called a workbook because

The Name box on to the left of formula bar

What does `COUNTA ()` function do?

A typical worksheet has …. Number of columns

Also checkout

B7:B9 indicates:

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

How do you insert a row?

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

Which of the following action removes a sheet from workbook?

To select an entire column in MS-EXCEL, press?

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Which menu option can be sued to split windows into two

When you insert an excel file into a word document. The data are

Which of the following is not true about Find and Replace in Excel

To copy cell contents using drag and drop press the

A __________ is a grid with labeled columns and rows.

To remove the content of selected cells you must issue ______ command

Excel probably considers the cell entry January 1, 2000 to be a

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

What is represented by the small, black square in the lower-right corner of an active cell or range?

You can check the conditions against __________ when applying conditional formatting

In help menu of Excel, which of the following tabs are found?

How can you print three copies of a workbook?

Tab scroll buttons are place on Excel screen

Long text can be broken down into many lines within a cell. You can do this through

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

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

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

Which Chart can be created in Excel?

Which of following is Not one of Excels what-if function?

To copy formatting from one area in a worksheet and apply it to another area you would use:

Tab scrolling button

Each excel file is called a workbook because

The Name box on to the left of formula bar

What does COUNTA () function do?

A typical worksheet has …. Number of columns

Also checkout

What does `COUNTA ()` function do?