Thursday , October 29 2020

CA AFC-4 IT – MCQs # 10: FORMATTING DATA AND CONTENTS III

CA  AFC-4 IT – MCQs # 10: FORMATTING DATA AND CONTENTS III

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 # 10: FORMATTING DATA AND CONTENTS III

  • This Quiz is related to  FORMATTING DATA AND CONTENTS -III  Quiz# 10 in this series
  • The Quiz based on the Topic, ” FORMATTING DATA AND CONTENTS  – III 
  • 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:

While editing Format Style '2-color scale' In "New Formatting Rule" Dialogue box, which of the following fields have attributes 'Lowest value' and 'Highest value':

Correct! Wrong!

While editing "Format Only Cells that contain" In "New Formatting Rule" Dialogue box, in 'edit the rule description'. "format only cells with "may contain

Correct! Wrong!

How will the phone number 111000222 be displayed if location is changed lo Canada?

Correct! Wrong!

The custom format to write date as "Friday, June 27, 2014" is:

Correct! Wrong!

Advertisement

If a user wishes to convert values from one column to one row;

Correct! Wrong!

Print Titles button is used for:

Correct! Wrong!

"Conditional Formatting Rule Manager· can be awoke by :

Correct! Wrong!

Shortcut key for "GO TO" is :

Correct! Wrong!

We have a list of employees in MS Excel. In Column A First Name of employees rs stored and in Column B the Last Name is stored. For some office purpose we need to print a list of employees with complete names shown as Last Name, First Name; What will we do get the names in this order m first place?

Correct! Wrong!

The handler rs used to drag the selection. What if the selection rs dragged inside?

Correct! Wrong!

Magnification of a sheet through zoom will make your worksheet :

Correct! Wrong!

While editing Format Style '2-color scale' In "New Formatting Rule" Dialogue box, which of the following fields have attributes 'Minimum' and 'Maximum'

Correct! Wrong!

In MS Excel, the most appropriate option to highlight the records of aged trade receivables for 3,427 accounts where the ageing ranges from 30 to 60 days, is :

Correct! Wrong!

"Clear rules" in conditional formatting works on :

Correct! Wrong!

User can save specific display settings such as hidden columns, filter settings etc. in a:

Correct! Wrong!

CA AFC 4 IT – MCQs # 10: FORMATTING DATA AND CONTENTS III
Congratulations! You PASS 🙂

Sorry You FAIL 🙂 Let's Try Again

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: