1.
The symbol for division is...
Correct Answer
B. \
Explanation
The symbol for division is "\". This symbol is commonly used in mathematics to represent the operation of dividing one quantity by another.
2.
What is a pivot table?
Correct Answer
A. A report
Explanation
A pivot table is a data summarization tool used in spreadsheet programs like Excel. It allows users to analyze and summarize large amounts of data by organizing and presenting it in a structured format. With a pivot table, users can easily group, sort, filter, and perform calculations on the data to gain insights and make data-driven decisions. It provides a flexible and interactive way to explore and understand complex data sets, making it a powerful reporting tool.
3.
An nested if statement only allows for one argument?
Correct Answer
B. False
Explanation
A nested if statement allows for multiple arguments. It is a conditional statement within another conditional statement. This allows for more complex decision-making in programming, where multiple conditions need to be evaluated. Each if statement can have its own set of conditions and actions to be executed, providing greater flexibility in programming logic. Therefore, the correct answer is False.
4.
If the range lookup is false in a vlookup what does it mean?
Correct Answer
A. The result will return an exact match
Explanation
If the range lookup is false in a VLOOKUP, it means that the function will only return an exact match. This means that the function will only return a result if it finds an exact match for the lookup value in the first column of the specified range. If there is no exact match, the function will return an error or #N/A.
5.
By default how many worksheets are in a workbook?
Correct Answer
C. 3
Explanation
By default, a workbook in Excel has three worksheets. This means that when you open a new workbook, you will see three blank sheets where you can enter and organize your data. These worksheets can be used to separate different types of information or to perform various calculations and analysis. However, it is also possible to add or delete worksheets according to your needs.
6.
How many conditions can the sumif check for?
Correct Answer
A. 1
Explanation
The SUMIF function can check for only one condition. It allows you to specify a range of cells to check and a condition to be met for each cell in that range. The function then adds up the corresponding cells that meet the specified condition.
7.
A macro is a part of a conditional format?
Correct Answer
B. False
Explanation
A macro is not a part of a conditional format. A macro is a set of instructions or commands that can be executed to automate tasks in a computer program. On the other hand, a conditional format is a formatting rule applied to a cell or range of cells based on certain conditions. While both macros and conditional formats can be used to manipulate data in a spreadsheet, they serve different purposes and are not directly related to each other.
8.
A template is a worksheet which has all the necessary features you require?
Correct Answer
A. True
Explanation
A template is a pre-designed worksheet that includes all the necessary features and formatting needed for a specific purpose or task. It serves as a starting point or a blueprint for creating similar documents or worksheets. By using a template, users can save time and effort as they don't have to start from scratch and can instead modify the existing template to suit their needs. Therefore, the statement that a template is a worksheet which has all the necessary features you require is true.
9.
What is a scenario?
Correct Answer
A. Figures which switch between varying amounts
10.
The sumif function has the...... range, criteria, sum_range?
Correct Answer
A. True
Explanation
The sumif function indeed requires three parameters: range, criteria, and sum_range. The "range" refers to the range of cells that will be evaluated based on the given criteria. The "criteria" is the condition or criteria that the cells in the range must meet in order to be included in the sum calculation. Lastly, the "sum_range" is the range of cells that will be summed if the corresponding cells in the range meet the criteria. Therefore, the given answer is true.
11.
A lookup table counts the columns in the Col_index_No and not the cell reference?
Correct Answer
A. True
Explanation
A lookup table counts the columns in the Col_index_No and not the cell reference. This means that when performing a lookup, the table will consider the position of the column in the table rather than the specific cell reference within that column. This is important to understand because it affects how the lookup function retrieves data from the table. By counting the columns, the lookup function can accurately locate and retrieve the desired information based on the given column index.
12.
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 fill handle or autofill feature in Excel allows you to automatically complete a list of 12 months after entering one month. This feature is particularly useful when you need to quickly populate a column or row with sequential data. By clicking and dragging the fill handle, Excel recognizes the pattern and automatically fills in the remaining months. This saves time and ensures accuracy when entering repetitive data.
13.
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 correct answer because this command allows you to combine multiple cells into one cell while still occupying the same screen space. This can be useful when you want to create a heading or label that spans across multiple columns or rows. By merging and centering the cells, the content will be centered within the new merged cell, creating a cleaner and more organized appearance in the spreadsheet.
14.
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 keep the reference fixed, meaning that it will not change when the formula is copied to other cells. This is useful when you want to refer to a specific cell consistently, regardless of where the formula is located.
15.
What type of operation is being preformed in the formula =A4*B5
Correct Answer
E. Multiplication
Explanation
The formula =A4*B5 is performing a multiplication operation. It is multiplying the values in cell A4 and B5 to give a result.
16.
Which orientation is taller than it is wide?
Correct Answer
B. Portrait
Explanation
Portrait orientation refers to an image or document that is taller than it is wide. This means that the height of the image or document is greater than its width. In contrast, landscape orientation refers to an image or document that is wider than it is tall. Therefore, the correct answer is portrait.
17.
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 foundation for creating other workbooks. It provides a pre-designed structure and formatting, allowing users to easily create new workbooks with consistent layouts and styles. By using a template, users can save time and effort by not having to recreate the same formatting and layout for each new workbook they create. Templates are commonly used in various applications, including spreadsheet software, to streamline the creation process and ensure consistency across multiple documents.
18.
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 directly within the cell, without having to go to a separate editing window or menu.
19.
Three types of data visualation 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 techniques commonly used in spreadsheet software such as Microsoft Excel. Data bars are horizontal bars that represent the values in a range of cells, allowing for easy comparison. Color scales use different colors to represent different values, making it easier to identify patterns and trends. Icon sets use symbols or icons to represent data, providing a visual representation of the values in a range of cells. These techniques help users understand and analyze data more effectively.
20.
Name the function that adds cell values only if they meet your criteria.
Correct Answer
D. SumIF()
Explanation
The SumIF() function is used to add cell values only if they meet a specified criteria. It allows you to set a condition or criteria that the cells must meet in order to be included in the sum. This function is commonly used in Excel to perform calculations based on specific conditions.
21.
What function would display the highest sales amount in a column?
Correct Answer
C. Max()
Explanation
The Max() function is used to display the highest value in a given column. It compares all the values in the column and returns the maximum value. In the context of sales amount, using the Max() function would give us the highest sales amount recorded in the column.
22.
Which logical function shows the opposite of the condition?
Correct Answer
A. NOT function
Explanation
The correct answer is the NOT function. The NOT function is a logical function that returns the opposite value of a given condition. It takes a single argument and returns TRUE if the argument is FALSE, and vice versa. This function is commonly used to negate or reverse the logical value of a condition.
23.
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 inside another function. This allows the nested function to access variables and parameters from the outer function. It is commonly used to organize code and create more modular and reusable functions. By nesting functions, it is possible to encapsulate specific functionality within a broader function, making the code more manageable and easier to understand.
24.
What does a hyperlink do?
Correct Answer
B. Displays a website
Explanation
A hyperlink is a clickable element that, when selected, redirects the user to another webpage or document. It is commonly used to navigate between different sections of a website or to link to external sources. Therefore, the correct answer "Displays a website" accurately describes the primary function of a hyperlink.
25.
Which function enters the current date?
Correct Answer
D. TODAY()
Explanation
The correct answer is TODAY(). The TODAY() function is used to enter the current date in a cell.
26.
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, taking into account leap years. By dividing the number of days by this value, you will get the equivalent number of years.
27.
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, returning only the integer part. It is commonly used in financial calculations or when working with data that requires whole numbers. This function can be helpful when you need to round down a number to the nearest whole number or when you want to remove the decimal portion of a value without rounding it.
28.
What is a Worksheet Tab in Excel 2010?
Correct Answer
B. A worksheet tab is used to activate a worksheet by click on its sheet tab found at the bottom of the Worksheet.
Explanation
Worksheet tab is located on the left side of the bottom of the worksheet area. When you first open an Excel 2010 workbook, by default, it come with 3 worksheet. Using Option in Backstage view, you can customize to have 1 or more worksheet when you open a workbook. If you need more worksheet, you can add them by clicking the Insert Worksheet button at the right of the last worksheet tab.
29.
What is Formulas Tab in Microsoft Excel 2010?
Correct Answer
D. Formula Tab contains formula related functionalities such as function Library,Formula Auditing, Defining Names and Calculations.
Explanation
Formulas Tab in Excel 2010 contains Function Library, Defined Names, Formula Auditing and Calcualtion Groups.
30.
What will be the formula in the cell B3 if you want to calculate the profit?
Correct Answer
C. =B1-B2
Explanation
Profit is equal to Revenue(B1) - Expense(B2). There the formula in B3 should be =B1 - B2.
31.
The location of a cell in a worksheet indicated by the column and a row
Correct Answer
C. Cell address
Explanation
The cell address refers to the specific location of a cell in a worksheet, which is indicated by the column letter and row number. It is used to uniquely identify and reference a cell in formulas, functions, and data manipulation operations. The cell address helps in organizing and retrieving data effectively within a worksheet by providing a systematic way to locate and work with specific cells.
32.
In the example C5, the "C" represents the cell's
Correct Answer
A. Column
Explanation
In the example C5, the "C" represents the cell's column. This is because in spreadsheet software, such as Microsoft Excel, each cell is identified by a combination of its column letter and row number. In this case, the letter "C" indicates that the cell is located in the third column of the spreadsheet.
33.
A row is...
Correct Answer
B. A horizontal range of cells referred to by a number
Explanation
A row is a horizontal range of cells referred to by a number. In a spreadsheet, rows are identified by numbers, typically starting from 1. Each row contains multiple cells that run horizontally across the spreadsheet. By specifying the row number, you can access or manipulate the data contained within that particular row.
34.
A sheet tab is located at the bottom of the worksheet window and is used to display the...
Correct Answer
C. Worksheet name
Explanation
The sheet tab is located at the bottom of the worksheet window and is used to display the worksheet name. This allows users to easily identify and switch between different worksheets within a workbook.
35.
This is a built-in formula that enables you to perform common calculations in a workbook
Correct Answer
A. Function
Explanation
The given correct answer is "function". This is because a function is a built-in formula in a workbook that allows users to perform common calculations. Functions can be used to perform mathematical operations, manipulate text, analyze data, and more. They are pre-defined formulas that can be easily applied to cells or ranges in a spreadsheet to automate calculations and save time.
36.
All formulas begin with this symbol
Correct Answer
C. = (equal sign)
Explanation
The equal sign (=) is the symbol that is used to start all formulas. It is commonly used in mathematical equations and programming languages to indicate that two expressions have the same value. In formulas, the equal sign is used to assign values to variables or to compare two values. It is an essential symbol in mathematical operations and calculations.
37.
In the formula =SUM(A10:A15), which part is the cell reference?
Correct Answer
B. (A10:A15)
Explanation
The cell reference in the formula =SUM(A10:A15) is (A10:A15). This is because the range of cells A10 to A15 is specified within the parentheses, indicating that the sum function should be applied to those cells. The colon between A10 and A15 represents a range, so the formula will calculate the sum of all the values in that range.
38.
What cell reference refers to a range of cells in column D, rows 4 through 9?
Correct Answer
A. (D4:D9)
Explanation
The cell reference (D4:D9) refers to a range of cells in column D, specifically rows 4 through 9. This means that it includes all the cells in column D from row 4 to row 9, creating a vertical range of cells.
39.
If you enter a formula and #### shows in the cell, what does that mean?
Correct Answer
B. The column width is not wide enough to display the results
Explanation
If #### shows in a cell after entering a formula, it means that the column width is not wide enough to display the results. This happens when the result of the formula is too long to fit within the current column width. To fix this, you can either increase the column width or adjust the format of the cell to accommodate the result.
40.
If you entered in the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you have to delete the formula and start again.
Correct Answer
B. False
Explanation
If you entered the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you do not have to delete the formula and start again. Instead, you can simply edit the formula by correcting the spelling mistake to =SUM(C3:C7) without deleting the entire formula. Therefore, the statement is false.
41.
When entering data across a row, you should use the TAB key to move the cursor to the next cell.
Correct Answer
A. True
Explanation
When entering data across a row, using the TAB key to move the cursor to the next cell is a common practice. This allows for efficient and quick data entry as it eliminates the need to manually click on each cell. Additionally, using the TAB key helps maintain a consistent and organized flow of data entry, ensuring accuracy and reducing errors. Therefore, the statement is true.
42.
The only way to view a formula you entered in a cell is to look at the formula bar.
Correct Answer
B. False
Explanation
You can view a formula you entered in a cell by simply selecting the cell. The formula will be displayed in the formula bar at the top of the Excel window. Therefore, the statement "The only way to view a formula you entered in a cell is to look at the formula bar" is false.
43.
To easily add a header or footer to your worksheet you should be in page layout view.
Correct Answer
A. True
Explanation
To easily add a header or footer to your worksheet, you should be in page layout view. In this view, you can see how the worksheet will appear when printed, including the header and footer sections. This allows you to easily navigate and make changes to the header and footer content. In other views, such as normal view, the header and footer sections may not be visible or accessible, making it more difficult to add or modify them. Therefore, being in page layout view is the recommended option for adding a header or footer to your worksheet.
44.
In the cell reference $F9, the column is fixed, but the row will change when copied.
Correct Answer
A. True
Explanation
In the cell reference $F9, the dollar sign before the column letter indicates that the column is fixed. This means that when the reference is copied to other cells, the column will remain the same. However, since there is no dollar sign before the row number, the row will change when the reference is copied. Therefore, the statement is true.
45.
The shortcut to show formulas in your worksheet is...
Correct Answer
A. Ctrl + ~
Explanation
To show formulas in your worksheet, you can use the shortcut Ctrl + ~. This shortcut toggles between showing the actual formulas in the cells instead of their calculated values.