1.
In Excel 2007 you can write simple formulas that cannot automatically update their results when values change
Correct Answer
B. False
Explanation
In Excel 2007, simple formulas can automatically update their results when values change. This means that if any of the input values in the formula are modified, the formula will recalculate and update the result accordingly. Therefore, the statement that simple formulas cannot automatically update their results when values change is false.
2.
The two CDs purchased in February cost $12.99 and $16.99. The total of these two values is the CD expense for the month.
You can add these values in Excel by typing a simple formula in a cell:
Correct Answer
A. =12.99+16.99
Explanation
The given answer is incorrect. The correct answer is =12.99+16.99, which is the formula to add the two CD costs together. The other options provided in the question are either incorrect formulas or incorrect calculations.
3.
A 'function' in Excel is :
Correct Answer
B. Prewritten formula
Explanation
The correct answer is "prewritten formula." In Excel, a function is a predefined formula that performs calculations or manipulates data. These functions can be used to perform various tasks, such as mathematical calculations, text manipulation, date and time calculations, and more. By using functions, users can save time and effort by utilizing these prewritten formulas instead of manually creating complex calculations.
4.
The button shown below is use for ________ in Excel
Correct Answer
C. Adds up all the values in a range of cells
Explanation
The button shown below is used to add up all the values in a range of cells in Excel. This feature is commonly used when you want to quickly calculate the total of a set of values in a specific range. By selecting the range of cells and clicking on this button, Excel will automatically sum up all the values and display the result. This is a convenient way to perform calculations and obtain the total sum without having to manually input the formula.
5.
A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
Correct Answer
C. Click in cell C6
Explanation
Clicking in cell C6 allows you to view the formula in the formula bar at the top of the Excel window. This way, you can see the formula that was used to calculate the result in cell C6.
6.
Relative references:
Correct Answer
C. Change as they are copied
Explanation
Relative references change as they are copied. This means that when a formula or reference is copied to another cell, the reference will adjust based on its new location. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically adjust to B2. This allows for easy replication of formulas without having to manually update each reference.
7.
Formula =C4*$D$9 - absolute cell reference is:
Correct Answer
D. $D$9
Explanation
The correct answer is $D$9 because it is an example of an absolute cell reference. In Excel, the dollar sign ($) is used to indicate an absolute reference, which means that the cell reference will not change when copied or filled down to other cells. In this case, $D$9 will always refer to the same cell, regardless of where the formula is copied to.
8.
$A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes
Correct Answer
A. True
Explanation
The given statement is true. A1 is an example of a mixed reference because it contains both an absolute reference (column A) and a relative reference (row 1). When a mixed reference is copied from one cell to another, the absolute reference remains the same while the relative reference changes based on the new cell location.
9.
If you copy the formula =C1*$D$9 from cell C1 to cell C2, what will the formula be in cell C5?
Correct Answer
D. Cant say from the given question
10.
The MAX function finds the _______
Correct Answer
B. Largest number in a range of numbers
Explanation
The MAX function in Excel Sheet finds the largest number within a specified range of numbers. It is used to determine the maximum value in a set of data, allowing users to easily identify the highest value present.
11.
The ##### error value indicates
Correct Answer
D. That the column is too narrow to display the contents of this
Explanation
The given correct answer suggests that the ##### error value indicates that the column is too narrow to display the contents of this. This error occurs when the data in a cell is too wide to fit within the column width, causing the cell to display a series of hash marks (#####) instead of the actual content. To resolve this error, the column width needs to be adjusted to accommodate the data.
12.
How would you print formulas?
Correct Answer
C. Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.
Explanation
To print formulas in Excel 2007, you need to go to the Formulas tab and point to Formula Auditing. Then, click on Show Formulas to display the formulas in the cells. After that, click the Microsoft Office Button and select Print to print the formulas along with the rest of the spreadsheet.
13.
In the practice, you learned that if you misspell SUM in this formula =SUME(B4:B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again.
Correct Answer
B. False
Explanation
The explanation for the given correct answer, which is False, is that if you misspell "SUM" in the formula "=SUME(B4:B7)", you can simply edit the formula and correct the spelling mistake. You do not need to delete the formula and start over again.
14.
Excel will calculate date :1/20/1900 (month/day/year) as:
Correct Answer
C. 20
Explanation
Excel treats dates as numbers, with each date being represented by a unique number. In this case, the date 1/20/1900 would be represented by the number 20. Therefore, the correct answer is 20.
15.
What would happen if you used a formula to do math with dates?
Correct Answer
C. Excel will not give any Error as you can do math with dates in Excel
Explanation
When using a formula to do math with dates in Excel, the program will not give any error. This is because Excel has built-in functions and formulas that allow for mathematical operations to be performed on dates. These functions and formulas can be used to calculate the difference between two dates, add or subtract days, months, or years from a date, and perform other mathematical operations involving dates. Therefore, Excel will not give an error when using a formula to do math with dates.
16.
In Excel if you write =TODAY() in the formula bar (Fx)
Correct Answer
B. It will give you today's date
Explanation
When you write =TODAY() in the formula bar in Excel, it will give you today's date. The TODAY() function is a built-in function in Excel that returns the current date. By entering this formula, Excel will automatically update the cell with the current date whenever the worksheet is opened or recalculated.