Home
Current Affairs January 2024

What is the correct answer?

4

The command Edit >> Fill Across Worksheet is active only when

A. One sheet is selected

B. When many sheets are selected

C. When no sheet is selected

D. None of above

Correct Answer :

B. When many sheets are selected


Related Questions

What is the correct answer?

4

The Cancel and Enter buttons appear in the:

A. Title bar

B. Formula bar

C. Menu bar

D. Sheet tabs

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

You can check the conditions against __________ when applying conditional formatting

A. Cell value

B. Formula

C. Both of above

D. None of above

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

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

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

A. Use =if() function to format the required numbers red

B. Apply Conditional Formatting command on Format menu

C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

D. All of 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

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

What are the tabs that appear at the bottom of each workbook called?

A. Reference tabs

B. Position tabs

C. Location tabs

D. Sheet tabs

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

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

A __________ is a grid with labeled columns and rows.

A. Dialog box

B. Worksheet

C. Clipboard

D. Toolbar

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 is not a valid data type in Excel?

A. Number

B. Character

C. Label

D. Date/Time

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

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command on the edit menu

D. Split command on the window menu

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

Excel probably considers the cell entry January 1, 2000 to be a

A. Label

B. Value

C. Formula

D. Text string

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

When you link data maintained in an excel workbook to a word document

A. The word document cannot be edit

B. The word document contains a reference to the original source application

C. The word document must contain a hyperlink

D. The word document contains a copy of the actual data

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

Ctrl + D shortcut key in Excel will

A. Open the font dialog box

B. Apply double underline for the active cell

C. Fill down in the selection

D. None of above

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

What is represented by the small, black square in the lower-right corner of an active cell or range?

A. Copy handle

B. Fill handle

C. Insert handle

D. Border

What is the correct answer?

4

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

A. DOC

B. XLS

C. 123

D. WK1

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

We can save and protect the workbook by

A. Write Reservation Password

B. Protection Password

C. Read-only Recommended

D. Any of the above

What is the correct answer?

4

Which menu option can be sued to split windows into two

A. Format > window

B. View > window > split

C. Window > split

D. View > split

What is the correct answer?

4

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum