CUET Accountancy Computerised Accounting > Spreadsheet PYQs

Which Excel function is commonly used to calculate loan repayment instalments?

What is the correct formula for calculating total depreciation on an asset?

How do you display or hide the horizontal and vertical axes in a chart?

What element can you show or hide to improve clarity in the background of the chart?

What allows you to reposition or change the size of a chart on the worksheet?

Which Excel function is used to calculate depreciation under Straight Line Method (SLM)?

How is the Net Salary (NS) of an employee determined?

What kind of data is best displayed with a bar chart?

What is the difference between TODAY() and NOW() Function?

What would be the syntax for "IF" Function to get a result of Pass or Fail If Passing criteria is 40% and above. Further percentage of marks is available in Cell A1?

Array formulas are enclosed between __________.

PV function returns the present value of an investment. The syntax of the function is PV (rate, nper, pmt, fv, type). What does NPER stands for?

The error ##### occurs when? (A) Column is not wide enough (B) Negative date (C) Negative time (D) Row is not wide enough Choose the correct answer from the options given below:

Which function returns the cumulative interest paid between two periods?

Which function is used to remove spaces before and after the text?

Intersection of row and column is referred as _______?

Which formula can be used to prevent leading or trailing spaces in a data validation rule?

In Excel terminology, what is the area that contains the entire chart called?

Provident Fund (PF) is calculated as a percentage of which component(s)?

In a chart, what do data points represent?

What does Dearness Allowance (DA) compensate for?

______ feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give different views of the data.

What is the maximum number of columns that a data validation form in Excel can display?

Doughnut charts: (A) Contains More than one data series (B) Comparable with Pie Chart (C) Comparable with bar graph (D) Comparable with Line Chart Choose the correct answer from the options given below:

What happens when you select "Warning" style in the Error Alert tab?

A _____ is a range of cells that shows the results of substituting different values in one or more formulas.

How do you add the Data Form button to Excel's Quick Access Toolbar? Click Quick Access Toolbar arrow (A) Add (B) All Commands (C) Form (D) More Commands

What shape is the Fill Handle in Excel?

How is an absolute cell reference indicated? (A) With a # sign before the cell (B) With a $ sign before the column and/or row (C) With parentheses around the cell (D) With a $ sign before the column and/or row Choose the correct answer from the options given below:

Which of the following is NOT a method to create a drop-down list for data validation?

What does the "cell reference" in a formula typically consist of?

The LOOKUP function has two syntax forms:

______ is the number 0 or 1 and indicates when payments are due.

Which of the following is not a mathematical function:

What is the expanded form of the accounting equation when incorporating revenues and expenses?

______ is the total number of payment periods in an annuity in financial function.

\$C4 or C$4 is an example of __________ reference.

__________ are numbered numerically from top to bottom while __________ are referred by alpha characters from left to right.

__________ is the function which adds the cells as per given specified criteria.

A cell reference identifies the location of a cell or group of cells in the spreadsheet also referred as a

By default cell reference is

Match List-I with List-II: | List-I | List-II | |---|---| | Movement | Keystroke (Press key) | | (A) One cell down | (I) Left arrow key | | (B) One cell up | (II) Right arrow key or Tab key | | (C) One cell left | (III) Down arrow key or Enter key | | (D) One cell right | (IV) Up arrow key | Choose the correct answer from the options given below:

The following elements are important for salary computation and its payment: (A) Grade Pay (GP) (B) Dearness Allowance (DA) (C) Transport Allowance (TRA) (D) Goods and Service Tax (GST) Choose the correct answer from the options given below:

Which combination is true in respect of using a graph/chart? (A) Quicker and easier to create a chart immediately to see the possible relationship of variables to one another, rather than paging through raw data. (B) Provide information in as little time as possible. (C) Graphs do not have the ability to take large amounts of information and make them into exhibitions that are easily used to persuade (D) A graph may be either a single line graph or a multi-line graph.

Following are the steps related to preparation of charts, arrange them in a correct sequence. (A) Save a chart. (B) Create a basic chart using the pattern from the panel available on top of the worksheet in 'Chart groups' option. (C) Change the layout or style of chart (D) Enter data on a worksheet with proper column and row titles. Choose the correct answer from the options given below:

How many blank worksheets are shown when a new workbook is created?

Where is the address of the active cell displayed?

A graph is a pictorial representation of data, which has at least ______ dimensional relationship.

Which view shows margins and the rulers?

Which of the following is not a types of graphs and charts

The best way to get started in Excel 2007 is to click the ____.

Which is not the Elements of a Chart/graph-

Using MS Excel, we can create a basic chart by the following steps. (A) On clicking of Start symbol we will get Programs option (B) Click on Insert tab to get tools for chart (C) On the screen of the computer mouse click on Start Icon (D) On selecting MS Excel 2007 program it will provide a blank workbook with a Ribbon displayed at the top. Choose the correct answer from the options given below:

Order of mathematical operations in solving data in electronic spreadsheet (A) * Multiplication (B) + Addition (C) ( ) Brackets (D) / Division Choose the correct answer from the options given below:

The current version of Excel 2007 is now designed with a series of horizontal tables knows as ______

In total how many "Rows" are there in a spreadsheet?

Which among the following is not a COUNT function in Excel :

How many blank worksheet(s) are shown, by default when a new workbook is created?

Which command reverse the last action performed in the worksheet?

The key combination which collapses the ribbon is :

How many blank worksheets are shown when a new workbook is created.

Which of the following arguments in a financial function represents the total number of payments

A _________ is a special key word which can be entered into a cell in order to perform and process the data which is appended within brackets.

Which of the following statement is not correct?

The data that is entered in a cell may be either: A. Numeric B. Alpha-Numeric C. Date D. Label Choose the correct answer from the options given below:

The best way to get started in Excel 2007 was to click the :

Which key combination callapses the ribbon ?

In which cell is the rate for PMT function where = PMT (C8, C9, C10, C11, C12)