Home
Current Affairs January 2024

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

Correct Answer :

B. array formula


Related Questions

What is the correct answer?

4

The first cell in EXCEL worksheet is labeled as

A. AA

B. A1

C. Aa

D. A0

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

How do you display current date only in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

What is the correct answer?

4

How can you delete a record?

A. Delete the column from the worksheet

B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

C. Select Data > Delete Record from the menu

D. Click the Delete button on the Standard toolbar

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

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

Comments can be added to cells using

A. Edit > Comments

B. Insert > Comments

C. File > Comments

D. View > Comments

What is the correct answer?

4

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

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

What is represented by the small, black square in the lower-right corner of an active cell or range?

A. Copy handle

B. Fill handle

C. Insert handle

D. Border

What is the correct answer?

4

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

A. None of these

B. Select Format > Money from the menu

C. Click the Currency Style button on the formatting toolbar

D. You have to retype everything and manually add the dollar signs, commas, and decimals

What is the correct answer?

4

What is the correct way to refer the cell A10 on sheet3 from sheet1?

A. sheet3!A10

B. sheet1!A10

C. Sheet3.A10

D. A10

What is the correct answer?

4

Which of the following formulas is not entered correctly?

A. =10+50

B. 10+50

C. =10+50

D. =B7+14

What is the correct answer?

4

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command on the edit menu

D. Split command on the window menu

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

You can move a sheet from one workbook into new book by

A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK

B. From Edit menu choose Move of Copy then choose (Move to end) and click OK

C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

D. None of above

What is the correct answer?

4

Which of the following is not an example of a value?

A. 350

B. May 10, 2001

C. 0.57

D. Serial Number 50771

What is the correct answer?

4

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

A. work sheet

B. chart sheet

C. module sheet

D. data sheet

What is the correct answer?

4

How do you insert a row?

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

B. Select the row heading where you want to insert the new row and select Edit >Row from the menu

C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

D. All of the above

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

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

Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

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

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

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

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

Which of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1

What is the correct answer?

4

Which of the cell pointer indicates that you can fill series?

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

The active cell:

A. is defined by a bold border around the cell

B. Receives the data the user enters

C. It is the formula bar

D. Only A and B

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