Microsoft Excel Quiz with Complete Solutions

Document Content and Description Below

Microsoft Excel Quiz with Complete Solutions excel ✔✔spreadsheet application for MS office primarily used for financial applications excel uses ✔✔spreadsheets used to analyze data in table ... format types of data ✔✔1. text/labels 2. data 3. a value 4. formula excel applications (charts) ✔✔chart creation representing groups/ series of data in graphical form to clarify values/trends excel applications (graphical capabilities) ✔✔can insert graphs and formatting like MS word excel applications (template formulation) ✔✔can create particular type of spreadsheet that is used many times (invoices, expense reports) workbook ✔✔excel file with 1 or more worksheets worksheet ✔✔work area for calculating data made of columns and rows separated by grid lines cell ✔✔intersection of column and row on worksheet active cell ✔✔contains cell pointer formula bar ✔✔as you enter data into cell, it simultaneously appears in bar (above worksheet frame) cell reference ✔✔location of cell on worksheet identified by column letter and row number scroll ✔✔way to view locations on worksheet without changing active cell formula for SUM ✔✔=sum(A4:G4) formula for DIFFERENCE ✔✔=B3-C7 formula for MULTIPLICATION ✔✔=H2*K6 formula for DIVISION ✔✔=D5/F8 formula for AVERAGE ✔✔=AVERAGE(B9:D9) formula for MINIMUM ✔✔=MIN(J4:L4) formula for MAXIMUM ✔✔=MAX(C3:E3) formula for GROSS MARGIN ✔✔=sales-cost of goods sold formula for TOTAL EXPENSES ✔✔=sum of all expenses formula for NET INCOME BEFORE TAXES ✔✔=gross margin-total expenses formula for NET INCOME AFTER TAXES ✔✔=income before taxes-federal taxes formula for FEDERAL TAXES ✔✔=0.25*B7 formula for TOTAL ✔✔=amount*cost formula for INCOME ✔✔=total sales-total expenses formula for % OF PROFIT ✔✔=income for month/total income formula for SALES REVENUE ✔✔=selling price*units sold formula for COST OF GOODS SOLD ✔✔=total units sold*cost price ($) formula for GROSS PROFIT ✔✔=sales revenue-cost of goods sold ADDITION ✔✔=SUM(__:__) OR =__+__ SUBTRACTION ✔✔=__-__ MULTIPLICATION ✔✔=__*__ DIVISION ✔✔=__/__ [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: