Home
Current Affairs January 2024

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

Correct Answer :

C. Click the Currency Style button on the formatting toolbar


Related Questions

What is the correct answer?

4

Excel displays the current cell address in the ........

A. Formula bar

B. Status Bar

C. Name Box

D. Title Bar

What is the correct answer?

4

In Excel, the Fill Color button on the Formatting toolbar is used for what?

A. To insert a background

B. To add borders

C. To select a distribution of figures

D. To add shading or color to a cell range

What is the correct answer?

4

Edit >> Delete command

A. Deletes the content of a cell

B. Deletes Formats of cell

C. Deletes the comment of cell

D. Deletes selected cells

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

A. Cells

B. Rows

C. Columns

D. Document

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 information you can specify using the solver?

A. Input cells

B. Constraints

C. Target cell

D. Changing cells

What is the correct answer?

4

Data can be arranged in a worksheet in a easy to understand manner using

A. auto formatting

B. applying styles

C. changing fonts

D. all of above

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

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

You can use the formula palette to

A. Format cells containing numbers

B. Create and edit formulas containing functions

C. Enter assumptions data

D. Copy a range of cells

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

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

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

How do you display current date and time in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

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

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 enter which types of data into worksheet cells?

A. Labels, values, and formulas

B. Labels and values but not formulas

C. Values and formulas but not labels

D. Formulas only

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

You can edit a cell by

A. Clicking the formula button

B. Double clicking the cell to edit it in-place

C. Selecting Edit>Edit Cell from the menu

D. None of above

What is the correct answer?

4

When the formula bar is active, you can see

A. The edit formula button

B. The cancel button

C. The enter button

D. All of the above

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

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

Which of the following formulas will Excel Not be able to calculate?

A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

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

Which of the following action removes a sheet from workbook?

A. Select the sheet, then choose Edit >> Delete Sheet

B. Select the sheet then choose Format >> Sheet >> Hide

C. Both of above

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

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

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

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