Keystone Bank Pre-training Assessment
-
Data can be arranged in ascending or descending order by using?
-
Sort command
-
Data Validation command
-
Filter command
-
None of these
-
This assessment tests proficiency in Excel functionalities like sorting, using gridlines, worksheet operations, freeze panes, and functions.
Quiz Preview
- 2.
Gridlines
-
May be turned off for display but turned on for printing
-
May be turned on or off for printing
-
May be turned off for printing
-
All of the above
Correct Answer
A. All of the aboveExplanation
Gridlines are horizontal and vertical lines that appear on a spreadsheet or graph to help organize and align data. They can be turned off for display on a screen to make the data easier to read, but turned on for printing to ensure that the printed copy includes the gridlines. Additionally, gridlines can be turned on or off specifically for printing purposes, depending on the user's preference. Therefore, all of the given options are correct explanations for the behavior of gridlines.Rate this question:
-
- 3.
In a worksheet, you can select?
-
The entire worksheet
-
Rows
-
Columns
-
All of the above
Correct Answer
A. All of the aboveExplanation
In a worksheet, you can select the entire worksheet, rows, and columns. This means that you have the option to select all the cells in the worksheet, specific rows, or specific columns. This allows you to manipulate and work with the data in a way that suits your needs, whether it's applying formatting, entering formulas, or performing calculations. By being able to select all of these options, you have greater flexibility and control over your worksheet.Rate this question:
-
- 4.
To hold rows and columns in place so that they do not scroll when you scroll across a worksheet click the
-
Unfreeze panes command on the window menu
-
Freeze panes command on the window menu
-
Hold titles command on the edit menu
-
Split command on the window menu
Correct Answer
A. Freeze panes command on the window menuExplanation
To hold rows and columns in place so that they do not scroll when you scroll across a worksheet, you need to use the Freeze panes command on the window menu. This command allows you to freeze specific rows and columns, keeping them visible while the rest of the worksheet scrolls. This is useful when you have headers or labels that you want to remain visible at all times, even when you are working with a large amount of data.Rate this question:
-
- 5.
Which of following is Not one of Excel’s what-if function
-
Goal seek
-
Solver
-
Scenario manager
-
Auto Outline
Correct Answer
A. Auto OutlineExplanation
The correct answer is Auto Outline. Auto Outline is not one of Excel's what-if functions. Goal seek, Solver, and Scenario Manager are all what-if functions in Excel that allow users to analyze different scenarios and find solutions to problems by changing input values. Auto Outline, on the other hand, is a feature in Excel that automatically creates an outline based on the structure of the data in a worksheet. It helps in organizing and summarizing data, but it is not specifically a what-if function.Rate this question:
-
- 6.
What does the LEN() function do?
-
Deleting trailing spaces
-
Split the cell contents
-
Count the number of characters in a cell
-
All of the above
Correct Answer
A. Count the number of characters in a cellExplanation
The LEN() function is used to count the number of characters in a cell. It does not delete trailing spaces or split the cell contents. Therefore, the correct answer is "Count the number of characters in a cell."Rate this question:
-
- 7.
The autofill feature
-
Extends a sequential series of data
-
Automatically adds range of cell values
-
Applies a boarder around the selected cells
-
None of the above
Correct Answer
A. Extends a sequential series of dataExplanation
The autofill feature in Excel allows users to easily extend a sequential series of data by automatically filling in the subsequent cells with the appropriate values. This saves time and effort by eliminating the need to manually enter each value in the series.Rate this question:
-
- 8.
How do you take out repeated values from data in a column?
-
Locate and Delete the repeated values
-
Sort the column and delete the repeated values
-
Highlight the repeated value and use the Filter function
-
Highlight the repeated value and use Remove Duplicate function
Correct Answer
A. Highlight the repeated value and use Remove Duplicate functionExplanation
To take out repeated values from data in a column, one can highlight the repeated value and use the Remove Duplicate function. This function will identify and remove any duplicate values in the column, leaving only unique values. This is a simple and efficient way to clean up data and ensure that each value in the column is unique.Rate this question:
-
- 9.
Multiple calculations can be made in a single formula using the
-
Standard formulas
-
Array formula
-
complex formulas
-
Smart formula
Correct Answer
A. Array formulaExplanation
An array formula allows multiple calculations to be performed in a single formula. It is a special type of formula that can operate on arrays of data rather than just individual cells. This means that it can perform calculations on a range of cells and return multiple results. Array formulas are useful when you need to perform calculations across multiple cells or when you want to summarize data in a single formula. They are typically entered by pressing Ctrl+Shift+Enter instead of just Enter, and they are enclosed in curly braces {} to indicate that they are an array formula.Rate this question:
-
- 10.
Chart tips can
-
Show the formatting of a data label
-
Show the name of a data series
-
Show the value of a data point
-
B&C
Correct Answer
A. B&CExplanation
The correct answer is B&C. This means that the chart tips can show both the name of a data series and the value of a data point. This can be helpful in understanding and interpreting the data displayed in the chart. By showing the name of a data series, it allows the viewer to identify which data set the chart is representing. Additionally, by showing the value of a data point, it provides specific numerical information about each data point, allowing for more precise analysis and comparison.Rate this question:
-
- 11.
To create a formula, you can use
-
Values but not cell references
-
Cell references but not values
-
. Values or cell references although not both at the same time
-
Value and cell references
Correct Answer
A. Value and cell referencesExplanation
A formula can be created using both values and cell references. This means that you can include specific values in the formula as well as refer to the values stored in other cells. By combining values and cell references, you can perform calculations or manipulate data based on the information in different cells.Rate this question:
-
- 12.
A function inside another function is called a ….. function.?
-
Nested
-
Round
-
Sum
-
Text
Correct Answer
A. NestedExplanation
A function inside another function is called a nested function because it is enclosed or "nested" within the outer function. This allows the nested function to access variables and parameters from the outer function, creating a hierarchical structure.Rate this question:
-
- 13.
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
-
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
-
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
-
=VLOOKUP(lookup_value, table_array, col_index_num, value)
-
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Correct Answer
A. =VLOOKUP(lookup_value, table_array, col_index_num, value) -
- 14.
Name Range in excel can be created?
-
By entering a range name in the name box
-
By clicking a Formula/Define Names group/Create from selection
-
By clicking Formulas tab/Define Names grup/Name manager or define name
-
All of the above
Correct Answer
A. By clicking a Formula/Define Names group/Create from selectionExplanation
In Excel, a name range can be created by clicking on the Formula/Define Names group and selecting "Create from selection". This option allows users to create a named range based on the selected cells in the worksheet.Rate this question:
-
- 15.
Can you create a copy of a worksheet in a different workbook without copying and pasting?
-
Yes
-
No
Correct Answer
A. YesExplanation
It is possible to create a copy of a worksheet in a different workbook without copying and pasting by using the "Move or Copy" feature in Excel. This feature allows users to select the destination workbook and choose whether to create a copy or move the worksheet. By selecting the option to create a copy, a duplicate of the worksheet is created in the different workbook without the need for copying and pasting the content manually.Rate this question:
-
- 16.
The function MID(ADENIYI,4,2) returns ?
-
NI
-
ADE
-
NEY
-
IYI
Correct Answer
A. NIExplanation
The function MID(ADENIYI,4,2) returns the characters starting from the 4th position in the string "ADENIYI" and includes the next 2 characters. In this case, it returns "NI" as the 4th and 5th characters in the string are "NI".Rate this question:
-
- 17.
Rounding errors can occur
-
When you use multiplication, division, or exponentiation in a formula
-
When you use addition and subtraction in a formula
-
Because excel uses hidden decimal places in computation
-
When you show the results of formulas with different decimal places than the calculated results
Correct Answer
A. When you use multiplication, division, or exponentiation in a formulaExplanation
Rounding errors can occur when you use multiplication, division, or exponentiation in a formula. This is because Excel uses hidden decimal places in computation, which can lead to slight discrepancies in the final result.Rate this question:
-
- 18.
Which of these represent the correct argument for the SumIF
-
SUMIF(criteria, range, criteria_range)
-
SUMIF(criteria_range, true, false)
-
SUMIF(range, criteria, [sum_range])
-
SUMIF(range, sum_range, [criteria])
Correct Answer
A. SUMIF(criteria_range, true, false) -
- 19.
What type of result does the MATCH function, when used on its own, return?
-
It returns the lookup value located in a specific location
-
It returns a value that is the same as the lookup value
-
It returns the cell reference of the lookup value
-
It returns the relative position of a lookup value, either as a row or column number, within the selected array
Correct Answer
A. It returns the relative position of a lookup value, either as a row or column number, within the selected arrayExplanation
The MATCH function, when used on its own, returns the relative position of a lookup value, either as a row or column number, within the selected array.Rate this question:
-
- 20.
When you copy a formula?
-
Excel erases the original copy of the formula
-
Excel edits cell references in the newly copied formula
-
Excel adjusts absolute cell references
-
Excel doesn’t adjust relative cell references
Correct Answer
A. Excel edits cell references in the newly copied formulaExplanation
When you copy a formula in Excel, the program automatically adjusts the cell references in the newly copied formula. This means that if the original formula referred to cells A1 and B1, for example, and you copy the formula to a different location, Excel will automatically update the formula to refer to the corresponding cells in the new location, such as A2 and B2. This feature is useful for quickly applying the same formula to multiple cells without having to manually update the cell references.Rate this question:
-
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 27, 2017Quiz Created by
Ojeaga
Back to top