Home
Current Affairs January 2024

What is the correct answer?

4

Which command will you choose to convert a column of data into row?

A. Cut and Paste

B. Edit >> Paste Special >> Transpose

C. Both of above

D. None of above

Correct Answer :

B. Edit >> Paste Special >> Transpose


Related Questions

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

When you want to insert a blank imbedded excel object in a word document you can

A. Click the object command on the insert menu

B. Click the office links button on the standard toolbar

C. Click the create worksheet button on the formatting toolbar

D. Click the import excel command on the file menu

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

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

Which of the following formulas is not entered correctly?

A. =10+50

B. 10+50

C. =10+50

D. =B7+14

What is the correct answer?

4

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

What is the correct answer?

4

To delete an embedded objects, first

A. Double click the object

B. Select the object by clicking it

C. Press the Shift + Delete keys

D. Select it and then press the delete key

What is the correct answer?

4

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A. Logical

B. Math & Trigonometry

C. Statistical

D. Financial

What is the correct answer?

4

A numeric value can be treated as label value if ...... precedes it.

A. Apostrophe ( )

B. Exclamation ( ! )

C. Hash ( # )

D. Tilde ( ~ )

What is the correct answer?

4

In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. &

What is the correct answer?

4

In Excel, the Fill Color button on the Formatting toolbar is used for what?

A. To insert a background

B. To add borders

C. To select a distribution of figures

D. To add shading or color to a cell range

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

Which of the following formulas will Excel Not be able to calculate?

A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

What is the correct answer?

4

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

What is the correct answer?

4

Which of the following is a correct order of precedence in formula calculation?

A. Multiplication and division exponentiation positive and negative values

B. Multiplication and division, positive and negative values, addition and subtraction

C. Addition and subtraction, positive and negative values, exponentiation

D. All of above

What is the correct answer?

4

Comments can be added to cells using ......

A. Edit -> Comments

B. Insert -> Comment

C. File -> Comments

D. View > Comments

What is the correct answer?

4

How many characters can be typed in a single cell in Excel?

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

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

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

What is the correct answer?

4

You can convert existing excel worksheet data an charts to an HTML document by using

A. FTP wizard

B. Internet assistant wizard

C. Intranet wizard

D. Import wizard

What is the correct answer?

4

Comments can be added to cells using

A. Edit > Comments

B. Insert > Comments

C. File > Comments

D. View > Comments

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

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

A. WINDOWS

B. DOS

C. UNIX

D. OS/2

What is the correct answer?

4

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

What is the correct answer?

4

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

What is the correct answer?

4

Which of the following is not true regarding Conditional Formatting?

A. You can add more than one condition to check

B. You can set condition to look for Bold and apply Italics on them

C. You can apply Font, border and pattern formats that meets the specified conditions

D. You can delete any condition from Conditional Formatting dialog box if it is not requried

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

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

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

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

A. You can Find and Replace within the sheet or workbook

B. Excel does not have option to match case for find

C. Both are valid

D. None are valid