Home
Current Affairs January 2024

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

Correct Answer :

D. Both b and c


Related Questions

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

Which of the following is the oldest spreadsheet package?

A. VisiCalc

B. Lotus 1-2-3

C. Excel

D. StarCalc

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

What is the correct answer?

4

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

What is the correct answer?

4

Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

D. All of above

What is the correct answer?

4

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

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

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

What is the correct answer?

4

Which menu option can be used to split windows into two?

A. Format -> Window

B. View -> Window-> Split

C. Window -> Split

D. View > Split

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

How do you display current date and time in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

What is the correct answer?

4

Data can be arranged in a worksheet in a easy to understand manner using

A. auto formatting

B. applying styles

C. changing fonts

D. all of above

What is the correct answer?

4

In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

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

What is the correct answer?

4

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

What is the correct answer?

4

The active cell:

A. is defined by a bold border around the cell

B. Receives the data the user enters

C. It is the formula bar

D. Only A and B

What is the correct answer?

4

Which tool you will use to join some cells and place the content at the middle of joined cell?

A. From Format Cells dialog box click on Merge Cells check box

B. From Format Cells dialog box select the Centered alignment

C. From Format Cells dialog box choose Merge and Center check box

D. Click on Merge and Center tool on formatting toolbar

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

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 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

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

You can use the drag and drop method to

A. Copy cell contents

B. Move cell contents

C. Add cell contents

D. a and b

What is the correct answer?

4

Getting data from a cell located in a different sheet is called ......

A. Accessing

B. Referencing

C. Updating

D. Functioning

What is the correct answer?

4

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

What is the correct answer?

4

To copy cell contents using drag and drop press the

A. End key

B. Shift key

C. Ctrl key

D. Esc key

What is the correct answer?

4

Which elements of a worksheet can be protected from accidental modification?

A. Contents

B. Objects

C. Scenarios

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

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

What is the correct answer?

4

Which of the following methods cannot be used to enter data in a cell

A. Pressing an arrow key

B. Pressing the Tab key

C. Pressing the Esc key

D. Clicking on the formula bar

What is the correct answer?

4

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip