1.
When pound signs (######) appear in a cell, it means you have an incorrect formula.
Correct Answer
B. False
Explanation
When pound signs (######) appear in a cell, it means that the content of the cell is too long to fit within the width of the cell. It does not indicate an incorrect formula.
2.
An employee ID # would be entered as a label by preceding it with an apostrophe.
Correct Answer
B. False
Explanation
Entering an employee ID # as a label by preceding it with an apostrophe is not correct. In Excel, an apostrophe is used to indicate that a value should be treated as text, not as a numeric value. However, when entering an employee ID #, it is typically entered as a numeric value without any special characters. Therefore, the correct answer is false.
3.
The mathematical operator used in formulas to multiply values is a forward slash.
Correct Answer
B. False
Explanation
The mathematical operator used in formulas to multiply values is actually the asterisk (*), not the forward slash (/). The forward slash is used to represent division. Therefore, the statement is false.
4.
Cell addresses are used to develop formulas--not the values themselves.
Correct Answer
A. True
Explanation
Cell addresses are used in formulas to refer to specific cells in a spreadsheet. By using cell addresses, formulas can perform calculations using the values contained in those cells. The values themselves are not used directly in the formulas, but rather the cell addresses are used to retrieve the values and perform the necessary calculations. Therefore, the statement that cell addresses are used to develop formulas is correct.
5.
To undo a currency format in a cell, you simply click the $ sign button on the ribbon.
Correct Answer
B. False
Explanation
To undo a currency format in a cell, you do not simply click the $ sign button on the ribbon. Instead, you need to select the cell or range of cells that you want to remove the currency format from, go to the "Number" tab in the ribbon, and then select the "General" option from the list of number formats. This will remove the currency formatting and display the cell value without the $ sign.
6.
A defined area of the worksheet, such as (A1:A20), is called a series.
Correct Answer
A. True
Explanation
A defined area of the worksheet, such as (A1:A20), is called a series. This is true because in Excel, a series refers to a range of cells that are selected or defined together. In this case, the range (A1:A20) includes all the cells from A1 to A20, forming a series.
7.
An Invoice is an itemized bill.
Correct Answer
A. True
Explanation
An invoice is a document that provides a detailed breakdown of the goods or services provided, along with the corresponding costs. It is used as a request for payment from the buyer to the seller. Therefore, an invoice can be described as an itemized bill since it includes a list of individual items or services and their respective prices.
8.
Each cell has a unique address made up of a row number and a column letter.
Correct Answer
B. False
Explanation
Each cell in a spreadsheet does have a unique address made up of a row number and a column letter. The row number indicates the vertical position of the cell, while the column letter indicates the horizontal position. This unique address is commonly referred to as a cell reference and is used to identify and locate specific cells within a spreadsheet. Therefore, the statement is true.
9.
Gross pay is the amount one receives after deductions have been taken away.
Correct Answer
B. False
Explanation
The statement is false because gross pay is the total amount of money one receives before any deductions or taxes have been taken out. It represents the full amount of money earned by an individual before any deductions such as taxes, insurance premiums, or retirement contributions are subtracted from their paycheck.
10.
A cell can contain the following:
Correct Answer
D. All of the above
Explanation
A cell in a spreadsheet can contain different types of data, including numbers, formulas, and text. Numbers can be entered directly into a cell, formulas can be used to perform calculations using the values in other cells, and text can be entered to provide labels or descriptions. Therefore, the statement "all of the above" is correct, as it includes all the possible types of data that can be contained in a cell.
11.
A spreadsheet is a software program that allows one to:
Correct Answer
D. All of the above
Explanation
A spreadsheet is a software program that offers a range of functions, including organizing data, performing calculations, and creating charts. It provides a user-friendly interface for inputting and manipulating data, making it easier to organize and analyze information. With its built-in formulas and functions, it enables users to perform various calculations and generate accurate results. Additionally, spreadsheets allow users to create visual representations of data through charts and graphs, aiding in better understanding and presentation of information. Therefore, the correct answer is "all of the above" as spreadsheets encompass all these functionalities.
12.
The formula =E6-(F6+G6) directs the spreadsheet to:
Correct Answer
A. Add two numbers first, then subtract them from the first number
Explanation
The formula =E6-(F6+G6) directs the spreadsheet to add the numbers in cell F6 and G6 first, and then subtract the sum from the number in cell E6.
13.
All money amounts should be formatted to how many decimal places?
Correct Answer
B. Two
Explanation
Money amounts should typically be formatted to two decimal places. This is because most currencies around the world use two decimal places to represent fractions of a whole unit. It allows for accurate representation and calculation of monetary values. However, there may be certain cases or specific requirements where money amounts need to be formatted to a different number of decimal places, hence it depends on the context.
14.
The __________________________________ preceding a formula is important because it alerts Excel that you are entering a formula and not text.
Correct Answer
C. Equal sign
Explanation
The equal sign preceding a formula is important because it alerts Excel that you are entering a formula and not text. When you start a formula with an equal sign, Excel recognizes it as a command to perform a calculation or function. Without the equal sign, Excel would interpret the formula as text and not execute any calculations.
15.
To compute "Net Pay" in the following example, the formula would be:
Correct Answer
C. =E6-(F6+G6)
Explanation
The correct formula to compute "Net Pay" in the given example is =E6-(F6+G6). This formula subtracts the values in cells F6 and G6 from the value in cell E6 to calculate the net pay.
16.
The formula=MIN(A12:E12) will return the highest value in a range.
Correct Answer
B. False
Explanation
The formula MIN(A12:E12) will return the lowest value in a range, not the highest value. Therefore, the correct answer is False.
17.
Numbers are left-aligned in a cell.
Correct Answer
B. False
Explanation
Numbers are not left-aligned by default in a cell. In most spreadsheet software, including Microsoft Excel and Google Sheets, numbers are right-aligned in cells. This is because right-alignment makes it easier to perform calculations and read numerical data.
18.
Which of the following would characterize or indicate the active cell on a worksheet?
Correct Answer
C. It will appear in the name box and also have a heavy border around it.
Explanation
The active cell on a worksheet is characterized by appearing in the name box and having a heavy border around it. This means that the cell is currently selected and any actions or data input will affect that specific cell.
19.
Which is true about Functions in Excel
Correct Answer
D. All of the other answers are correct.
Explanation
The given correct answer states that all of the other answers are correct. This means that all of the statements mentioned in the question are true about Functions in Excel. Functions in Excel are indeed predefined formulas that perform specific calculations or actions. There are many different functions available in Excel for various purposes. They can be found and accessed using the Fx button or the Autosum dropdown. Therefore, the correct answer is that all of the other answers are correct.
20.
The y axis on a chart typically represents...
Correct Answer
D. The vertical scale
Explanation
The y axis on a chart typically represents the vertical scale. The vertical scale is used to measure and display the values of the dependent variable in a chart or graph. It represents the magnitude or quantity of the data being plotted along the vertical or y-axis. By using the vertical scale, we can interpret and compare the data points on the chart based on their vertical position.
21.
Under which part of the ribbon would you find the ability to print gridlines?
Correct Answer
C. Page Layout
Explanation
In the Page Layout part of the ribbon, you would find the ability to print gridlines. This section of the ribbon contains various options and settings related to the layout and formatting of the document or spreadsheet. One of these options is the ability to print gridlines, which can be useful when you want to include the gridlines in your printed document or spreadsheet for better readability.
22.
Under what tab on the toolbar would you go to find the Sort?
Correct Answer
C. Data
Explanation
To find the Sort function on the toolbar, you would go to the "Data" tab. This tab typically contains options and tools related to data manipulation and analysis, such as sorting, filtering, and data validation. The Sort function allows you to arrange data in ascending or descending order based on specific criteria, making it easier to analyze and organize large sets of information.
23.
Microsoft Excel is the only application for which one can download templates.
Correct Answer
B. False
Explanation
This statement is false. Microsoft Excel is not the only application for which one can download templates. There are various other applications and software, both online and offline, that offer downloadable templates for different purposes. Therefore, the given statement is incorrect.
24.
When creating a Chart in Microsoft Excel, you should never select empty rows and columns.
Correct Answer
A. True
Explanation
When creating a chart in Microsoft Excel, it is important to not select empty rows and columns because these empty cells may be included in the chart, resulting in inaccurate or misleading data representation. By selecting only the relevant data range, the chart will accurately reflect the intended information and avoid any confusion or misinterpretation.