Home
Current Affairs January 2024

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

Correct Answer :

D. Only A and B


Related Questions

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

Which of the cell pointer indicates that you can fill series?

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

You can edit a cell by

A. Clicking the formula button

B. Double clicking the cell to edit it in-place

C. Selecting Edit>Edit Cell from the menu

D. None of above

What is the correct answer?

4

Which language is used to create macros in Excel?

A. Visual Basic

B. C

C. Visual C++

D. Java

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 __________ is a grid with labeled columns and rows.

A. Dialog box

B. Worksheet

C. Clipboard

D. Toolbar

What is the correct answer?

4

The Paste Special command lets you copy and paste:

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula

What is the correct answer?

4

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

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

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

A. Goal seek

B. Solver

C. Scenario manager

D. Auto Outline

What is the correct answer?

4

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

A. Right click on Sheet Tab of third sheet and choose Delete from the context menu

B. Click on Sheet 3 and from Edit menu choose Delete

C. Both of above

D. None of above

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

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

We can save and protect the workbook by

A. Write Reservation Password

B. Protection Password

C. Read-only Recommended

D. Any of the above

What is the correct answer?

4

Right clicking something in Excel:

A. Deletes the object

B. Nothing the right mouse button is there for left handed people

C. Opens a shortcut menu listing everything you can do to the object

D. Selects the object

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

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

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

What is the correct answer?

4

Microsoft Excel is a powerful ...........

A. Word processing package

B. Spreadsheet package

C. Communication S/W Package

D. DBMS package

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

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

A. WINDOWS

B. DOS

C. UNIX

D. OS/2

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

The Chart wizard term data categories refers to;

A. A chart plot area

B. A horizontal axis

C. The organization of individual values with a charts data series

D. The data range that supply chart data

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

To record a sequence of keystrokes and mouse actions to play back later we use:

A. Media player

B. Sound Recorder

C. Calculator

D. Macro Recorder

What is the correct answer?

4

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

A. 5430

B. 5436.80

C. 5436.8

D. 6.8

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

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

Files created with Lotus 1-2-3 have an extension

A. DOC

B. XLS

C. 123

D. WK1

What is the correct answer?

4

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

A. From Edit menu choose Clear and then Formats

B. From Edit menu choose Delete

C. Click on Remove Formatting tool on Standard Toolbar

D. Double click the Format Painter and then press Esc key in keyboard