Home
Current Affairs January 2024

What is the correct answer?

4

The Chart wizard term data categories refers to;

A. A chart plot area

B. A horizontal axis

C. The organization of individual values with a charts data series

D. The data range that supply chart data

Correct Answer :

B. A horizontal axis


Related Questions

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

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

Excel files have a default extension of

A. Xls

B. Xlw

C. Wk1

D. 123

What is the correct answer?

4

Tab scroll buttons are place on Excel screen

A. towards the bottom right corner

B. towards the bottom left corner

C. towards the top right corner

D. towards the top left corner

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

When a range is selected, how can you activate the previous cell?

A. Press the Alt key

B. Press Tab

C. Press Enter

D. None of above

What is the correct answer?

4

A circular reference is

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous

What is the correct answer?

4

In help menu of Excel, which of the following tabs are found?

A. Contents tab

B. Answer Wizard tab

C. Index tab

D. all of the above

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

B. no data will be entered in the adjacent cells

C. there is no suitable abbrevition for the text

D. there is not time to format the text

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

To create a formula, you can use:

A. Values but not cell references

B. Cell references but not values

C. Values or cell references although not both at the same time

D. Value and cell references

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

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

How do you display current date only in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

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 area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

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 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 indicates you that you can make selection?

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

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

Status indicators are located on the

A. Vertical scroll bar

B. Horizontal scroll bar

C. Formula bar

D. Standard toolbar

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

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

Concatenation of text can be done using

A. Apostrophe ( )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

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

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

A. 5430

B. 5436.80

C. 5436.8

D. 6.8

What is the correct answer?

4

Which of the following is not a basic step in creating a worksheet?

A. Save workbook

B. Modifiy the worksheet

C. Enter text and data

D. Copy the worksheet

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

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

What is the short cut key to replace a data with another in sheet?

A. Ctrl + R

B. Ctrl + Shift + R

C. Ctrl + H

D. Ctrl + F