mis1305
which of the following symbols is used to concatenate
&
which of the following .... row labels of the field list pictured below
(Sigma) Values
a worksheet text label, by default, will
- both b and c - display ***** if the length of the label exceeds the width of the cell and the cell to the right contains an entry - be left aligned
excel will have trouble using autofillto complete which sequence
1 (to see 1,2,3)
which of the following functions was used to place the sum of revenues for the costumer catagory as local and the sku as clothing in cell B2
=SUMIFS (Line_Item_Total,SKU_Cat,$A2,Cust_Cat,B$1)
which function would you put in cell B6 to calculate sm of the year's digits depreciation
=SYD($C$1,$C$3,$C$2,A6)
which of the following is the correct entry in cell D4 to extract just the first name of each guest
=TRIM(LEFT(A4,Find(" ",A4))
which of the following functions placed "75000000 in cell C2 and would correctly fill down
=VLOOKUP(A2,$A$10:$E$16,5,false)
which of the following functions placed coupon match or no match in column C
=if(A2<>B2, "No Match", "Coupon Match")
which of the following functions placed under goal in cell B3?
=if(sum(trans_Qty)>B2, "Goal Met", "Under Goal")
which of the following functions in cell Q4 to find the sum of salaries of all employees who work in dallas
=sumif(F2:F101,P4,G2:G101)
which of the following if the correct function in cell B4
=sumif(emp_id,A4,line_item_total)
____ using the fill series command when you know the beginning and ending values
???
what would be the best range to highlight for the chart in question 25?
A1:F1 and then hold down the Ctrl key and highlight A4:F5
which of the following nested IF functions is in cell C4 to return the text spoil risk
IF(B4<5000, "Prod Risk", IF(B4<10000, "Low", IF(B4>14000, "Spoil Risk", "OK")))
which of the following functions allows you to replace an excel-created error message with a message
IFERROR
which of the following changes to the design grid result in -1 being replacd by the word Paid and 0 by Unpaid
IIF(InvoicePaid, "Paid", "Unpaid") in the second column, field row
which financial function finds the present value of a stream of unequal cash flows
NPV
which of the following functions is not used when you have a constant payment and a constant interest
NPV
which of the following functions would calculate the present value of the following cash outflow and cash inflow
XNPV
referential integrity is
a set of rules that ensures that data is consistently updated
in the PMT function, type 0 indicates to excel that the payment is
an ordinary annuity, paid at the end of the period
the totals row in the query design grids above
are added by clicking the total icon on query tools design tab ribbon
the following query design will result in a record set showing all records that
are in the first week of january or are walk-ins
if the data in cell B2 of the spreadsheet was edited to 10 people going on the skydiving tour in april, the chart above would
change automatically
suppose you want to compare the number of people that are scheduled to go parasailing and auto racing. what would be the best type of chart to choose
column chart
the purpose of the fill handle is to
copy the contents of one cell to another
a join in access is
created by linking common fields in tables
a query that has a row for setting fields as row headings, column headings, and values is called
crosstab query
which of the following is the format for the numbers in B3:E14
currency
each of the following is an access data type except
data
the drop down list is created as part of
data validation
which of the following is not a suggested guideline for designing a table
designate at least two primary keys
a named range
does not require using the F4 key to make the range absolute before filling down
the fill series command will calculate the values and will enter the formula or function in the cell
false
a slicer can be used to
filter a pivot table or pivot chart
if you boss asked you to provide a list of visits to a clinic on the same date, the wizard to use is
find duplicates query wizard
assume you have a multiple table database. in the second table the thing is the
foreign key
when bringing external data into access, you can
import, append, link
an advanced filter in excel
is set up out of the range of the data source
which of the following is true of the primary key
it matches a record unique
the ___ operator selects records by matching field values to a specific pattern that includes a wild character
like
what was the correct function used to create the custom field called monthly payment
monthly payment: -pmt([houses for sale]![annual interest rate]/12,[houses for sale]![term in years]*12,[houses for sale]![loan amount])
if the investment in question #3 were available to you today for $46,000, would it be a good deal
no
would the investment in question #25 be a good investement to make
no
if you saved the changes in a filtered query datasheet view, access will
not save the filtered list, but re open to the original record set
which of the following chart types is NOT suitable to display multiple data series
pie chart
when designing a pivot table, selecting a field that contains numerc data by clicking the checkbox beside the field name in the pivot table field list will
place that field in the value area
which of the following custom fields has the correct syntax
reorder indicator: iif([days of supply]<60, "reorder", "ok")
the goal seek command
run iterations that let you set one cell's value to a specific amount by changing another cell
an embedded chart is ??? chart
sits on top of the worksheet
before applying subtotals in an excel table you should
sort the data
which of the following is not an accelerated method of depreciation
straight line
which of the following queries was designed to create this record set
the answer is A
when excel interprets the data to create a chart and assigns the rows as the category, the columns become
the data series
when tracing errors in excel, a red arrowed line indicates
the error is being passed through the cell youre auditing
when excel interprets the data and assigns a data series, the data series names become
the legend
dates are placed in excel as 2/8/2018, but the general format reflects
the number of days since the turn of the twentieth century
IRR is
the point where NPV equals to zero
the #### appears when
the value typed is two large for the cell
the purpose of a pivot table is
to analyze data, especially for decision making purposes
which of the following buttons would you have pressed to see the auditing arrows above
trace precedents
in designing a query, to format a field to currency with 0 decimal places, select the property sheet icon
true
pivot charts are automatically updated when their data source is updated
true
to correctly reference another worksheet in a function or formula, you
type =, click on the other worksheet tab, click on the cell that you want to reference, and press enter
the first step you want to protect your worksheet but leave some cells changeable is to
unlock the cells that will still change
which of the following is not a way to edit a cell in excel
use the F4 function key to put the insertion point in the cell
assume you have entered the function =average(F9:F39) in a cell and the resulting answer is 874.6993548. You want the result to be displayed in two decimals (874.70), but you want any mathematical calculation based on the result to use the number to all seven decimal places. Which of the following is the correct action?
use the decrease decimal icon on the home ribbon
freezing panes
will allow you to scroll the worksheet below the freeze
to correctly create the transpose function
you must use a combination key stroke of Ctrl + Shift + Enter
which of the following functions would you use in cell B4 to calculate the necessary interest rate
=RATE(B3,B2,B1)
which of the following is the correct function in cell B14 that would correctly fill right
=SUM($B$12:B12)
what is the correct function in cell B4 used to calculate the value today of these future payments?
= -PV(B2/12,B3*12,B1)
which of the following complex formulas is the best calculation to place in cell F2 if the company's deliver charge is the companys cost plus a 25% markup
=(((A2/B2)+C2) *E2) *(1+D2)
the correct function in cell B8 that would correctly fill down is
=-IPMT($B$2/12,A8,$B$3,$B$1)
the correct function in cell B5 is
=-PMT(B2/12,B3,B1)
which of the following functions is used to calculate the present value of a bond
=-PV(B6,B4,B5,B2)
in the worksheet above, the correct entry to calculate the monthly payment amount is
=-pmt(B3/12,B4,B2)
which of the following is the correct function in cell B15 to calculate the average sale
=Averageif(Cust_Cat, B14, Line_Item_total)
which of the following is used to calculate the retained earnings in cell B5 ansd would correctly fill across
=B1-B3
which of the following formulas is used to calculate the annual coupon payment amount in cell B5
=B2*B3
assume the sales will grow by 10% each quarter. which of the following is the correct formula in cell C3?
=B3*1.1
which of the following formulas that would correctly fill down and across placed the price per basket for each item in range B10:E12
=B3*B$8
which of the following is the correct formula in cell D3 that will correctly fill down
=B3*C3
which is the ocrrect function to calculate the percent of goal met
=B4/B6
which of the following formulas that would correctly fill across placed the price after bulk discount in cells B8:E8
=B7*$E$1
which formula would you put in cell C6 to calculate the book value after the first accounting period's depreciation
=C5-B6
the correct entry in cell B8 that would properly fill down is
=D7-C8
assume that you have entered the formula, =D7-C8, in a cell in an excel worksheet. what would be the formula found in the cell immediately below if you filled the formula down
=D8-C9
which of the following functions was used to calculate the sum of the retained field in a database named dataset on the criteria check in the pay_type field
=DSUM(dataset,B4,A1:B2)
which of the following functions would calculate the number of years to repay a loan
=F2/E2
which of the following functions placed morning afternoon adn evening in column K
=HLOOKUP(J1,$B$1:$D$2,2,true)
which of the following functions was used to place the text costumer appreciation 10% off in cell E2 if you were only giving A 50% coupon to costumers who had been shopping with the store for over one year and had not made a purchase in one year
=IF(AND(B2>1,D2>12), ""please come back 50% off", "costumer appreciation 10% off"
which of the following is the correct function in cell H2 to calculate the new price of t shirts
=IF(I2>0,I2,IF(G2=0,B2,B2-(B2*G2)))
which of the following functions was used in cell B2 to show the position Asst Manager
=INDEX(C2:C6,MATCH(A2,D2:D6,0))
which of the following is the correct function in cell B9 that calculates IRR
=IRR(B1:B6)
which of the following functions would place the number of payments in cell F2
=NPER(H2,I2,B2)
if i decided to sum up the total calories burned for the 5 day period and put the answer in cell F7, I could highlight the range F2:F6 and use which of the following shortcuts
Alt + =
which of the following ranges would you highlight to use the fill series command to show growth trend from year 1 to 5
B2:F3
which function would you use to calculate all the monthly interest paid per year
CUMIPMT