1.
What is the keyboard shortcut command to move the mouse pointer to cell A1
Correct Answer
A. Control + Home
Explanation
The keyboard shortcut command "Control + Home" is used to move the mouse pointer to cell A1. This shortcut is commonly used in spreadsheet applications such as Microsoft Excel to quickly navigate to the first cell of the worksheet. By pressing the Control key and the Home key simultaneously, the user can easily jump to the top-left cell of the active sheet.
2.
A workbook contains
Correct Answer
C. 3 worksheets
Explanation
The correct answer is 3 worksheets. This means that the workbook being referred to contains a total of three worksheets.
3.
The feature that enables you to automatically complete a list of 12 months after you key one month is
Correct Answer
B. Fill handle or Autofill
Explanation
The correct answer is Fill handle or Autofill. This feature in Excel allows you to automatically complete a list of 12 months after you enter one month. By dragging the fill handle or using the Autofill option, Excel recognizes the pattern and fills in the remaining months accordingly. This saves time and effort in manually entering each month individually.
4.
What is the default alignment for values and dates in a cell?
Correct Answer
E. Right aligned
Explanation
The default alignment for values and dates in a cell is right aligned. This means that the content within the cell is aligned towards the right side of the cell. This is the standard alignment for numerical data and dates, as it allows for easy comparison and reading of the values.
5.
What command combines several cells into one cell ocupying the same screen space?
Correct Answer
A. Merge and Center
Explanation
Merge and Center is the command that combines several cells into one cell occupying the same screen space. This command is useful when you want to create a single, larger cell by merging multiple adjacent cells together. It is commonly used for creating headers or titles that span across multiple columns or rows in a spreadsheet or table. By merging and centering cells, the content within the merged cell is automatically centered both horizontally and vertically, making it visually appealing and easier to read.
6.
What is the keyboard shortcut to display or hide formulas?
Correct Answer
B. Control + ~
Explanation
The correct answer is Control + ~. This keyboard shortcut is used to display or hide formulas in Excel. By pressing Control + ~, the user can toggle between viewing the actual formulas in the cells or the calculated results. This is a helpful feature for users who need to review or troubleshoot formulas in their spreadsheets.
7.
How would the cell reference $F$4 be described?
Correct Answer
B. Absolute reference
Explanation
The cell reference $F$4 is described as an absolute reference because the dollar signs before the column and row identifiers indicate that the reference is fixed and will not change when copied or filled. This means that if the cell reference $F$4 is copied to another cell, it will always refer to cell F4 and not adjust based on the new location.
8.
What type of operation is being performed in the formula = A4*B5?
Correct Answer
E. Multiplication
Explanation
The formula = A4*B5 indicates a multiplication operation. The asterisk (*) symbol is commonly used in mathematical formulas to represent multiplication. Therefore, the correct answer is multiplication.
9.
Which orientation is taller than it is wide?
Correct Answer
B. Portrait
Explanation
Portrait orientation is taller than it is wide. This means that the height of the object or image is greater than its width. It is commonly used for photographs or paintings of individuals or objects that are taller than they are wide.
10.
What term describes a model workbook used as the basis for other workbooks?
Correct Answer
C. Template
Explanation
A template is a model workbook that serves as the basis for creating other workbooks. It provides a pre-designed structure and formatting, such as column headers, formulas, and cell styles, that can be customized and reused for different purposes. By using a template, users can save time and ensure consistency in their workbooks by starting with a predefined layout and design.
11.
How can you start Edit mode to edit a formula?
Correct Answer
D. F2 or double-click cell
Explanation
To start Edit mode and edit a formula, you can either press the F2 key on your keyboard or simply double-click on the cell containing the formula. This will allow you to make changes to the formula and update it accordingly.
12.
Three types of data visualization are:
Correct Answer
B. Data bars, Color scales, Icon sets
Explanation
The correct answer is "Data bars, Color scales, Icon sets". These are three types of data visualization that can be used to represent data in a visually appealing and informative way. Data bars are horizontal bars that are used to represent the value of a cell, with longer bars indicating higher values. Color scales use different colors to represent the magnitude of values, with a gradient from one color to another. Icon sets are small icons or symbols that are used to represent different categories or levels of data. These visualizations can help users quickly understand and interpret data.
13.
Name the function that adds cell values only if they meet your criteria.
Correct Answer
D. SumIF()
Explanation
The function "SumIF()" is the correct answer because it allows you to add cell values only if they meet a specific criteria. This function takes two arguments: a range of cells to evaluate and a criteria to determine which cells to include in the sum. It is commonly used in spreadsheet applications like Microsoft Excel to perform conditional calculations.
14.
What function would display the highest sales amount in a column?
Correct Answer
C. Max()
Explanation
The Max() function is used to find the maximum value in a column. In this case, it will display the highest sales amount in the column. The Min() function would display the lowest sales amount, Avg() would display the average sales amount, Most() is not a valid function, and Sum() would display the sum of all the sales amounts. Therefore, the correct function to display the highest sales amount is Max().
15.
Which logical function shows the opposite of the condition?
Correct Answer
A. NOT function
Explanation
The NOT function is the logical function that shows the opposite of the condition. It takes a single argument and returns the opposite boolean value. If the argument is true, it returns false, and if the argument is false, it returns true. Therefore, the NOT function is the correct answer as it performs the opposite operation on the condition.
16.
Which financial function would help you determine how much money will be in your account at the end of a year if you make regular payments?
Correct Answer
C. FV function
Explanation
The FV function, or Future Value function, would help determine how much money will be in your account at the end of a year if you make regular payments. This function calculates the future value of an investment based on a series of regular payments, a fixed interest rate, and a specified number of periods. It takes into account the present value of the payments and the interest earned over time to calculate the final amount.
17.
What is the term used to describe a function inside a function?
Correct Answer
C. Nested
Explanation
A nested function refers to a function that is defined within another function. This allows the inner function to access variables and parameters from the outer function, creating a hierarchical structure. This concept is often used in programming to organize code and improve code readability.
18.
What does a hyperlink do?
Correct Answer
B. Displays a website
Explanation
A hyperlink is a clickable element that, when clicked, redirects the user to another webpage or website. It is commonly used in documents, presentations, and websites to provide easy access to additional information or related content. When a hyperlink is clicked, it displays the website or webpage associated with it, allowing the user to navigate to the desired destination.
19.
Which function enters the current date?
Correct Answer
D. TODAY()
Explanation
The function TODAY() is used to enter the current date.
20.
How would Excel display this value =ROUND(1.567) in the cell?
Correct Answer
C. 1.57
Explanation
Excel would display the value =ROUND(1.567) as 1.57 in the cell. The ROUND function in Excel is used to round a number to a specified number of decimal places. In this case, since no decimal places are specified in the ROUND function, Excel will round the number to the nearest whole number, resulting in 2. However, since the cell is formatted to display two decimal places, Excel will display the rounded number as 1.57.
21.
How can you convert days into years?
Correct Answer
A. Divide days by 365.25
Explanation
To convert days into years, you need to divide the number of days by 365.25. This is because a year is approximately 365.25 days long, taking into account leap years. By dividing the number of days by this average length of a year, you can determine the equivalent number of years.
22.
What does the TRUNC function do?
Correct Answer
D. Removes the decimal part of the number
Explanation
The TRUNC function is used to remove the decimal part of a number. It essentially truncates or cuts off the decimal portion, leaving only the integer part of the number. This can be useful in situations where only whole numbers are needed or when working with financial data that requires precision without decimals.
23.
What does Excel do if a function is volatile?
Correct Answer
C. Recaculates it based on the computer where it is opened
Explanation
If a function in Excel is marked as volatile, it means that the function can produce different results each time it is calculated, even if the input values have not changed. When a volatile function is used in a workbook, Excel will recalculate it every time any change is made to the workbook, or when the workbook is opened on a different computer. This ensures that the function always reflects the most up-to-date information and takes into account any changes in the environment where it is being used.