Rsa Excel Training Exam
Questions and Answers
- 1.
An easy way to sort data when there is only one sort field is to use the Sort A to Sort Z or Sort Z to A buttons
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Using the Sort A to Sort Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow you to quickly arrange the data in ascending (A to Z) or descending (Z to A) order based on the selected field. This eliminates the need for manual sorting or creating complex sorting algorithms, making it a convenient option for simple sorting tasks.Rate this question:
-
- 2.
In an IF Function the required arguments are ______________________.
- A.
Logical test and value if true, value if test is false plus formatting option
- B.
The logical test and the three possible outcomes
- C.
The Logical test plus initial outcome pus true and false
- D.
The Logical test and value if test is true, value if test is false
Correct Answer
A. Logical test and value if true, value if test is false plus formatting optionExplanation
The correct answer is "Logical test and value if true, value if test is false plus formatting option". In an IF function, the required arguments include the logical test, which determines if a certain condition is met, and the value if true, which specifies the result if the condition is true. Additionally, the value if false is needed to specify the result if the condition is false. The formatting option is an optional argument that allows you to format the result of the IF function.Rate this question:
-
- 3.
You can create maximum one Excel table in a worksheet
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
In Excel, you can create multiple tables in a single worksheet. Tables are a way to organize and analyze data in Excel, and they provide additional functionality like sorting, filtering, and formatting. By creating multiple tables, you can separate different sets of data and apply different table styles and settings to each of them. Therefore, the statement that you can only create one Excel table in a worksheet is false.Rate this question:
-
- 4.
You cannot insert comments on each cell
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given answer is false because it states that "You cannot insert comments on each cell." This statement is incorrect because in most spreadsheet software, such as Microsoft Excel or Google Sheets, you can insert comments on each cell. Comments are a way to add additional information or notes to a cell without affecting the actual data in the cell.Rate this question:
-
- 5.
Pressing ENTER moves the selection one cell to the right by default.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Pressing ENTER moves the selection one cell down by default, not one cell to the right.Rate this question:
-
- 6.
_______________ is the horizontal part of the spreadsheet.
- A.
Rows
- B.
Cell
- C.
Column
Correct Answer
A. RowsExplanation
Rows are the horizontal part of a spreadsheet. They are represented by numbers and are used to organize and categorize data horizontally. Each row contains cells where data can be entered or displayed. Columns, on the other hand, are the vertical part of a spreadsheet. They are represented by letters and are used to organize and categorize data vertically.Rate this question:
-
- 7.
As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When you start typing a function name within a formula in a cell, a list of functions that begin with the letters you typed will appear. This feature is called "AutoComplete" and it helps users by suggesting possible function names based on what they have already typed, making it easier to select the desired function without having to remember the exact name or syntax.Rate this question:
-
- 8.
You can print
- A.
An entire workbook
- B.
A single worksheet
- C.
A range of cells by range
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
The correct answer is "All of the above" because in Excel, you have the option to print an entire workbook, a single worksheet, or a range of cells. This means that you can choose to print the entire workbook, which includes all the worksheets within it. Alternatively, you can select a specific worksheet to print, or even choose a specific range of cells within a worksheet to print. Therefore, all the given options are valid choices for printing in Excel.Rate this question:
-
- 9.
What term describes explanatory text attached to a cell
- A.
Callouts
- B.
Comments
- C.
Dialogs
- D.
Extensions
Correct Answer
B. CommentsExplanation
Comments are explanatory text attached to a cell in a spreadsheet or document. They provide additional information or context about the content of the cell. Users can add comments to cells to provide explanations, instructions, or feedback to others who may be viewing or editing the document. Comments are typically displayed as small bubbles or boxes that can be viewed by hovering over or clicking on the cell. They are a useful tool for collaboration and communication within a document.Rate this question:
-
- 10.
The Insert Function dialog box tells you how to use functions.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The Insert Function dialog box provides information and guidance on how to use functions in a specific software or program. It helps users understand the purpose and usage of different functions and assists in their implementation. Therefore, the statement "The Insert Function dialog box tells you how to use functions" is correct.Rate this question:
-
- 11.
In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?
- A.
Formula returns the value "DONE"
- B.
Formula will show an error
- C.
Formula returns the value "RESTART"
- D.
Formula returns the value "YES"
Correct Answer
C. Formula returns the value "RESTART"Explanation
The given formula is an IF statement that checks the value of cell A1. If the value is "YES", it returns "DONE". If the value is anything other than "YES", it returns "RESTART". Therefore, if A1 is "NO", the formula will return the value "RESTART".Rate this question:
-
- 12.
Two common wildcard characters that Excel recognizes are
- A.
* and /
- B.
- and /
- C.
* and ?
- D.
+ and -
Correct Answer
C. * and ?Explanation
The correct answer is * and ?. In Excel, the * wildcard character represents any sequence of characters, while the ? wildcard character represents any single character. These wildcard characters are commonly used in Excel functions such as SUMIF, COUNTIF, and VLOOKUP to perform pattern matching and search for specific values or patterns within a range of cells.Rate this question:
-
- 13.
The cell labeled F5 refers to
- A.
Row F column 5
- B.
Column F row 5
- C.
Functions available in cells
- D.
Function key F4
Correct Answer
B. Column F row 5Explanation
The cell labeled F5 refers to the intersection of column F and row 5. In a spreadsheet, cells are identified by their column letter and row number, so F5 represents the cell that is in the 5th row of column F.Rate this question:
-
- 14.
The name of the active cell appears in the ____________.
- A.
Formula Bar
- B.
Name box
- C.
Column
- D.
View Tab
Correct Answer
B. Name boxExplanation
The name of the active cell appears in the Name box. This box displays the cell reference or name of the selected cell, making it easy to identify which cell is currently active. The Formula Bar, on the other hand, displays the contents of the active cell, such as a formula or value. The Column and View Tab options are not relevant to displaying the name of the active cell.Rate this question:
-
- 15.
When a worksheet is printed, the grid lines that surround the cells are printable by default.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because when a worksheet is printed, the grid lines that surround the cells are not printable by default. However, users have the option to include or exclude the grid lines when printing the worksheet.Rate this question:
-
- 16.
To select several cells or ranges that are not touching each other, you would _____ while selecting
- A.
Hold down the CTRL key
- B.
Hold down the SHIFT key
- C.
Hold down the ALT key
Correct Answer
A. Hold down the CTRL keyExplanation
To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. This is because holding down the CTRL key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. By doing so, you can choose multiple cells or ranges that are not adjacent to each other and perform operations on them simultaneously.Rate this question:
-
- 17.
You can select the current Row by pressing
- A.
Control + spacebar
- B.
Shift + spacebar
- C.
Alt + spacebar
- D.
Shift + Tab
Correct Answer
B. Shift + spacebarExplanation
Pressing Shift + spacebar allows you to select the current row. This combination of keys is commonly used in spreadsheet software or text editors to highlight or select the entire row where the cursor is located. It is a convenient way to quickly select and manipulate data in a tabular format.Rate this question:
-
- 18.
Pressing TAB moves the selection one cell to the right by default.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Pressing the TAB key on a keyboard is a common way to navigate between cells in a spreadsheet or table. By default, when the TAB key is pressed, the selection moves one cell to the right. This is a standard behavior in many software applications and is designed to make data entry and navigation more efficient. Therefore, the given answer that pressing TAB moves the selection one cell to the right is correct.Rate this question:
-
- 19.
The _________________ displays the name of the sheets in the workbook.
- A.
Sheet Tabs
- B.
Book Tabs
- C.
Menu Bar
Correct Answer
A. Sheet TabsExplanation
The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook. The sheet tabs are typically located at the bottom of the workbook window and are clickable, allowing users to select a specific sheet by clicking on its corresponding tab. This feature is especially useful in workbooks with multiple sheets, as it provides a quick and convenient way to switch between them.Rate this question:
-
- 20.
Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?
- A.
=ADD(J1-J8)
- B.
=SUM(J1:J8)
- C.
=J:1+J:8
- D.
=SUM J:1-8
Correct Answer
B. =SUM(J1:J8)Explanation
The correct answer is "=SUM(J1:J8)". This formula uses the SUM function in Excel to calculate the sum of the cells in column J between rows 1 and 8. The range is specified using the syntax J1:J8, which includes all the cells in column J from row 1 to row 8.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
-
Feb 28, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 28, 2014Quiz Created by
Richetec_IT
Back to top