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