MS Excel adds a space for insignificant zeros on either side of the decimal point If the number has fewer digits than the number of digit-placeholders so decimal points are aligned in the column. Which digit-placeholder will do this;

Correct! Wrong!

In MS Excel, when you copy and paste a selection of rows, hidden rows:

Correct! Wrong!

You can copy cell formats from one cell to another by using the:

Correct! Wrong!

A custom number format that accepts the value "2.65LBS" is defined by

Correct! Wrong!

Advertisement

To copy a cell A1 to 81 user may

Correct! Wrong!

In MS Excel, when you choose an image to be displayed as Background of the sheet;

Correct! Wrong!

To define a custom number format which accepts the value "2.65LBS", user needs to:

Correct! Wrong!

In MS Excel, 'Merge cells' option does not work when :

Correct! Wrong!

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

Correct! Wrong!

In MS Excel, the difference between entering current date by Ctr+; and by today() is :

Correct! Wrong!

The Accounting Number style shows Negative numbers in:

Correct! Wrong!

After entering a text or number in a cell you press:

Correct! Wrong!

In MS Excel, 1f column A is filled with a series starting from 21 and column B is filled with a series starting from 31; Merging cells A11 B13 will result into :

Correct! Wrong!

To quickly format a worksheet one should?

Correct! Wrong!

To format a cell, user needs to open Format cell Dialogue box, to open format cell Dialogue box user will :

Correct! Wrong!

'Autoformat as you type' option can be found in:

Correct! Wrong!

The Custom format [$#,,,"M";J will make the value 19879879879 appear as :

Correct! Wrong!

In MS Excel. you can NOT hide a :

Correct! Wrong!

In MS Excel, a custom number format can have up to following code sections separated by semicolon:

Correct! Wrong!

If a user wishes to change whole column of dates from Turkish format to US format :

Correct! Wrong!

CA CAF IT - MCQs # 8: FORMATTING DATA AND CONTENTS I
Congratulations You PASS :)

Sorry You FAIL :( Better Luck Next Time

Share your Results:

Please share this quiz to view your results.

Quiz by TEST MCQ SKILLS