Home
Current Affairs January 2024

What is the correct answer?

4

What do you mean by a Workspace?

A. Group of Columns

B. Group of Worksheets

C. Group of Rows

D. Group of Workbooks

Correct Answer :

D. Group of Workbooks


Related Questions

What is the correct answer?

4

Which of the following options is not located in the Page Setup dialog box?

A. Page Break Preview

B. Page Orientation

C. Margins

D. Headers and Footers

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

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

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

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

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

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

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

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

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 symbol must all formula begin with?

A. =

B. +

C. (

D. @

What is the correct answer?

4

How can you print three copies of a workbook?

A. Select File > Properties form the menu and type 3 in the Copies to print text box

B. Select File > Print from the menu and type 3 in the Number of copies text box

C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made

D. Press Ctrl+P+3

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

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

To remove the content of selected cells you must issue ______ command

A. Edit >> Delete

B. Edit >> Clear >> Contents

C. Edit >> Clear >> All

D. Data >> Delete

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 select a single range of cells by

A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B. Pressing the Ctrl key while dragging over the desired cells

C. Pressing the Shift key and an arrow key

D. Dragging over the desired cells

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

You can copy data or formulas

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

B. With commands on the shortcut menu

C. With buttons on the standard toolbars

D. All of the above

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

What is the short cut key to highlight the entire column?

A. Ctrl+C

B. Ctrl+Enter

C. Ctrl+Page Up

D. Ctrl+Space Bar

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 of the following is not the correct method of editing the cell content?

A. Press the Alt key

B. Press the F2 key

C. Click the formula bar

D. Double click the cell

What is the correct answer?

4

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A. Logical

B. Math & Trigonometry

C. Statistical

D. Financial

What is the correct answer?

4

Where can you set the shading color for a range of cells in Excel?

A. Choose required color form Patterns tab of Format Cells dialog box

B. Choose required color on Fill Color tool in Formatting toolbar

C. Choose required color on Fill Color tool in Drawing toolbar

D. All of above

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

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

Which of the following is the latest version of Excel

A. Excel 2000

B. Excel 2002

C. Excel ME

D. Excel XP

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 Chart can be created in Excel?

A. Area

B. Line

C. Pie

D. All of the above