Home
Current Affairs January 2024

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

Correct Answer :

D. None of the above


Related Questions

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

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

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

A. Pie chart

B. Row chart

C. Line chart

D. Column chart

What is the correct answer?

4

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

A. server

B. source

C. client

D. none

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

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

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

How do you select an entire column?

A. Select Edit > Select > Column from the menu

B. Click the column heading letter

C. Hold down the shift key as you click anywhere in the column

D. Hold down the Ctrl key as you click anywhere in the column

What is the correct answer?

4

When a range is selected, how can you activate the previous cell?

A. Press the Alt key

B. Press Tab

C. Press Enter

D. None of above

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

Tab scrolling button

A. Allow you to view a different worksheet

B. Allow you to view additional worksheet rows down

C. Allow you to view additional worksheet columns to the right

D. Allow you to view additional sheets tabs

What is the correct answer?

4

You can set Page Border in Excel from

A. From Border tab in Format Cells dialog box

B. From Border tool in Formatting toolbar

C. From Line Style tool in Drawing toolbar

D. You can not set page border in Excel

What is the correct answer?

4

To view a cell comment

A. click the edit comment command on the insert menu

B. click the display comment command on the window menu

C. position the mouse pointer over the cell

D. click the comment command on the view menu

What is the correct answer?

4

You cannot link excel worksheet data to a word document

A. With the right drag method

B. With a hyperlink

C. With the copy and paste special commands

D. With the copy and paste buttons on the standard toolbar

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

The Name box on to the left of formula bar

A. shows the name of workbook currently working on

B. shows the name of worksheet currently working on

C. shows the name of cell or range currently working on

D. None of above

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

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 elements of worksheet can be protected from accidental modification

A. Contents

B. Objects

C. Scenarios

D. All of above

What is the correct answer?

4

In help menu of Excel, which of the following tabs are found?

A. Contents tab

B. Answer Wizard tab

C. Index tab

D. all of the above

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

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

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

Where can you change automatic or manual calculation mode in Excel?

A. Double CAL indicator on status bar

B. Go to Tools >> Options >> Calculation and mark the corresponding radio button

C. Both of above

D. None of above

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

An excel workbook is a collection of

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and charts

What is the correct answer?

4

How do you rearrange the data in ascending or descending order?

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

What is the correct answer?

4

Which of the following you can paste selectively using Paste Special command?

A. Validation

B. Formats

C. Formulas

D. All of above

What is the correct answer?

4

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

A. F8

B. F9

C. F10

D. F11