Home

What is the correct answer?

4

Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

Correct Answer :

D. The width of a row and be specified manually or fit automatically


Related Questions

What is the correct answer?

4

Which of the following is not a worksheet design criterion?

A. Efficiency

B. Aditibility

C. Description

D. Clarity

What is the correct answer?

4

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

A. Label

B. Value

C. Formula

D. Text string

What is the correct answer?

4

When the formula bar is active, you can see

A. The edit formula button

B. The cancel button

C. The enter button

D. All of the above

What is the correct answer?

4

Which Chart can be created in Excel?

A. Area

B. Line

C. Pie

D. All of the above

What is the correct answer?

4

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

A. Formula bar

B. Status Bar

C. Name Box

D. Title Bar

What is the correct answer?

4

Which of the following is not an example of a value?

A. 350

B. May 10, 2001

C. 0.57

D. Serial Number 50771

What is the correct answer?

4

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

A. Standard Formulas

B. Array Formula

C. Complex Formulas

D. Smart Formula

What is the correct answer?

4

The Cancel and Enter buttons appear in the:

A. Title bar

B. Formula bar

C. Menu bar

D. Sheet tabs

What is the correct answer?

4

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

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

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

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

D. None of above

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

When integrating word and excel, word is usually the

A. Server

B. Destination

C. Client

D. Both b and c

What is the correct answer?

4

An Excel Workbook is a collection of .......

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and Charts

What is the correct answer?

4

Documentation should include

A. Destination and users of the output data

B. Source of input data

C. Information on the purpose of the workbook

D. All of the above

What is the correct answer?

4

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

What is the correct answer?

4

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

A. Number

B. Character

C. Label

D. Date/time

What is the correct answer?

4

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

What is the correct answer?

4

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

A. Pressing enter

B. Pressing any arrow key on the keyboard

C. Clicking the Enter button on the Formula bar

D. Pressing spacebar

What is the correct answer?

4

The spelling dialog box can be involved by choosing spelling from ________ menu.

A. insert

B. file

C. tools

D. view

What is the correct answer?

4

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

A. server

B. source

C. client

D. none

What is the correct answer?

4

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

What is the correct answer?

4

Which button do you click to add up a series of numbers?

A. The autosum button

B. The Formula button

C. The quicktotal button

D. The total button

What is the correct answer?

4

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

A. Edit >> Clear >> Contents

B. Edit >> Clear >> All

C. Edit >> Delete

D. All of above

What is the correct answer?

4

Which is not the function of Edit, Clear command?

A. Delete contents

B. Delete notes

C. Delete cells

D. Delete formats

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

You cannot link excel worksheet data to a word document

A. With the right drag method

B. With a hyperlink

C. With the copy and paste special commands

D. With the copy and paste buttons on the standard toolbar