$[1$:$30$ PM$]$ Rodrigo Cisneros

To add a new rowgo to the Page Layout tab and click Add Row True BFalse Question $28$ is possible to insert an image from a file into an Excel spreadsheet True B False

$[1$:$30$ PM$]$ Rodrigo Cisneros

To create a formula in Excel select a cell then type B Question $26$ In EXCELyou can sum a large range of data by simply selecting a tool button called A Auto format Auto sum

$[1$:$31$ PM$]$ Rodrigo Cisneros

A Function is simply a predefined True BFalse Question $24$ Could an Excel spreadsheet be used as the data source for a Word Mail Merge True B False

$[1$:$32$ PM$]$ Rodrigo Cisneros

Under the Home tab $($Editing group$)$ which is not a function of the Clear command? Clear contents B Clear hyperlinks Clear formats

$[1$:$32$ PM$]$ Rodrigo Cisneros

To select an entire column in MS EXCELyou would press? A C B CTRL CTRLArrow key DThe column header Question $20$ An Excel Workbook is a collection of A Tables Worksheets

$[1$:$33$ PM$]$ Rodrigo Cisneros

#### means : A You've entered a number wrong B You've misspelled something The cell is not wide enough Cell error Question $18$ How do you change the column width to fit the contents $?$ A Press ALT and single$-$ click anywhere in the column B Double$-$ click the boundary to the right of the column heading Single click the boundary to the left of the column heading Right click the column and choose auto$-$ fit

$[1$:$34$ PM$]$ Rodrigo Cisneros

Which Excel tab would you select in to autosum A Home B Formulas Either of the above DNone of the above Question $15$ Under the Data tab how do you rearrange the data in ascending or descending order? A Table B Subtotals Form Sort

$[1$:$34$ PM$]$ Rodrigo Cisneros

When a cell is selected its coordinates appear in the A Name B Task bar Backstage View Formula bar Question $13$ Which key do you press to group two or more non adjacent worksheets $?$ A SHIFT ALT C CTRL

$[1$:$35$ PM$]$ Rodrigo Cisneros

What formula should be entered in cell A$3$ to display the results as shown in cell A$3?$ D EG USD $$000\text{'}$s $2014$A $2015$A $2016$A $2017$A $2018$A $25000$ Revenue $150\mathrm{.}000165,000181\mathrm{.}500199\mathrm{.}650219\mathrm{.}615$ SCOGS$67,50074\mathrm{.}25081,00089,000$ Gross Margin $82\mathrm{.}50090\mathrm{.}750100,500110,650121,61516\mathrm{.}50018,15020,00022\mathrm{.}00025,3007$ SG &A EBITDA$66,00072\mathrm{.}60080,50088\mathrm{.}65096\mathrm{.}3156\mathrm{.}6009\mathrm{.}0009\mathrm{.}50098009$ Depreciation $10$ Interest$1,0001000100010001,00011$ EBT $58,40064,34070,5007815085,51512$ Taxes $17\mathrm{.}50019\mathrm{.}3002010023\mathrm{.}60020,60013$ Net Income $40,90045,04050,40054,55058\mathrm{.}915$

$[1$:$35$ PM$]$ Rodrigo Cisneros

MSEXCEL based on what operating system $?$ ALinux BUNIX WINDOWS DMac $1$ Poin Question $10$ Which formula can add all the numeric values in a range of cells ignoring those which are not numeric, and place the result in a different cell? A Count BAverage Sum

$[1$:$36$ PM$]$ Rodrigo Cisneros

The formula $($A$2)5\%$ valid True B False $1$ Point Question $8$ The most effiescent way to copy an entire worksheet and all its data is to click the worksheet tab of the sheet that you want to copy hold down SHIFT, and then drag the selected sheet along the row of sheet tabs ATrue False

$[1$:$37$ PM$]$ Rodrigo Cisneros

Question $5$ is possible to prevent someone from copying the cell from your worksheet True B False

$[1$:$38$ PM$]$ Rodrigo Cisneros

On an Excel sheet, the active cell is indicated by AA dark wide border BA dotted border A blinking border None of the above

$[1$:$38$ PM$]$ Rodrigo Cisneros

Which formula can be used in cell C$2$ and copied through $,$ and will yield the results shown if the IRR is equal to or greater than the value in cell E$2?4$ A D IRR Decision $12\mathrm{.}5\%10\%9\mathrm{.}3\%2$ Project $13$ Project $24$ Project $3$ Project $4$ Accept or Reject Accept Reject Reject Accept $8\mathrm{.}2\%11\mathrm{.}1\%6$ IFB$2$E$2$Accept", Reject$)$ B IF$($B$2$$E$2$AcceptReject$)$ B$2$ AcceptReject$)2$Accept Reject

$[1$:$39$ PM$]$ Rodrigo Cisneros

Microsoft Excel is a powerful $..$ A DBMS package B Communication SW Package Word processing package Spreadsheet package Question $2$ You can change the number of worksheets that automatically appear when you start Excel A True False