Home
Current Affairs January 2024

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

Correct Answer :

A. Use the excel menu bar and toolbars inside the word application


Related Questions

What is the correct answer?

4

Rounding errors can occur

A. When you use multiplication, division, or exponentiation in a formula

B. When you use addition and subtraction in a formula

C. Because excel uses hidden decimal places in computation

D. When you show the results of formulas with different decimal places that the calculated results

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

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

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

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

A. An absolute cell address is created

B. Cell address will change when it is copied to another cell

C. The sheet tab is changed

D. The status bar does not display the cell address

What is the correct answer?

4

In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

What is the correct answer?

4

You can convert existing excel worksheet data an charts to an HTML document by using

A. FTP wizard

B. Internet assistant wizard

C. Intranet wizard

D. Import wizard

What is the correct answer?

4

Excel probably considers the cell entry January 1, 2000 to be a

A. Label

B. Value

C. Formula

D. Text string

What is the correct answer?

4

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

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

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

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

A. AutoFill

B. Auto correct

C. Auto sum

D. Auto format

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

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

Which of the following is not true about Find and Replace in Excel

A. You can search for bold and replace with italics

B. You can decide whether to look for the whole word or not

C. You can search in formula too

D. You can search by rows or columns or sheets

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

Concatenation of text can be done using

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

What is the correct answer?

4

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

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

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

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

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

A. WINDOWS

B. DOS

C. UNIX

D. OS/2

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

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

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

A. Custom List

B. Auto Fill Options

C. Fill Across Worksheet

D. Fill Series

What is the correct answer?

4

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

A. Use =if() function to format the required numbers red

B. Apply Conditional Formatting command on Format menu

C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

D. All of above

What is the correct answer?

4

In Excel, a Data Series is defined as what?

A. A type of chart

B. A cell reference

C. A collection of related data

D. A division of results

What is the correct answer?

4

How can you remove borders applied in cells?ACC

A. Choose None on Border tab of Format cells

B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)

C. Both of above

D. None of above

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