1. To display Format cells dialog box you have to press

The correct answer is: a. Ctrl + 1 Pressing Ctrl + 1 will display the "Format Cells" dialog box in applications like Microsoft Excel. This dialog box allows you to format the selected cells in various ways, such as changing the number format, applying borders, and modifying font styles.

2. To enter the current data press

The correct answer is: a. Ctrl + ; Pressing Ctrl + ; (semicolon) is the keyboard shortcut to enter the current date in applications like Microsoft Excel. It inserts the current date into the selected cell.

3. Text control group of Alignment property sheet contains which of the following function

The correct answer is: d. All of the above In Microsoft Excel, "Wrap Text," "Shrink to Fit," and "Merge Cells" are all formatting options: "Wrap Text": This option wraps text within a cell, displaying it on multiple lines if necessary. "Shrink to Fit": This option reduces the font size of the text in a cell to fit it within the cell's width. "Merge Cells": This option combines multiple cells into one larger cell, typically used for creating headings or labels that span across multiple columns or rows.

4. To format characters in a sheet, use

To format characters in a spreadsheet, you can use a combination of methods: a. Shortcut keys: Keyboard shortcuts can be used to quickly apply formatting to selected text. For example, in many spreadsheet applications, you can use shortcuts like Ctrl+B for bold, Ctrl+I for italic, and Ctrl+U for underline. b. Toolbar buttons: Most spreadsheet software includes a toolbar or ribbon with buttons for common formatting options. You can use these buttons to apply formatting such as bold, italic, underline, font size, font color, and more. c. Menu commands: Formatting options are often available in the menu bar of spreadsheet applications. You can navigate through the menus to find options for formatting characters, such as changing font styles, sizes, colors, and alignment. d. Formatting options dialog: Many spreadsheet applications also provide a formatting options dialog where you can access advanced formatting settings for characters, such as adjusting spacing, applying borders, or setting text effects. So, to format characters in a sheet, you can use any combination of these methods depending on your preference and the specific formatting you want to apply.

5. By, default, excel sheet display the following front style

By default, Excel sheets display text in the regular font style, which is typically not strikethrough, bold, or italic. The default font in Excel is usually Calibri or Arial, and the text is displayed in a normal, unformatted style.

6. Formulas are made up of

a. Arithmetic operations such as =, +, -, and other functions Formulas in Excel are composed of a combination of arithmetic operations (such as addition, subtraction, multiplication, and division) and functions (such as SUM, AVERAGE, VLOOKUP, etc.).

7. Once a range has been named, you can go to a range

8. The built in default copying in excel is programmed to

a. Use relative position when copying formulas By default, Excel uses relative references when copying formulas. This means that the cell references in the formula adjust relative to the position where the formula is copied. For example, if you copy a formula from cell A1 to cell B1, a reference to A1 in the original formula will change to B1 in the copied formula.

9. Formulas with absolute references are references that always.

c. Refer to the same cells, regardless of the location of the formula Formulas with absolute references always refer to the same specific cells, regardless of where the formula is copied. This is achieved by using the dollar sign ($) in the cell references (e.g., $A$1).

10. The today() function enters the current

c. System date only The TODAY() function in Excel returns the current system date only, without the time. If you need both the current date and time, you would use the NOW() function.

11. A function in Excel

In Excel, a function: Is a readymade formula designed to perform specific calculations. Acts as a shortcut to more complex formulas, allowing users to perform calculations quickly and efficiently. Can be built using the Function Wizard, which helps users insert functions and provides guidance on the required arguments.

12. Mark the most appropriate statement

The NOW() function in Excel returns both the current date and the current time in the same cell.

13. Which of the following is not a financial function?

The SUM() function is not a financial function; it is a basic mathematical function used to add up a range of numbers. The other options, FV(), NPV(), and PMT(), are all financial functions used for various financial calculations such as future value, net present value, and payment amount, respectively.

14. =ROUND (2.15, 1) entered in a cell displays

=ROUND(2.15, 1) entered in a cell displays: 2.2 The ROUND() function rounds a number to a specified number of digits. In this case, it rounds 2.15 to 1 decimal place, resulting in 2.2.

15. = MOD (-3, 2) entered in a cell displays

The MOD() function in Excel returns the remainder after a number is divided by another number. In this case, -3 divided by 2 equals -1 with a remainder of 1, so the result displayed would be 1.

16. Creating an object as a smart object will allow us to perform operations on it without affecting its ____.

Creating an object as a smart object in image editing software like Adobe Photoshop allows you to perform operations on it without affecting its image quality. Smart objects preserve the original image data, enabling non-destructive editing.

17. The ____ effect will be applied to the modified content when the layer's content is edited or moved.

When the layer's content is edited or moved in image editing software like Adobe Photoshop, the same effect will be applied to the modified content. This ensures consistency in the applied effects across the entire layer.

18. Which of the following layer style options is present in Photoshop?

19. Which of the following shape tools is supported by Photoshop?

20. Create an object centered at the selected point by pressing which of the following keys?

To create an object centered at the selected point in Adobe Photoshop, you typically follow these steps: Select the shape tool you want to use (e.g., Rectangle Tool, Ellipse Tool, etc.). Click and drag to create the shape. While dragging, press and hold the Alt key (Option key on Mac) to draw the shape from its center outward.

21. TDS deduction entry can be made through

22. Bank OCC A/C is a group defined under

Bank OCC A/C is typically defined under the "Bank Accounts" group. This group categorizes all bank-related accounts, including various bank accounts such as current accounts, savings accounts, overdraft accounts, etc. within the chart of accounts.

23. ETCS means

The Electronic Tax Collection at Source (ETCS) system is designed to collect taxes at the source of income electronically. Here's how it generally works: Identification of Income: The tax authority identifies certain types of income that are subject to tax collection at the source. This could include interest income, dividend income, rental income, commission income, etc. Notification to Deductor: The entity or individual responsible for making payments to the income earners (referred to as the deductor) is notified by the tax authority about the requirement to deduct tax at source. Deduction of Tax: When the deductor makes a payment to the income earner, they deduct the applicable tax amount from the payment at the specified rate and remit it to the tax authority. Electronic Submission: The deductor electronically submits the tax deducted at source (TDS) information to the tax authority along with the payment. Credit to Taxpayer: The tax deducted at source is credited to the account of the taxpayer with the tax authority. The taxpayer can claim credit for this tax deduction when filing their tax return. Compliance and Reporting: Both the deductor and the income earner are required to comply with reporting requirements related to tax deduction at source. This includes providing relevant documentation and information to the tax authority as necessary. Overall, ETCS streamlines the process of tax collection by automating the deduction and remittance of taxes at the source of income, reducing administrative burden and improving tax compliance.

24. We can see list of Memorandum voucher from

In accounting software, the list of Memorandum vouchers is typically accessible from Exception Reports. Memorandum vouchers are non-accounting vouchers that are used for recording transactions for internal purposes or for reference, but they do not affect the balances of ledger accounts. Therefore, they are often listed separately in exception reports or similar reports for review and reconciliation purposes.

25. Recording of actual stock as physically verified or counted is done through

Recording of actual stock as physically verified or counted is typically done through a process called "Physical Stock Verification" or "Stock Taking." This involves physically counting the items in inventory to reconcile them with the records in the accounting system. Once the physical count is completed, any discrepancies are identified and adjustments are made to the inventory records. In accounting software, this process is often facilitated through functionalities such as Stock Journal entries or Inventory Adjustment transactions, where the actual stock counts are entered and compared against the system records to update the inventory levels accordingly.

26. What is coral draw?

CorelDRAW is a vector graphics editor developed and marketed by Corel Corporation. It is primarily used for creating logos, illustrations, layouts, and other types of graphical content. CorelDRAW allows users to create and edit vector-based images, which are images composed of lines and shapes defined by mathematical equations, as opposed to raster graphics, which are made up of pixels. The software provides tools for drawing shapes, lines, and curves, as well as for adding text, colors, and effects to designs. It also includes features for working with layers, managing colors, and exporting designs in various file formats. CorelDRAW has been a popular tool among graphic designers, illustrators, and other professionals for many years due to its versatility, user-friendly interface, and wide range of features.

27. Corel Draw was developed by

Corel Draw was developed by Corel Corporation, a Canadian software company. It was originally released in 1989, with its first version known as CorelDRAW 1. Corel Corporation has continued to develop and release newer versions of CorelDRAW over the years, evolving the software into a comprehensive graphic design and illustration tool.

28. The CorelDraw, was initially released in .............

CorelDRAW was initially released in January 1989. This marked the debut of the software, developed by Corel Corporation, as a vector graphics editor. Since its inception, CorelDRAW has been widely used for designing logos, illustrations, and various types of graphical artwork.

29. Corel draw was written in ...............

CorelDRAW was written primarily in C and C++. These programming languages are commonly used for developing software applications, and they were instrumental in creating CorelDRAW's functionalities and capabilities as a vector graphics editor.

30. CorelDraw Graphics Suite was originally developed for ............

CorelDraw Graphics Suite was originally developed for Microsoft Windows. It was designed to run on Windows operating systems, starting with its initial release in 1989. Over the years, Corel Corporation has expanded its software offerings to include versions for macOS as well, but its origins and primary development focus have been on the Windows platform.

31. What is the extension of corel draw?

The file extension typically used for CorelDRAW files is .cdr. This extension is associated with files created and saved in CorelDRAW, which is the primary application within the CorelDRAW Graphics Suite for creating vector graphics and illustrations.

32. CorelDraw is a _________ based drawing Application Package.

CorelDraw is a vector based drawing Application Package. It is designed primarily for creating vector graphics, which use mathematical equations to define shapes, lines, and colors. This allows for scalability without loss of quality, making it ideal for tasks such as logo design, illustration, and printing.

33. The ruler bar is used for ..........

The ruler bar in CorelDRAW is used for measuring and aligning objects within your workspace. It provides visual indicators such as rulers, gridlines, and guidelines that help you position and align elements precisely. Here are some of its primary functions: Measuring: You can use the ruler bar to measure the size of objects or the distances between objects in your document. Aligning: The ruler bar helps in aligning objects along a straight line or to specific gridlines or guidelines. Setting Guides: You can drag guides from the ruler bar onto your document to create precise alignment references for objects. Adjusting Units: The ruler bar allows you to switch between different units of measurement (e.g., inches, centimeters, pixels) depending on your preference or project requirements. Overall, the ruler bar enhances precision and accuracy when working with elements in your CorelDRAW project.

34. How many color separation in CorelDraw?

In CorelDRAW, you can perform color separations manually or through automated processes, depending on your needs for printing or outputting designs. Here are the main types of color separations you can work with: Spot Color Separations: These are separations based on specific spot colors defined in your document. Spot colors are pre-mixed inks that are applied to print jobs separately from process colors (CMYK). Process Color Separations: These separations are based on the four process colors: Cyan, Magenta, Yellow, and Black (CMYK). Process color separations are typically used for full-color printing. RGB Color Separations: This refers to separating colors based on the Red, Green, and Blue (RGB) color model. RGB separations are more common in digital artwork and screen-based designs rather than print. Custom Color Separations: CorelDRAW allows you to create custom color separations based on specific color models or requirements for your project. The exact method and number of separations you use will depend on factors such as your design, printing method, and color requirements. CorelDRAW provides tools and settings to manage and control color separations effectively for different output scenarios.

35. What is the shortcut key to combine the selected objects?

In CorelDRAW, the shortcut key to combine selected objects into a single object is Ctrl + L. This action merges the selected objects into one, which can be useful for simplifying complex shapes or preparing elements for further editing or formatting.

36. What is the shortcut key to toggles snapping to objects?

In CorelDRAW, the shortcut key to toggle snapping to objects on and off is Alt + Z. This keyboard shortcut allows you to quickly enable or disable snapping to objects, which can be helpful for precise positioning and alignment of elements in your design.

37. What is the shortcut key to specifies fountain flits for objects in corel draw?

In CorelDRAW, the shortcut key to specify fountain fills for objects is F11. Pressing F11 opens the Fountain Fill dialog box, where you can choose and customize gradients and fountain fills for selected objects. This allows you to apply intricate color blends and gradients to shapes and elements in your designs.

38. In Corel Draw the keyboard shortcut to save your drawing is .............

In CorelDRAW, the keyboard shortcut to save your drawing is Ctrl + S. Pressing Ctrl + S will quickly save your current document. It's a good practice to use this shortcut regularly to ensure your work is saved periodically and to avoid losing any changes in case of unexpected interruptions.

39. Which tool is not a basic drawing tool in a 2d image program?

The Eyedropper Tool is indeed a useful tool in 2D image programs, but it is not typically considered a basic drawing tool. Basic drawing tools are primarily used to create and modify shapes and paths. These include: Rectangle Tool Ellipse Tool Pen Tool Line Tool Bezier Tool The Eyedropper Tool, on the other hand, is primarily used for sampling and applying colors or attributes from one part of the image or object to another. While it is essential for color matching and consistency in design, it does not directly contribute to the creation of shapes or paths, hence it is not classified as a basic drawing tool.

40. What is the shortcut key to specifies fountain fills for objects?

In CorelDRAW, the shortcut key to specify fountain fills for objects is F11. Pressing F11 opens the Fountain Fill dialog box, where you can choose and customize gradients and fountain fills for the selected objects.

41. What is the shortcut key to display a full screen preview of the graphic or drawing?

In CorelDRAW, the shortcut key to display a full-screen preview of the graphic or drawing is F9. Pressing F9 will show the drawing in full-screen mode, allowing you to preview your work without any distractions from the user interface.