Home
Current Affairs January 2024

What is the correct answer?

4

You can use the formula pallette to

A. format cells containing numbers

B. create and edit formula containing functions

C. enter assumptions data

D. copy a range of cells

Correct Answer :

B. create and edit formula containing functions


Related Questions

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

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

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

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

To select an entire column in MS-EXCEL, press?

A. CTRL + C

B. CTRL + Arrow key

C. CTRL + S

D. None of the above

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

Concatenation of text can be done using

A. Apostrophe ( )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

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

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

The command Edit >> Fill Across Worksheet is active only when

A. One sheet is selected

B. When many sheets are selected

C. When no sheet is selected

D. None of above

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

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

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

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

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

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 is used to perform what if analysis?

A. Solver

B. Goal seek

C. Scenario Manager

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

The auto calculate feature

A. Can only add values in a range of cells

B. Provides a quick way to view the result of an arithmetic operation on a range of cells

C. Automatically creates formulas and adds them to a worksheet

D. A and c

What is the correct answer?

4

When a label is too long to fit within a worksheet cell, you typically must

A. Shorten the label

B. Increase the column width

C. Decrease the column width

D. Adjust the row height

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

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

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

A. work sheet

B. chart sheet

C. module sheet

D. data sheet

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

What is represented by the small, black square in the lower-right corner of an active cell or range?

A. Copy handle

B. Fill handle

C. Insert handle

D. Border

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

Text formulas:

A. Replace cell references

B. Return ASCII values of characters

C. Concatenate and manipulate text

D. Show formula error value

What is the correct answer?

4

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

What is the correct answer?

4

Which of the cell pointer indicates you that you can make selection?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above