Excel - Pre Test

The AutoCalculate feature in Excel allows users to quickly view the sum and average of selected cells without having to manually input formulas. This feature is useful for quickly obtaining basic calculations without the need for complex formulas. Therefore, the correct answer is SUM and AVERAGE.

not-available-via-ai

The Page Layout view shows margins and rulers. This view allows users to see how the document will look when printed and adjust margins accordingly. The rulers help in aligning and positioning text, images, and other elements on the page.

The function =SUMIF(D7:D14, ">1") calculates the sum of values in cells D7:D14 only if the value is greater than 1.

The ROUND function is used to round a number to a specified number of decimal places. In this case, the number 3.4567 is being rounded to 2 decimal places. The ROUND function rounds up if the next digit is 5 or greater, and rounds down if the next digit is 4 or less. Therefore, the value that would be used in a formula that refers to the cell containing =ROUND(3.4567,2) is 3.46.

The argument "Rate" in a financial function indicates the interest for a period. This parameter is used to specify the interest rate per period in financial calculations. It is an essential component in calculations such as determining the future value or present value of an investment, calculating loan payments, or evaluating the profitability of an investment. The "Rate" argument allows for accurate and precise financial analysis by considering the interest rate associated with a specific period.

Lookup and Reference functions are used to obtain data or display information from the current or other workbooks. These functions allow users to search for specific values in a table or range and retrieve corresponding data or information. They are commonly used in Excel to perform tasks such as searching for a specific value in a large dataset, retrieving values from different worksheets or workbooks, and creating dynamic formulas that automatically update when the referenced data changes. Therefore, the correct answer is Lookup and Reference.

PivotTables are considered interactive because they allow users to rearrange row and column data. This means that users can easily change the layout of the data to analyze it from different perspectives. By rearranging the rows and columns, users can quickly summarize and compare different aspects of the data, making the analysis process more dynamic and flexible. This interactivity enables users to explore and understand the data more effectively.

A relative reference is different from an absolute reference because it adjusts to its location on the worksheet. Unlike an absolute reference, which always refers to a specific cell, a relative reference is flexible and changes its reference based on its position relative to other cells. This means that if the relative reference is copied or moved to a different cell, it will automatically adjust its reference accordingly. This allows for more dynamic and flexible formulas in Excel.

The category in the Format Cells dialog box that is used to define a unique format for a date is "Custom". This category allows users to create their own customized formats for dates, such as displaying the date in a specific order or including additional text or symbols. By selecting the "Custom" category, users have the flexibility to design a format that meets their specific needs and preferences for displaying dates.

A mixed reference is a reference that contains both absolute and relative references. In this case, the correct answer is $B1 because the column reference ($B) is absolute, while the row reference (1) is relative. This means that when the formula is copied or filled down to other cells, the column reference will stay the same ($B), but the row reference will change based on the relative position of the new cell.

A macro is a set of instructions or commands that are recorded and can be executed to automate tasks in a software program. In this context, a Visual Basic routine refers to a macro that is written using the Visual Basic programming language. Therefore, the correct answer is Visual Basic routine.

Range names can be used for navigation within a worksheet, allowing users to quickly jump to specific areas. This feature enhances the ease of use and navigation within a large worksheet. Therefore, the statement "They can be used for navigation" is true, not false.