Excel - Online Assessment
Questions and Answers
- 1.
The symbol for division is...
- A.
$
- B.
\
- C.
*
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.Rate this question:
-
- 2.
What is a pivot table?
- A.
A report
- B.
An advanced filter
- C.
A filter
- D.
Vlookup
Correct Answer
A. A reportExplanation
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.Rate this question:
-
- 3.
An nested if statement only allows for one argument?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 4.
If the range lookup is false in a vlookup what does it mean?
- A.
The result will return an exact match
- B.
The result will return the nearest match
- C.
It will return a negative
- D.
None of the above
Correct Answer
A. The result will return an exact matchExplanation
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.Rate this question:
-
- 5.
By default how many worksheets are in a workbook?
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
C. 3Explanation
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.Rate this question:
-
- 6.
How many conditions can the sumif check for?
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
A. 1Explanation
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.Rate this question:
-
- 7.
A macro is a part of a conditional format?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 8.
A template is a worksheet which has all the necessary features you require?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 9.
What is a scenario?
- A.
Figures which switch between varying amounts
- B.
A conditional format
- C.
A macro
- D.
An IF statement
Correct Answer
A. Figures which switch between varying amounts -
- 10.
The sumif function has the...... range, criteria, sum_range?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 11.
A lookup table counts the columns in the Col_index_No and not the cell reference?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 12.
The feature that enables you to automatically complete a list of 12 months after you key one month is
- A.
Cell style
- B.
Fill handle or Autofill
- C.
Page layout
- D.
Find
- E.
Replace
Correct Answer
B. Fill handle or AutofillExplanation
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.Rate this question:
-
- 13.
What command combines several cells into one cell ocupying the same screen space?
- A.
Merge and Center
- B.
Align
- C.
Freeze columns
- D.
Indent
- E.
Split
Correct Answer
A. Merge and CenterExplanation
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.Rate this question:
-
- 14.
How would the cell reference $F$4 be described?
- A.
Mixed reference
- B.
Absolute reference
- C.
Relative reference
- D.
Additional reference
- E.
Money reference
Correct Answer
B. Absolute referenceExplanation
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.Rate this question:
-
- 15.
What type of operation is being preformed in the formula =A4*B5
- A.
Addition
- B.
Subtraction
- C.
Division
- D.
Percentage
- E.
Multiplication
Correct Answer
E. MultiplicationExplanation
The formula =A4*B5 is performing a multiplication operation. It is multiplying the values in cell A4 and B5 to give a result.Rate this question:
-
- 16.
Which orientation is taller than it is wide?
- A.
Landscape
- B.
Portrait
Correct Answer
B. PortraitExplanation
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.Rate this question:
-
- 17.
What term describes a model workbook used as the basis for other workbooks?
- A.
Form
- B.
Demonstration
- C.
Template
- D.
Cell styles
- E.
Page Layout
Correct Answer
C. TemplateExplanation
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.Rate this question:
-
- 18.
How can you start Edit mode to edit a formula?
- A.
Tools
- B.
Format
- C.
F4
- D.
F2 or double-click cell
- E.
Find and replace
Correct Answer
D. F2 or double-click cellExplanation
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.Rate this question:
-
- 19.
Three types of data visualation are:
- A.
Tools, Columns, Styles
- B.
Data bars, Color scales, Icon sets
- C.
Cell styles, Bold, Italics
- D.
Home, Edit, Fill
- E.
Shapes, Arrows, Clip art
Correct Answer
B. Data bars, Color scales, Icon setsExplanation
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.Rate this question:
-
- 20.
Name the function that adds cell values only if they meet your criteria.
- A.
Average()
- B.
Count()
- C.
Mean()
- D.
SumIF()
- E.
Round
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.Rate this question:
-
- 21.
What function would display the highest sales amount in a column?
- A.
Min()
- B.
Avg()
- C.
Max()
- D.
Most()
- E.
Sum()
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.Rate this question:
-
- 22.
Which logical function shows the opposite of the condition?
- A.
NOT function
- B.
False function
- C.
Nper function
- D.
Sum function
- E.
PMT function
Correct Answer
A. NOT functionExplanation
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.Rate this question:
-
- 23.
What is the term used to describe a function inside a function?
- A.
Conditional
- B.
Argument
- C.
Nested
- D.
Double
- E.
Hyperlink
Correct Answer
C. NestedExplanation
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.Rate this question:
-
- 24.
What does a hyperlink do?
- A.
Adds another argument
- B.
Displays a website
- C.
Formats worksheet
- D.
Hides worksheets
Correct Answer
B. Displays a websiteExplanation
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.Rate this question:
-
- 25.
Which function enters the current date?
- A.
Now()
- B.
Days()
- C.
DDYYMM
- D.
TODAY()
Correct Answer
D. TODAY()Explanation
The correct answer is TODAY(). The TODAY() function is used to enter the current date in a cell.Rate this question:
-
- 26.
How can you convert days into years?
- A.
Divide days by 365.25
- B.
Multiply days by 360
- C.
Add Number of years
- D.
Format days
Correct Answer
A. Divide days by 365.25Explanation
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.Rate this question:
-
- 27.
What does the TRUNC function do?
- A.
Formats data
- B.
Indents data
- C.
Adds numbers
- D.
Removes the decimal part of the number
Correct Answer
D. Removes the decimal part of the numberExplanation
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.Rate this question:
-
- 28.
What is a Worksheet Tab in Excel 2010?
- A.
A worksheet tab is used to move from one cell to the next cell in a worksheet
- B.
A worksheet tab is used to activate a worksheet by click on its sheet tab found at the bottom of the Worksheet.
- C.
A worksheet tab is used to access tools associated with the worksheet
- D.
A worksheet tab is used to get help when working with Microsoft 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.Rate this question:
-
- 29.
What is Formulas Tab in Microsoft Excel 2010?
- A.
Formulas tab provides help in writing a formula in Excel Formulas tab automatically checks the formula in your workbook.
- B.
Formulas tab is used for writing the formula for you.
- C.
Formulas tab contains all the formulas supported by Excel
- D.
Formula Tab contains formula related functionalities such as function Library,Formula Auditing, Defining Names and Calculations.
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.Rate this question:
-
- 30.
What will be the formula in the cell B3 if you want to calculate the profit?
- A.
=A1-A2
- B.
=B2-B1
- C.
=B1-B2
- D.
None of the above
Correct Answer
C. =B1-B2Explanation
Profit is equal to Revenue(B1) - Expense(B2). There the formula in B3 should be =B1 - B2.Rate this question:
-
- 31.
The location of a cell in a worksheet indicated by the column and a row
- A.
Formula
- B.
Operator
- C.
Cell address
Correct Answer
C. Cell addressExplanation
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.Rate this question:
-
- 32.
In the example C5, the "C" represents the cell's
- A.
Column
- B.
Row
- C.
Absolute reference
Correct Answer
A. ColumnExplanation
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.Rate this question:
-
- 33.
A row is...
- A.
A vertical range of cells referred to by a number
- B.
A horizontal range of cells referred to by a number
- C.
A vertical range of cells referred to by a letter
Correct Answer
B. A horizontal range of cells referred to by a numberExplanation
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.Rate this question:
-
- 34.
A sheet tab is located at the bottom of the worksheet window and is used to display the...
- A.
Active cell
- B.
Formula bar
- C.
Worksheet name
Correct Answer
C. Worksheet nameExplanation
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.Rate this question:
-
- 35.
This is a built-in formula that enables you to perform common calculations in a workbook
- A.
Function
- B.
Value
- C.
Sort
Correct Answer
A. FunctionExplanation
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.Rate this question:
-
- 36.
All formulas begin with this symbol
- A.
* (asterisk)
- B.
\ (forward slash)
- C.
= (equal sign)
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.Rate this question:
-
- 37.
In the formula =SUM(A10:A15), which part is the cell reference?
- A.
=
- B.
(A10:A15)
- C.
SUM
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.Rate this question:
-
- 38.
What cell reference refers to a range of cells in column D, rows 4 through 9?
- A.
(D4:D9)
- B.
(D4,D9)
- C.
(D4+D9)
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.Rate this question:
-
- 39.
If you enter a formula and #### shows in the cell, what does that mean?
- A.
The formula is missing the math operator
- B.
The column width is not wide enough to display the results
- C.
You entered an invalid cell reference
Correct Answer
B. The column width is not wide enough to display the resultsExplanation
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.Rate this question:
-
- 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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 41.
When entering data across a row, you should use the TAB key to move the cursor to the next cell.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 42.
The only way to view a formula you entered in a cell is to look at the formula bar.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 43.
To easily add a header or footer to your worksheet you should be in page layout view.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 44.
In the cell reference $F9, the column is fixed, but the row will change when copied.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 45.
The shortcut to show formulas in your worksheet is...
- A.
Ctrl + ~
- B.
Ctrl + F5
- C.
Ctrl + $
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.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 -
Nov 06, 2014Quiz Created by
DSakmar
- Academic Quizzes
- Adult Learning Quizzes
- Blended Learning Quizzes
- Coaching Quizzes
- College Quizzes
- Communication Quizzes
- Curriculum Quizzes
- Distance Learning Quizzes
- E Learning Quizzes
- Early Childhood Education Quizzes
- GCSE Quizzes
- Grade Quizzes
- Graduation Quizzes
- Kindergarten Quizzes
- Knowledge Quizzes
- Literacy Quizzes
- Physical Education Quizzes
- Qualification Quizzes
- Religious Education Quizzes
- School Quizzes
- Special Education Quizzes
- Study Quizzes
- Subject Quizzes
- Teaching Quizzes
- Theory Quizzes
- Thesis Quizzes
- University Quizzes
Back to top