MS Excel Assessment Test: Questions & Answers
(146).jpg "MS Excel Assessment Test: Questions & Answers - Quiz")
Think you are an expert in MS Excel? How much do you know about spreadsheets, cells, columns, etc.? Can you apply formulas on cells to get desired results? Take the online quiz to test your knowledge and brush up on your basics along the way.
Questions and Answers
- 1.
When pound signs (######) appear in a cell, it means you have an incorrect formula.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 2.
An employee ID # would be entered as a label by preceding it with an apostrophe.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 3.
The mathematical operator used in formulas to multiply values is a forward slash.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 4.
Cell addresses are used to develop formulas--not the values themselves.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 5.
To undo a currency format in a cell, you simply click the $ sign button on the ribbon.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 6.
A defined area of the worksheet, such as (A1:A20), is called a series.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 7.
An Invoice is an itemized bill.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 8.
Each cell has a unique address made up of a row number and a column letter.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 9.
Gross pay is the amount one receives after deductions have been taken away.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 10.
A cell can contain the following:
- A.
Number
- B.
Formula
- C.
Text
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 11.
A spreadsheet is a software program that allows one to:
- A.
Organize data
- B.
Calculate answers
- C.
Chart data
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 12.
The formula =E6-(F6+G6) directs the spreadsheet to:
- A.
Add two numbers first, then subtract them from the first number
- B.
Multiply two numbers first, then subtract the first number
- C.
Subtract the first number and add the following two numbers
- D.
Divide the first number by the sum of the second two numbers
Correct Answer
A. Add two numbers first, then subtract them from the first numberExplanation
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.Rate this question:
-
- 13.
All money amounts should be formatted to how many decimal places?
- A.
One
- B.
Two
- C.
Zero
- D.
It depends
Correct Answer
B. TwoExplanation
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.Rate this question:
-
- 14.
The __________________________________ preceding a formula is important because it alerts Excel that you are entering a formula and not text.
- A.
Exclamation point
- B.
Asterisk
- C.
Equal sign
- D.
Apostrophe
Correct Answer
C. Equal signExplanation
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.Rate this question:
-
- 15.
To compute "Net Pay" in the following example, the formula would be:
- A.
=E6-F6-G6-H6
- B.
=E6+F6+G6
- C.
=E6-(F6+G6)
- D.
None of the Above
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.Rate this question:
-
- 16.
The formula=MIN(A12:E12) will return the highest value in a range.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The formula MIN(A12:E12) will return the lowest value in a range, not the highest value. Therefore, the correct answer is False.Rate this question:
-
- 17.
Numbers are left-aligned in a cell.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 18.
Which of the following would characterize or indicate the active cell on a worksheet?
- A.
Heavy border around it
- B.
Appears in the name box
- C.
It will appear in the name box and also have a heavy border around it.
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.Rate this question:
-
- 19.
Which is true about Functions in Excel
- A.
It is a predefined formula
- B.
There are many
- C.
Can be found using the Fx button are the Autosum dropdown
- D.
All of the other answers are correct.
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.Rate this question:
-
- 20.
The y axis on a chart typically represents...
- A.
The horizontal scale
- B.
The axes titles
- C.
The diagonal scale
- D.
The vertical scale
Correct Answer
D. The vertical scaleExplanation
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.Rate this question:
-
- 21.
Under which part of the ribbon would you find the ability to print gridlines?
- A.
Insert
- B.
Data
- C.
Page Layout
- D.
Home
Correct Answer
C. Page LayoutExplanation
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.Rate this question:
-
- 22.
Under what tab on the toolbar would you go to find the Sort?
- A.
Home
- B.
Page Layout
- C.
Data
- D.
Insert
Correct Answer
C. DataExplanation
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.Rate this question:
-
- 23.
Microsoft Excel is the only application for which one can download templates.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 24.
When creating a Chart in Microsoft Excel, you should never select empty rows and columns.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 12, 2017Quiz Created by
Selena Skipper
Back to top