Home
Current Affairs January 2024

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

Correct Answer :

B. small thin plus icon


Related Questions

What is the correct answer?

4

Which button do you click to add up a series of numbers?

A. The autosum button

B. The Formula button

C. The quicktotal button

D. The total button

What is the correct answer?

4

Which of the following is not a valid data type in excel

A. Number

B. Character

C. Label

D. Date/time

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

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

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

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

Which setting you must modify to print a worksheet using letterhead?

A. Paper

B. Margin

C. Layout

D. Orientation

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

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

Which would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart

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

When a row of data is to be converted into columns

A. Copy the cells in row, select the same number of cells in row and paste

B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK

D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

What is the correct answer?

4

Which of the following is a popular DOS based spreadsheet package?

A. Word

B. Smart cell

C. Excel

D. Lotus 1-2-3

What is the correct answer?

4

How do you delete a column?

A. Select the column heading you want to delete and select the Delete Row button on the standard toolbar

B. Select the column heading you want to delete and select Insert Delete from the menu

C. Select the row heading you want to delete and select Edit>Delete from the menu

D. Right click the column heading you want to delete and select delete from the shortcut menu

What is the correct answer?

4

Documentation should include

A. Destination and users of the output data

B. Source of input data

C. Information on the purpose of the workbook

D. All of the above

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

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

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

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

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

A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

What is the correct answer?

4

Which of the following is not a valid data type in Excel?

A. Number

B. Character

C. Label

D. Date/Time

What is the correct answer?

4

Excel files have a default extension of

A. Xls

B. Xlw

C. Wk1

D. 123

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

When you link data maintained in an excel workbook to a word document

A. The word document cannot be edit

B. The word document contains a reference to the original source application

C. The word document must contain a hyperlink

D. The word document contains a copy of the actual data

What is the correct answer?

4

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip