Thursday , October 29 2020

CA AFC-4 IT – MCQs # 8: FORMATTING DATA AND CONTENTS I

CA AFC-4 IT – MCQs # 8: FORMATTING DATA AND CONTENTS I

CS & IT Mcqs for CA, Educators, NTS, PPSC, FPSC Exams

All these MCQs are collected and gathered from different past papers and Books to help you to pass the CA AFC students, Educators, NTS, FPSC, PPSC Exams and different Computer and IT related Tests. It also beneficial for Accountant and Finance manager Posts covering IT related test portion.

CA AFC-4 IT – MCQs # 8: FORMATTING DATA AND CONTENTS I

  • This Quiz is related to  FORMATTING DATA AND CONTENTS -I  Quiz# 8  in this series
  • The Quiz based on the Topic, ” FORMATTING DATA AND CONTENTS  – I 
  • If you have good understanding about the subject, then you can attempt it
  • There will be 10 Multiple Choice Questions (MCQs) in this test
  • You have 60 Seconds to answer a single Multiple Choice Question
  • Questions will be randomly changed every time you start this test
  • You should practice more and more to get high marks
  • Passing Criteria is 60 percent for this Quiz
  • You can retake this test as many time as you like
  • The progress bar at the top of screen will show your progress as well as the time remaining where timed quiz
  • After the quiz, You will find Your Test Score and Grade
  • If you feel that any Incorrect Answer to a Question, simply Comment us about the Question.

Advertisement:

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

Correct! Wrong!

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

Correct! Wrong!

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

Correct! Wrong!

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

Correct! Wrong!

Advertisement

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

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!

To copy a cell A1 to 81 user may

Correct! Wrong!

In MS Excel. you can NOT hide a :

Correct! Wrong!

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

Correct! Wrong!

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

Correct! Wrong!

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

Correct! Wrong!

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

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!

The Accounting Number style shows Negative numbers in:

Correct! Wrong!

To quickly format a worksheet one should?

Correct! Wrong!

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, 'Merge cells' option does not work when :

Correct! Wrong!

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

Correct! Wrong!

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

Correct! Wrong!

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

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.

Advertisement:

Might You Like Followings:

Check Also

CA AFC-4 MCQs # 5 : SECURITY AND SAFEGUARDING YOUR WORK

CA AFC-4 MCQs # 5 : SECURITY AND SAFEGUARDING YOUR WORK  CS & IT Mcqs …

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: