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. t
...
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]