Home
Current Affairs January 2024

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

Correct Answer :

B. Apply Conditional Formatting command on Format menu


Related Questions

What is the correct answer?

4

You can use the formula pallette to

A. format cells containing numbers

B. create and edit formula containing functions

C. enter assumptions data

D. copy a range of cells

What is the correct answer?

4

Right clicking something in Excel:

A. Deletes the object

B. Nothing the right mouse button is there for left handed people

C. Opens a shortcut menu listing everything you can do to the object

D. Selects the object

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

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

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

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

A. 256

B. 1024

C. 32000

D. 65535

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

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

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

Which of the following is not a worksheet design criterion?

A. Efficiency

B. Aditibility

C. Description

D. Clarity

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

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

We can save and protect the workbook by

A. Write Reservation Password

B. Protection Password

C. Read-only Recommended

D. Any of the above

What is the correct answer?

4

B7:B9 indicates:

A. Cells B7 and cell B9 only

B. Cells B7 through B9

C. Cell B8 only

D. None of the above

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

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

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

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 create a formula, you first:

A. Select the cell you want to place the formula into

B. Type the equals sign (=) to tell Excel that youre about to enter a formula

C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D. Choose the new command from the file menu

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

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

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

While Finding and Replacing some data in Excel, which of the following statement is valid?

A. You can Find and Replace within the sheet or workbook

B. Excel does not have option to match case for find

C. Both are valid

D. None are valid

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

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

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

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

A. Area

B. Line

C. Pie

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

To center worksheet titles across a range of cells, you must

A. Select the cells containing the title text plus the range over which the title text is to be centered

B. Widen the columns

C. Select the cells containing the title text plus the range over which the title text is to be enfettered

D. Format the cells with the comma style