Home
Current Affairs January 2024

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

Correct Answer :

C. Excel


Related Questions

What is the correct answer?

4

Which of the cell pointer indicate that you can move the content to other cell?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None 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

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

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

Which area in an Excel window allows entering values and formulas?

A. Title Bar

B. Menu Bar

C. Formula Bar

D. Standard Tool Bar

What is the correct answer?

4

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

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

To edit in an embedded excel worksheet object in a word document

A. Use the excel menu bar and toolbars inside the word application

B. Edit the hyperlink

C. Edit the data in a excel source application

D. Use the word menu bar and toolbars

What is the correct answer?

4

Status indicators are located on the

A. Vertical scroll bar

B. Horizontal scroll bar

C. Formula bar

D. Standard toolbar

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

B. no data will be entered in the adjacent cells

C. there is no suitable abbrevition for the text

D. there is not time to format the text

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

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

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

You can use the format painter multiple times before you turn it off by

A. You can use the format painter button on ly one time when you click it

B. Double clicking the format painter button

C. Pressing the Ctrl key and clicking the format painter button

D. Pressing the Alt key and clicking the format painter button

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

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

B7:B9 indicates:

A. Cells B7 and cell B9 only

B. Cells B7 through B9

C. Cell B8 only

D. None of the above

What is the correct answer?

4

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

A. None of these

B. Select Format > Money from the menu

C. Click the Currency Style button on the formatting toolbar

D. You have to retype everything and manually add the dollar signs, commas, and decimals

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

What is the correct answer?

4

To save a workbook, you:

A. Click the save button on the standard toolbar from the menu

B. Press Ctrl+F5

C. Click Save on the Windows Start button

D. Select Edit>Save

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

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

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

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

A. 0

B. 1

C. 5

D. 10

What is the correct answer?

4

To create a formula, you first:

A. Select the cell you want to place the formula into

B. Type the equals sign (=) to tell Excel that youre about to enter a formula

C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D. Choose the new command from the file menu

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

How can you delete a record?

A. Delete the column from the worksheet

B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

C. Select Data > Delete Record from the menu

D. Click the Delete button on the Standard toolbar

What is the correct answer?

4

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command on the edit menu

D. Split command on the window menu

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