Home
Current Affairs January 2024

What is the correct answer?

4

Comments can be added to cells using ......

A. Edit -> Comments

B. Insert -> Comment

C. File -> Comments

D. View > Comments

Correct Answer :

B. Insert -> Comment


Related Questions

What is the correct answer?

4

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

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

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

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 is not a term of MS-Excel?

A. Cells

B. Rows

C. Columns

D. Document

What is the correct answer?

4

Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

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

Which elements of a worksheet can be protected from accidental modification?

A. Contents

B. Objects

C. Scenarios

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

You can copy data or formulas

A. With the copy, paste and cut commands on the edit menu

B. With commands on the shortcut menu

C. With buttons on the standard toolbars

D. All of the above

What is the correct answer?

4

Which menu option can be used to split windows into two?

A. Format -> Window

B. View -> Window-> Split

C. Window -> Split

D. View > Split

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 can you find specific information in a list?

A. Select Tools > Finder from the menu

B. Click the Find button on the standard toolbar

C. Select Insert > Find from the menu

D. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

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

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

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

Multiple calculations can be made in a single formula using

A. standard formulas

B. array formula

C. complex formulas

D. smart formula

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 of the following series type is not valid for Fill Series dialog box?

A. Linear

B. Growth

C. Autofill

D. Time

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

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

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

Which language is used to create macros in Excel?

A. Visual Basic

B. C

C. Visual C++

D. Java

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

How can you show or hide the gridlines in Excel Worksheet?

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

B. Click Gridline tool on Forms toolbar

C. Both of above

D. None of above

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

It is acceptable to let long text flow into adjacent cells on a worksheet when

A. Data will be entered in the adjacent cells

B. No data will be entered in the adjacent cells

C. There is no suitable abbreviation of the text

D. There is not time to format the next

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

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