Microsoft Excel Quiz with Complete Solutions

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 =__/__