Spreadsheet Questions

In MS Excel spreadsheet software, the shortcut key combination that toggles (collapses or expands) the ribbon is:

In which cell is the rate parameter for the PMT function located given the formula = PMT(C8, C9, C10, C11, C12)?

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

__________ 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 to as a:

By default, a spreadsheet cell reference is:

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 a financial function.

Arrange the steps in the correct chronological sequence to add the Data Form button to Excel's Quick Access Toolbar after clicking the Quick Access Toolbar arrow:(A) Add(B) All Commands(C) Form(D) More CommandsChoose the correct answer from the options given below:

What shape is the Fill Handle in Microsoft Excel UI?

How is an absolute cell reference indicated in spreadsheet software formulas?(A) With a # sign before the cell(B) With a $signbeforethecolumnand/orrow(C)Withparenthesesaroundthecell(D)Witha$ sign before the column and/or rowChoose the correct answer from the options given below:

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

What does a standard alphanumeric "cell reference" address identifier in a spreadsheet formula typically consist of?

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

$C4orC$ 4 is an example of a __________ reference.

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

What happens when you select "Warning" style in the Error Alert tab during Data Validation in Excel?

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

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 enoughChoose the correct answer from the options given below:

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

How is the Net Salary (NS) of an employee determined in automated payroll accounting?

What kind of data values or comparisons are best displayed with a bar chart?

What is the difference between the TODAY() and NOW() functions in spreadsheet applications?

Arrange the following mathematical operations in the correct sequence order in which an electronic spreadsheet (MS Excel) processes equations from highest priority to lowest priority (PEMDAS/BODMAS):(A) * Multiplication(B) + Addition(C) ( ) Brackets(D) / DivisionChoose the correct answer from the options given below:

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. NumericB. Alpha-NumericC. DateD. LabelChoose the correct answer from the options given below:

Which key combination collapses the ribbon?

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

How many blank worksheet(s) are shown, by default when a new workbook is created in classic spreadsheet software like Microsoft Excel 2007/2010?

Which keyboard shortcut command reverses the last action performed in a spreadsheet worksheet?

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

Modern spreadsheet applications like Excel 2007 organize commands into a series of horizontal tabs known as the:

In standard classic spreadsheet formats (such as Excel 97-2003), how many total "Rows" are available within a single worksheet?

Arrange the basic steps to create a spreadsheet chart in MS Excel in the correct logical order from start to finish:(A) On clicking the Start symbol, select the Programs option.(B) Click on the Insert tab to access chart tools.(C) Click on the computer screen's Start Icon.(D) Selecting the MS Excel program opens a blank workbook with a Ribbon displayed at the top.Choose the correct answer from the options given below:

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

Which of the following is NOT an element of a chart or graph in a spreadsheet software?

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 ____.

A graph is a pictorial representation of data, which exhibits at least a _________ dimensional relationship.

Which spreadsheet workspace view displays data page margins, page headers/footers, and rulers simultaneously?

Where is the address of the active cell displayed?

How many blank worksheets are shown by default when a new workbook is created in classic spreadsheet systems like Microsoft Excel (older default versions typically referred to in standard curriculum textbooks)?

Match List-I with List-II:List-I (Movement)List-II (Keystroke)(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 keyChoose 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.Choose the correct answer from the options given below:

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.