1.
When calculating cells what does a colon allow you to do?
Correct Answer
C. Calculate multiple cells by highlighting them
Explanation
A colon in Excel allows you to calculate multiple cells by highlighting them. This means that you can select a range of cells and perform a calculation on all of them at once, saving time and effort. By using the colon, you can easily sum up a series of numbers or perform other calculations on a group of cells without having to manually input each cell reference.
2.
What is the correct answer given the formula ROUNDUP (A4,3), when A4 is equal to 12.34912?
Correct Answer
B. 12.35
Explanation
The ROUNDUP function in spreadsheet software rounds a number up to a specified number of decimal places. In this case, the formula ROUNDUP(A4,3) rounds the value in cell A4 up to three decimal places. Given that A4 is equal to 12.34912, when you apply the ROUNDUP function with three decimal places, the result will be 12.350. However, since the third decimal place is zero, it can be omitted, so the final result is displayed as 12.35.
3.
What is the correct answer given the formula SMALL(B2-H1,3), for the following table
A
B
C
D
E
F
G
H
I
J
1
4
3
6
9
12
2
11
5
3
3
6
10
5
7
9
14
2
1
7
Correct Answer
D. 4
Explanation
To determine the correct answer, we first need to understand the SMALL function. The SMALL function returns the nth smallest value from a range of cells. In this case, the formula is SMALL(B2:H1, 3), which means we want to find the third smallest value within the specified range.Looking at the given table, we can identify the values in the range B2 to H1:B2: 11C2: 5D2: 3E2: 6F2: 10G2: 5H2: 7Now, let's arrange these values in ascending order:3, 5, 5, 6, 7, 10, 11The third smallest value in this sorted list is 6.So, the correct answer given the formula SMALL(B2:H1, 3) for the provided table is 6.
4.
What is the correct answer given the formula MEDIAN(A2-A7) for the following table.
1
2
3
4
5
6
7
8
9
A
2
5
7
9
13
23
4
16
1
Correct Answer
C. 8
Explanation
To find the correct answer, we need to understand the MEDIAN function. The MEDIAN function returns the median (middle) value in a list of numbers. In this case, the formula is MEDIAN(A2:A7), which means we want to find the median value within the specified range (A2 to A7).Let's list the values in the range A2 to A7 from the given table:A2: 5A3: 7A4: 9A5: 13A6: 23A7: 4First, let's arrange these values in ascending order:4, 5, 7, 9, 13, 23Since there are an even number of values, the median will be the average of the two middle values. In this case, the two middle values are 7 and 9.Median = (7 + 9) / 2Median = 16 / 2Median = 8So, the correct answer given the formula MEDIAN(A2:A7) for the provided table is 8.
5.
All formulas in Excel must be begin with what symbol
Correct Answer
A. =
Explanation
All formulas in Excel must begin with the equal sign (=). This symbol indicates to Excel that the following characters constitute a formula or function that needs to be calculated. It is essential to start any formula or function in Excel with this symbol, or else Excel will interpret the entry as text or a numeric value.
6.
What is the correct formula to solve for the Interest of following graph?
A
B
C
D
E
Year
Opening Balance
($)
Interest Rate (%)
Annual investment
($)
Closing Balance
($)
1
1000.00
6
1000.00
2060
Correct Answer
A. =B3*0.06+D3
Explanation
Let's break down the formula =B3\*0.06+D3 to understand how it calculates the interest and closing balance for the given graph.The formula consists of two parts: B3\*0.06 and D3, which are added together.B3\*0.06: This part of the formula calculates the interest earned on the opening balance. Here, B3 represents the cell containing the opening balance, and 0.06 is the interest rate (6% expressed as a decimal). By multiplying the opening balance by the interest rate, we obtain the interest earned on that balance.D3: This part of the formula represents the annual investment, which is stored in cell D3.When you add these two parts together (B3\*0.06 + D3), you get the total closing balance. This calculation takes into account both the interest earned on the opening balance and the additional annual investment.In summary, this formula accurately computes the closing balance by considering the interest earned on the opening balance and adding the annual investment to it.
7.
The graphing functions in Microsoft Excel can be found in what tab.
Correct Answer
B. Insert
Explanation
The correct answer is "Insert" because the graphing functions in Microsoft Excel are located in the Insert tab. This tab contains various options for inserting different types of objects into the Excel worksheet, including charts and graphs. By selecting the Insert tab, users can access the necessary tools and features to create and customize graphs in Excel.
8.
When is the best situation to use a pie graph?
Correct Answer
C. When comparing one category to the group
Explanation
A pie graph is best used when comparing one category to the group because it allows for easy visualization of the proportion or percentage that each category represents within the whole. By using a pie graph, it becomes simple to see the relative sizes of different categories and make comparisons between them. This type of graph is particularly effective when the goal is to understand the distribution or composition of a group in relation to a specific category.
9.
The "Formula" in excel is...
Correct Answer
B. A combination of numbers and symbols used to express a calculation.
Explanation
The correct answer is "A combination of numbers and symbols used to express a calculation." This is because a formula in Excel is a combination of mathematical operators, cell references, and values that perform calculations or manipulate data. Formulas are used to perform calculations such as addition, subtraction, multiplication, and division, as well as more complex calculations using functions.
10.
What is Microsoft Excel?
Correct Answer
B. A program that creates spreadsheets that combines worksheets, grapHics, and data management into a single program.
Explanation
Microsoft Excel is a program that is specifically designed for creating and editing spreadsheets. It allows users to combine worksheets, graphics, and data management into a single program, making it a powerful tool for organizing and analyzing data. It is not a program for creating newsletters, brochures, flyers, web sites, databases, notes, or presentations.
11.
What answer will be provided given the formula =IF(A1>B2) for the cell values.
A
B
1
5
6
2
3
4
Correct Answer
D. False
Explanation
The formula =IF(A1>B2) is comparing the value in cell A1 with the value in cell B2. If the value in A1 is greater than the value in B2, the formula will return the value "True". In this case, the value in A1 is 5 and the value in B2 is 6, so the formula will return "False".
12.
Explain the difference between AND and OR statements.
13.
Explain what recursively means? Give an example relating to Excel.
14.
Why will the following formula not work. =IF(A1>A2,”true”,Not true) when A1 is equal to 25 000 and A2 is equal to 23000
15.
Based on the graph #1 in the assignments and hand out section of our website, what two years did the CIS boys volleyball team achieve the same amount of wins?
Correct Answer
A. 2010 and 2012
Explanation
The graph mentioned in the question shows the number of wins achieved by the CIS boys volleyball team over the years. By analyzing the graph, it can be observed that the team achieved the same amount of wins in the years 2010 and 2012.