A typical worksheet has …. Number of columns

Question

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

Correct Answer :

B. 256

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

Microsoft Excel is a powerful ...........

Discuss this answer

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

Discuss this answer

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?

Discuss this answer

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

Discuss this answer

Where can you change automatic or manual calculation mode in Excel?

Discuss this answer

Which of the following is not a way to complete a cell entry?

Discuss this answer

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

Discuss this answer

Which command will you choose to convert a column of data into row?

Discuss this answer

Which menu option can be used to split windows into two?

Discuss this answer

You can use the formula pallette to

Discuss this answer

Concatenation of text can be done using

Discuss this answer

Concatenation of text can be done using

Discuss this answer

Comments put in cells are called .....

Discuss this answer

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

A. 350

C. 0.57

Discuss this answer

To select an entire column in MS-EXCEL, press?

Discuss this answer

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

C. now ()

Discuss this answer

How can you show or hide the gridlines in Excel Worksheet?

Discuss this answer

Which of the following is the oldest spreadsheet package?

C. Excel

Discuss this answer

Which of the following is invalid statement?

Discuss this answer

The name box

Discuss this answer

How do you rearrange the data in ascending or descending order?

Discuss this answer

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

Discuss this answer

B7:B9 indicates:

Discuss this answer

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

Discuss this answer

To edit in an embedded excel worksheet object in a word document

Discuss this answer

You can copy data or formulas

Discuss this answer

Which of the following is not true regarding Conditional Formatting?

Discuss this answer

The chart wizard term data series refers to

Discuss this answer

How do you insert a row?

Discuss this answer

Files created with Lotus 1-2-3 have an extension

A. DOC

B. XLS

C. 123

D. WK1

Discuss this answer

Answer 1

A. Word processing package

Answer 2

B. Spreadsheet package

Answer 3

C. Communication S/W Package

Answer 4

D. DBMS package

Answer 5

A. Custom List

Answer 6

B. Auto Fill Options

Answer 7

C. Fill Across Worksheet

Answer 8

D. Fill Series

Answer 9

A. Press the Alt key

Answer 10

B. Press Tab

Answer 11

C. Press Enter

Answer 12

D. None of above

Answer 13

A. Double CAL indicator on status bar

Answer 14

B. Go to Tools >> Options >> Calculation and mark the corresponding radio button

Answer 15

C. Both of above

Answer 16

D. None of above

Answer 17

A. Pressing enter

Answer 18

B. Pressing any arrow key on the keyboard

Answer 19

C. Clicking the Enter button on the Formula bar

Answer 20

D. Pressing spacebar

Answer 21

A. Contents tab

Answer 22

B. Answer Wizard tab

Answer 23

C. Index tab

Answer 24

D. all of the above

Answer 25

A. Cut and Paste

Answer 26

B. Edit >> Paste Special >> Transpose

Answer 27

C. Both of above

Answer 28

D. None of above

Answer 29

A. Format -> Window

Answer 30

B. View -> Window-> Split

Answer 31

C. Window -> Split

Answer 32

D. View > Split

Answer 33

A. format cells containing numbers

Answer 34

B. create and edit formula containing functions

Answer 35

C. enter assumptions data

Answer 36

D. copy a range of cells

Answer 37

A. Apostrophe ( )

Answer 38

B. Exclamation ( ! )

Answer 39

C. Hash ( # )

Answer 40

D. Ampersand ( & )

Answer 41

A. Apostrophe (&lsquo

Answer 42

B. Exclamation (!)

Answer 43

C. Hash (#)

Answer 44

D. Ampersand (&

Answer 45

A. Smart Tip

Answer 46

B. Cell Tip

Answer 47

C. Web Tip

Answer 48

D. Soft Tip

Answer 49

B. May 10, 2001

Answer 50

D. Serial Number 50771

Answer 51

A. CTRL + C

Answer 52

B. CTRL + Arrow key

Answer 53

C. CTRL + S

Answer 54

D. None of the above

Answer 55

A. date ()

Answer 56

B. Today ()

Answer 57

D. time ()

Answer 58

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

Answer 59

B. Click Gridline tool on Forms toolbar

Answer 60

C. Both of above

Answer 61

D. None of above

Answer 62

A. VisiCalc

Answer 63

B. Lotus 1-2-3

Answer 64

D. StarCalc

Answer 65

A. Sheet tabs can be colored

Answer 66

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

Answer 67

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

Answer 68

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

Answer 69

A. Shows the location of the previously active cell

Answer 70

B. Appears to the left of the formula bar

Answer 71

C. Appears below the status bar

Answer 72

D. Appears below the menu bar

Answer 73

A. Data, Sort

Answer 74

B. Data, Form

Answer 75

C. Data, Table

Answer 76

D. Data Subtotals

Answer 77

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

Answer 78

B. Widen the columns

Answer 79

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

Answer 80

D. Format the cells with the comma style

Answer 81

A. Cells B7 and cell B9 only

Answer 82

B. Cells B7 through B9

Answer 83

C. Cell B8 only

Answer 84

D. None of the above

Answer 85

D. none of above

Answer 86

A. Use the excel menu bar and toolbars inside the word application

Answer 87

B. Edit the hyperlink

Answer 88

C. Edit the data in a excel source application

Answer 89

D. Use the word menu bar and toolbars

Answer 90

A. With the copy, paste and cut commands on the edit menu

Answer 91

B. With commands on the shortcut menu

Answer 92

C. With buttons on the standard toolbars

Answer 93

D. All of the above

Answer 94

A. You can add more than one condition to check

Answer 95

B. You can set condition to look for Bold and apply Italics on them

Answer 96

C. You can apply Font, border and pattern formats that meets the specified conditions

Answer 97

D. You can delete any condition from Conditional Formatting dialog box if it is not requried

Answer 98

A. A chart legend

Answer 99

B. A collection of chart data markers

Answer 100

C. A set of values you plot in a chart

Answer 101

D. A data label

Answer 102

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

Answer 103

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

Answer 104

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

Answer 105

D. All of the above

A typical worksheet has …. Number of columns

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Microsoft Excel is a powerful ...........

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

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?

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

Where can you change automatic or manual calculation mode in Excel?

Which of the following is not a way to complete a cell entry?

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

Which command will you choose to convert a column of data into row?

Which menu option can be used to split windows into two?

You can use the formula pallette to

Concatenation of text can be done using

Concatenation of text can be done using

Comments put in cells are called .....

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

To select an entire column in MS-EXCEL, press?

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

How can you show or hide the gridlines in Excel Worksheet?

Which of the following is the oldest spreadsheet package?

Which of the following is invalid statement?

The name box

How do you rearrange the data in ascending or descending order?

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

B7:B9 indicates:

How many worksheets can a workbook have?

To edit in an embedded excel worksheet object in a word document

You can copy data or formulas

Which of the following is not true regarding Conditional Formatting?

The chart wizard term data series refers to

How do you insert a row?

Files created with Lotus 1-2-3 have an extension

Also checkout