COS Multichoice Questions TEST 1

What is the order of operations performed from first done to last done in the formula below = 7- 2 * 4 / (6+3)

+ * / -

The value in cell C2 (15%) has been formatted to Percentage format. Internally, the value is stored as _____.

0.15

What is the result of the formula =COUNTIFS(B2:B8,"F",D2:D8,">60)

1

Assume cell A1 contains value 25, cell A2 contains value 50, and cell A3 contains value 75. What is the result of the function: =IF(A1>40,A1-5, IF(A1>20, A2 *2, A3 -1))

100

What is the result of formula =ROUNDUP(MIN(13.8,15.1),0)

14

What is the result of the math formula =2 * 5 + 3 ^2

19

What is the result of the function =ROUND(25.4782,2)

25.48

What is the result of the formula =SMALL(A2:A5,2)

30 the second smallest in the list

What is the result of the formula =30 + 60 /3 -2

48

Assume values 10, 20, 30, and 40 are entered in the cell range A1:A4. Cell A10 contains the formula = A1+ A2+ A3 + A4 and displays the value 100. the user inserts a new row 2 and enters the value 50 in A2. What formula and value now list in cell A11?

= A1 + A3 + A4 + A5 100

Assume cell D2 contains the formula =$A2-5 How will this formula appear if its copied to cell E3?

=$A3-5

Assume cell B4 contains an inventory level for the previous month December and cell B5 contains the inventory level for the current month January. Which formula computes the percent increase in inventory level?

=(B5-B4)/B4

What is the result of function =SUM(10,A1, B4:B6) assuming A1 has the value 5, B4 has the value 2, B5 has the value 3 and B6 has the value 4?

=24 (10+5+2+3+4)

Which function could be used to compute the average weight of fish taken from lake Chemo with weights LESS THAN 2 POUNDS?

=AVERAGEIFS(B2:B9,A2:A9,"Chemo",B2:B9,"<2")

Write the formula to be used in cell D2 to compute the retail price based upon the cost and the markup percentage.

=B2*C2 +B2 cost * markup percentage +cost

Assume cell B6 contains the formula =A4 + C7 How will this formula appear if its copied to D8

=C6+E9

Assume you are writing a formula in cell A1. Which of the following would generate a CIRCULAR REFERENCE WARNING?

=MAX(A1:F6)

Assume a workbook has five worksheets named Mon, Tue, Wed, Thu and Fri. A sixth worksheet is added with the name Summary. Which command should be place in cell A1 of Summary to add the values from A1 of each of the five sheets?

=Mon!A1+Tue!A1+Wed!A1+Thu!A1+Fri!A1 or =SUM(Mon:Fri!A1)

What formula should be used in cell B2 to compute the rankings of the values in column A, into ASCENDING order? What value will appear in cell B2 when the formula evaluates?

=RANK.EQ(A2,$A$2:$A$5,1) 2 will appear- its the second smallest value

What function sums the prices of shoes that are at least a size 10?

=SUMIF(C2:C8,">=10", D2:D8) column c= sizes column d= prices

Assume a workbook has worksheets named Summer and Winter. A third worksheet is added with the name Summary. Which command should be placed in cell A1 of the Summary sheet to compute the sum of cell A1 on the Summer sheet and B1 on the Winter sheet?

=Summer!A1+Winter!B1

Assume cell A3 contains the formula =A1+A2 Attempting to copy it to which of the following cells generates a #REF! error?

C2

Assume cell C2 has been given the name Hours. Which of the formulas below could be used to add the value in cell C2 to the value in C3?

C2+ C3 or Hours+C3

Which function should be used to return the number of values in a range?

COUNT

Assume cell A1 contains value 2, and cell A2 contains formula =A1/3. Cell A2 is formatted to display two decimal places, which statement is NOT true?

Cell A2 displays 0.66 What is true: Cell A2 is internally stored as .66666667, if row 1 is deleted an error occurs as the formula cannot be evaluated, and if the value in cell A1 changes, the formula automatically recomputes

Assume cell A3 contains the formula =A1+A2 Attempting to copy it to which of the following cells will generate a #REF! error?

D2 it would become = D1+D2 circular reference No No!

Formatting a value such as 25.4782 to Currency format with two decimal points changes the way it is stored internally as well as displaying it on the worksheet as $25.48.

FALSE

What is the result of the function =AND(4<9,8>=8,7<6)

FALSE

What statement is NOT true about the difference between text and values in excel?

If a column cannot fully display a TEXT entry and the cell to the right is occupied an error ##### appears. -this error occurs for values, text gets truncated

Which statement is NOT true about the formula =$A$1+$B7 located in cell C1

If the formula is copied to cell D1 there will be an adjustment of $B7 to $C7 What is true: the cel reference $B7 is referred to as a mixed cell address, if the formula is copied to cell C2 there will be an adjustment of $B7 to $B8, and no matter where it is copied, the resulting formula will always reference &A$1

Which function should be used to generate the value that occurs most often within a data set?

Mode.SNGL

Which statement is NOT true about Excel's AutoSum feature?

Once AutoSum has inserted a function with its suggested range, it cannot be edited. What is true: AutoSum is initiated by clicking the "wacky E" button in the Editing group on the Home tab, AutoSum give you quick access to SUM and other common mathematical functions, AutoSum suggests an initial cell range from the range containing value to the left of the cell.

Which statement is NOT true about the RAND function?

Once a random number is generated it is stored as a literal value and never changes when the worksheet formulas recalculate. What is true: it is possible for three separate RAND functions on a sheet to all return the value .75, it generates a random number greater than or equal to 0 and less than 1, when using RAND to repeatedly stimulate flipping a coin you would expect that approximately half the time a value less than .5 would be generated.

Which of the following is not a valid name for a cell?

Price Next Year After Upgrade What are valid cell names: Union_Fees, HoursWorked, Category2

Assume a workbook has five worksheets name Mon, Tue, Wed, Thu, and Fri. Which technique could be used to group sheets Mon and Wed?

Select sheet tab Mon, hold CTRL key, select sheet tab Wed

Both formulas =(B2+C2+D2)/3 and =SUM(B2:D2)/COUNT(B2:D2) compute the same number.

TRUE

If a worksheet name contains a blank, its name must be enclosed in single quotation marks when used in a formula

TRUE

The AUTOSUM command inserts the SUM function and guesses at the cell range by examining the range of the cells to the immediate top or immediate left.

TRUE

When using the SUM,MAX or AVERAGE functions on a range of cells, an empty cell in the range is ignored.

TRUE

A production line cuts strapping into lengths of 12 inches. Pieces that differ from 12 inches by more than .25 inches much be rejected. Which of the following scenarios indicates that errors are on the rise perhaps due to aging equipment?

The average length remains 12, but the standard deviation increases by .10

Assume column A is narrowed such that the contents of cell A1 (text) no longer fit in the column. What will happen?

The text "file cabinet" will remain internally but will appear truncated to the viewer.

Given a normal distribution of data, a small standard deviation indicates many values are clustered closely around the average.

True

What is the result of the formula =NOT(OR(FALSE,FALSE))

True

What is indicated by a formula containing the formula =1+D$7

When the formula is coped the column may alter but not the row

Assume range A1: A10 has been give the name PRICES. Which of the following statements is NOT true?

When used in a function the name Prices must be inserted in quotations, as in =MIN("PRICES") What is true: range name prices copies as absolute addresses when used in a function, range name prices can be used in the SUM function to compute the sum of all numbers in the A1:A10 range, once a range has been named, it can be edited or removed using command in the Name Manager utility.

How would you fix the error message ##### that might appear in a cell?

Widen the column so there is room to display the numeric data

Which of the following is NOT an option on the format cells/ alignment tab?

add a bottom border under the cell What is an option: word-wrap text in the cell so it occupies multiple lines, change horizontal alignment within a cell to be centered, and change the orientation of text rotated to some number of degrees

When computing the largest weight of the sample:

both MAX and LARGE can work.. MAX(b2:b9) or LARGE(B2:B9, 1)

The ______ is the small black cross shape that appears in the lower right corner of a cell.

fill handle

Given the values 5, 5, 4, 3, 1, 2, 5, the median is ______ and the mode is _____.

median 4 mode 5

Assume cell A1 contains the formula = B1 + $C2 + D$3 = $E$4 Which statement is correct if this formula is copied to cell A2?

the formula is adjusted to =B2 + $C3 +D$3 + $E$4

What would be the result of the formula =B4 *C4 two empty cells

the result would be 0

The average formula may compute odd results if:

there is an empty cell (the formula uses a 0) or there is text in a cell (the formula cannot be computed)