QUESTION 1-

If you want to divide 100 by 2 and then add 25, using a spreadsheet such as Excel, how should you write the formula?

or @ sum100 / 2 (25)

or + 100/2 + 25

o = (100) (2) +25

o = 25 + 100/2

QUESTION 2- Using spreadsheet programs, how can you correct a mistake you made when entering the amount of $ 10,000 in the place where the correct amount was $ 1,000; but you have already used the cell location where you entered this wrong figure to perform other calculations

o Do not make additional changes, since, when you correct the wrong figure, the calculations that were made with it will be adjusted again.

o Rewrite the formulas that refer to that cell

o Remove a formula that refers to that cell

o Do not make any changes in the spreadsheet and simply write a memorandum to the owner of the company reporting the error

QUESTION 3

1. Spreadsheet programs can be used to communicate financial, investment and operational activities of a business. What financial statement contains this information?

o Balance Sheet

o Income Statement

o Statement of Cash Flows

o Statement of Retained Earnings

QUESTION 4

1. When creating a decision between the different alternatives using spreadsheet software, the best formula to use would be

or Sum

or If (yes)

o Average

o Minimum and Maximum (minimum and maximum)

QUESTION 5

1. A pivot table can be used to:

o Organize large amounts of data

o Remove data from files automatically

o Change the view of a document by rotating it from left to right

o Show small amounts of data aligned towards the center of the document

QUESTION 6

1. When using a Vlookup formula:

o The column index field will always be 2

o The first column, in the table matrix, must be in numerical or alphabetical order

o The results will be either true or false

o The second column in the table range must contain a sum formula

QUESTION 7

1. The use of spreadsheet software to communicate the operational activities of a company to users of financial statements can be done by preparing a (n):

o Amortization Schedule

o Depreciation Schedule

o Income Statement

o Payroll Registry

QUESTION 8

1. Spreadsheet programs can be used to determine the amount of a simple interest rate that is part of a 30-day note that is outstanding. What mathematical operation should be used to perform this calculation?

o Addition and subtraction

o Multiplication and Division

o Addition and division

o Multiplication and subtraction

QUESTION 9

1. When creating a spreadsheet, if the cell contains ####, this means:

o That the cell needs to be adjusted

o That you have obtained the correct solution

o That you have obtained the wrong solution

o That the data is corrupt and you must enter the correct ones into the system

QUESTION 10

1. When preparing a depreciation schedule using spreadsheet programs, you must identify the following except:

o Estimated life of the asset

o Estimated salvage value (residual value) of the asset

o Historical cost of the asset

o Market value of the asset

QUESTION 11

1. When preparing a horizontal analysis, using spreadsheet programs, the percentage of change in the value of a piece of land will be calculated using the formula:

o Divide the value of the land by the value of all assets

o Divide the current value of the land within the value of this the previous year

o Multiply the current market value of the land within the total value of the assets

o Add the values of the land from years prior to its depreciation

QUESTION 12

1. One of the advantages of using a "spreadsheet" data table program is that

Calculations are generated quickly

Checks can be ordered online

Journal entries are automatically transferred to the general ledger by pressing the "post entries" button.

There are no "Scroll" bars that make the information difficult to read.

QUESTION 13

1. When preparing a payroll record, using spreadsheet programs, you will need to identify the following, except:

Number of hours worked

Amount withheld for taxes

Previous year's payroll expenses

The FICA tax rate

QUESTION 14

1. A footer will be included in the __________ spreadsheet to communicate additional information to the reader.

o At the bottom of the page

o At the top of the page

o On the right side of the page

o On the left side of the page

QUESTION 15

1. When preparing a horizontal analysis, using spreadsheet programs, you must submit it at:

o Portrait view

o Landscape view

QUESTION 16

1. Tables (tables) within a spreadsheet are used to present accounting data:

o More accurately than presenting the numbers within the spreadsheet

o For maximum data included in 10 spreadsheets at the same time

o Visually

o To show the demonstration of the features of the spreadsheet software.

QUESTION 17

1. From an ethical point of view it would be acceptable to use Excel's "What-if analysis" function to:

o Determine what FICA rate should be applied to employees so that their tax liability decreases by 15%.

o Determine what level of income to report to the IRS to reduce taxes.

o Determine what level of income to report to the SEC to meet investors' expectations regarding earnings per share.

o Determine what is the optimal selling price of a product for a company.

QUESTION 18

1. When writing a report based on the analysis of financial ratios (ratios) using spreadsheet programs, how should you structure the report?

o Provide general observations on financial ratios in no more than two sentences

o Provide only the financial reasons and do not include any narrative, since the management of the company is the one that decides whether to provide and interpret the information

o Provide both financial ratios and narrative, describing relationships between financial ratios

o Provide only the formulas since company management can calculate its own financial ratios to make sure they are correct

QUESTION 19

1. When creating a spreadsheet formula in Excel, the $ symbol in front of a letter or number (example. $ A $ 4) within a cell, this means that:

o The answer will always be displayed in the same cell address, such as A4, even if a new file is opened

o The answer will display a cell that is at least as wide as the number specified in the formula as 4

o The answer will be displayed with a dollar sign such as $ 100

o The cell will remain constant even when the formula is copied to another cell