Home
Current Affairs January 2024

What is the correct answer?

4

Tab scroll buttons are place on Excel screen

A. towards the bottom right corner

B. towards the bottom left corner

C. towards the top right corner

D. towards the top left corner

Correct Answer :

B. towards the bottom left corner


Related Questions

What is the correct answer?

4

The short cut key Ctrl + R is used in Excel to

A. Right align the content of cell

B. Remove the cell contents of selected cells

C. Fill the selection with active cells to the right

D. None of above

What is the correct answer?

4

A numeric value can be treated as a label value if it precedes with

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

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 Chart can be created in Excel?

A. Area

B. Line

C. Pie

D. All of the above

What is the correct answer?

4

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

A. Option buttons

B. List boxes

C. Text boxes

D. Combo boxes

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

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

A. WINDOWS

B. DOS

C. UNIX

D. OS/2

What is the correct answer?

4

You can use the horizontal and vertical scroll bars to

A. Split a worksheet into two panes

B. View different rows and columns edit the contents of a cell

C. Edit the contents of a cell

D. view different worksheets

What is the correct answer?

4

The name box

A. Shows the location of the previously active cell

B. Appears to the left of the formula bar

C. Appears below the status bar

D. Appears below the menu bar

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

What does COUNTA () function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

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

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

Which of the following methods can not be used to edit the contents of a cell?

A. Press the Alt key

B. Clicking the formula bar

C. Pressing the F2 key

D. Double clicking the cell

What is the correct answer?

4

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

What is the correct answer?

4

Which of the following is not a term of MS-Excel?

A. Cells

B. Rows

C. Columns

D. Document

What is the correct answer?

4

What are the tabs that appear at the bottom of each workbook called?

A. Reference tabs

B. Position tabs

C. Location tabs

D. Sheet tabs

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

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

Edit >> Delete command

A. Deletes the content of a cell

B. Deletes Formats of cell

C. Deletes the comment of cell

D. Deletes selected cells

What is the correct answer?

4

Where can you set the shading color for a range of cells in Excel?

A. Choose required color form Patterns tab of Format Cells dialog box

B. Choose required color on Fill Color tool in Formatting toolbar

C. Choose required color on Fill Color tool in Drawing toolbar

D. All of above

What is the correct answer?

4

How do you display current date only in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

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

You can use the formula palette to

A. Format cells containing numbers

B. Create and edit formulas containing functions

C. Enter assumptions data

D. Copy a range of cells

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

A __________ is a grid with labeled columns and rows.

A. Dialog box

B. Worksheet

C. Clipboard

D. Toolbar

What is the correct answer?

4

Which of the following action removes a sheet from workbook?

A. Select the sheet, then choose Edit >> Delete Sheet

B. Select the sheet then choose Format >> Sheet >> Hide

C. Both of above

D. None of above

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

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

A. 256

B. 1024

C. 32000

D. 65535

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