Home
Current Affairs January 2024

What is the correct answer?

4

Which of the following is not a valid data type in excel

A. Number

B. Character

C. Label

D. Date/time

Correct Answer :

B. Character


Related Questions

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

You can use the format painter multiple times before you turn it off by

A. You can use the format painter button on ly one time when you click it

B. Double clicking the format painter button

C. Pressing the Ctrl key and clicking the format painter button

D. Pressing the Alt key and clicking the format painter button

What is the correct answer?

4

When you want to insert a blank imbedded excel object in a word document you can

A. Click the object command on the insert menu

B. Click the office links button on the standard toolbar

C. Click the create worksheet button on the formatting toolbar

D. Click the import excel command on the file menu

What is the correct answer?

4

You can set Page Border in Excel from

A. From Border tab in Format Cells dialog box

B. From Border tool in Formatting toolbar

C. From Line Style tool in Drawing toolbar

D. You can not set page border in Excel

What is the correct answer?

4

Which of the following is not a valid data type in Excel?

A. Number

B. Character

C. Label

D. Date/Time

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

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

Which of the following is not a worksheet design criterion?

A. Efficiency

B. Aditibility

C. Description

D. Clarity

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

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

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

How many characters can be typed in a single cell in Excel?

A. 256

B. 1024

C. 32000

D. 65535

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

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

Which of the following methods can not be used to edit the contents of a cell?

A. Press the Alt key

B. Clicking the formula bar

C. Pressing the F2 key

D. Double clicking the cell

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

Documentation should include

A. Destination and users of the output data

B. Source of input data

C. Information on the purpose of the workbook

D. All of the above

What is the correct answer?

4

Which is used to perform what if analysis?

A. Solver

B. Goal seek

C. Scenario Manager

D. All of above

What is the correct answer?

4

Getting data from a cell located in a different sheet is called ......

A. Accessing

B. Referencing

C. Updating

D. Functioning

What is the correct answer?

4

To record a sequence of keystrokes and mouse actions to play back later we use:

A. Media player

B. Sound Recorder

C. Calculator

D. Macro Recorder

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

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

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

Excel uniquely identifies cells within a worksheet with a cell name

A. Cell names

B. Column numbers and row letters

C. Column letters and row numbers

D. Cell locator coordinates

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

In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. &

What is the correct answer?

4

To view a cell comment

A. click the edit comment command on the insert menu

B. click the display comment command on the window menu

C. position the mouse pointer over the cell

D. click the comment command on the view menu

What is the correct answer?

4

The Paste Special command lets you copy and paste:

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula

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