Assessment For MS® Office Excel 2010
Take this assessment to determine which level of Excel training you will need to attend.
There is no pass or fail.
Do not navigate away from the test or the test will become invalid.
The assessment consists of 20 questions. Select the most correct answer of the available options.
- 1.
Which is NOT a basic element of a spreadsheet?
- A.
A) Cell
- B.
B) Row
- C.
C) Paragraph
- D.
D) Column
Correct Answer
C. C) ParagraphExplanation
A paragraph is not a basic element of a spreadsheet. In a spreadsheet, data is organized into cells, which are arranged in rows and columns. Each cell can contain a single value or formula. Rows and columns are used to organize and manipulate data in the spreadsheet. However, a paragraph is a unit of text in a document or a piece of writing, and it is not a fundamental component of a spreadsheet.Rate this question:
-
- 2.
To move one cell down from the active cell, you can:
- A.
A) Press Enter
- B.
B) Press Page Down
- C.
C) Click the upward scroll arrow
- D.
D) Press Page Up
Correct Answer
A. A) Press EnterExplanation
To move one cell down from the active cell, you can press Enter. This is because pressing Enter moves the cursor to the cell directly below the active cell in most spreadsheet programs. Pressing Page Down, on the other hand, typically scrolls the screen down, rather than moving to the cell below. Clicking the upward scroll arrow would also not move the active cell down. Pressing Page Up would move the active cell up, not down.Rate this question:
-
- 3.
A formatted number that doesn't fit in a cell looks like:
- A.
A) #####
- B.
B) #DIV
- C.
C) Error
- D.
D) #VALUE
Correct Answer
A. A) #####Explanation
When a number is too large to fit within a cell, it is displayed as "#####". This is a formatting issue and occurs when the width of the cell is not wide enough to display the entire number. The "#####" symbol is used to indicate that the number is not visible in the cell. To resolve this, the cell width can be adjusted to accommodate the entire number.Rate this question:
-
- 4.
To save an existing workbook with a new name, choose:
- A.
A) File tab-->Info
- B.
B) File tab-->Save
- C.
C) File tab-->Save As
- D.
D) Home tab-->Editing group-->File Name
Correct Answer
C. C) File tab-->Save AsExplanation
To save an existing workbook with a new name, you need to choose the "File" tab and then select the "Save As" option. This allows you to create a copy of the workbook with a different name, while keeping the original file intact. The "Save As" option is commonly used when you want to create a duplicate of a workbook or save it with a different name for organizational purposes or to create different versions of the same file.Rate this question:
-
- 5.
To open the Excel help system, choose
- A.
A) Insert tab-->Help group
- B.
B) Help tab-->Microsoft Excel Help
- C.
C) File tab-->Help
- D.
D) None of the above
Correct Answer
C. C) File tab-->HelpExplanation
The correct answer is c) File tab-->Help. This is the correct option because in Excel, the Help system can be accessed by clicking on the File tab, which is located in the top left corner of the Excel window. Once the File tab is clicked, a menu will appear on the left side of the screen, and the Help option can be found within this menu. By selecting the Help option, the Excel Help system will open, providing assistance and information on various topics related to Excel.Rate this question:
-
- 6.
Whether you want to cut, copy, or move data, what's the first thing you must do?
- A.
A) Choose Data tab -->Edit-->Cut
- B.
B) Select the contents of the cell that contains the data
- C.
C) Click the destination cell
- D.
D) Open the clipboard
Correct Answer
B. B) Select the contents of the cell that contains the dataExplanation
To perform any operation like cutting, copying, or moving data, the first step is to select the contents of the cell that contains the data. This is necessary because the selected data is what will be affected by the operation. Only after the data is selected can you proceed with the desired action such as cutting, copying, or moving it to another location.Rate this question:
-
- 7.
Data can be arranged in ascending or descending order by using:
- A.
A) Conditional Formatting
- B.
B) Cell Styles
- C.
C) Sort feature
- D.
D) Text to Columns wizard
Correct Answer
C. C) Sort featureExplanation
The correct answer is c) Sort feature. The sort feature allows data to be arranged in ascending or descending order. This feature is commonly found in spreadsheet programs and databases, and it allows users to easily organize and analyze their data. By selecting the sort feature, users can choose which column or columns to sort by, as well as the order (ascending or descending). This feature is useful for tasks such as alphabetizing names, organizing numerical data, or sorting dates in chronological order.Rate this question:
-
- 8.
Which option do you use if you want to restore something you accidentally deleted?
- A.
A) Redo
- B.
B) Undo
- C.
C) Replace
- D.
D) Edit
Correct Answer
B. B) UndoExplanation
The option "Undo" is used to restore something that was accidentally deleted. It allows the user to reverse the last action or series of actions, effectively bringing back the deleted item or returning to a previous state. This feature is commonly found in various software applications and provides a way to fix mistakes or recover lost data.Rate this question:
-
- 9.
To insert a new row:
- A.
A) Double-click on the row
- B.
B) From the Insert tab -->Choose Line
- C.
C) Select where you want the row and then from the Home tab -->Choose Insert-->Insert Cells
- D.
D) From the Home tab in the Cells group -->Choose Insert-->Insert Sheet Rows
Correct Answer
D. D) From the Home tab in the Cells group -->Choose Insert-->Insert Sheet RowsExplanation
The correct answer is d) From the Home tab in the Cells group -->Choose Insert-->Insert Sheet Rows. This option is the most appropriate for inserting a new row in a spreadsheet. The Home tab is where the basic formatting and editing options are located, and the Cells group specifically deals with operations related to cells. Choosing "Insert Sheet Rows" ensures that a new row is inserted into the spreadsheet, rather than just inserting a line or inserting cells.Rate this question:
-
- 10.
Which description best describes a function in Excel?
- A.
A) A cell's coordinates
- B.
B) The same thing as a cell name
- C.
C) A built-in formula
- D.
D) The result of a formula
Correct Answer
C. C) A built-in formulaExplanation
A function in Excel refers to a built-in formula that performs a specific calculation or task. It is a predefined formula that can be used to manipulate data or perform calculations on a range of cells. Functions in Excel are designed to simplify complex calculations and can be accessed through the formula bar or by using the function wizard. They can be used to perform tasks such as summing numbers, finding averages, counting cells, and more.Rate this question:
-
- 11.
You have selected cell D12 and, in that cell, you want to create an absolute reference to cell A9. Which one is an absolute reference to cell A9?
- A.
A) $A9
- B.
B) A$9
- C.
C) $A$9
- D.
D) A9
Correct Answer
C. C) $A$9Explanation
An absolute reference is used when you want a cell reference to remain constant, regardless of where the formula is copied or moved. In this case, the correct absolute reference to cell A9 is $A$9. The dollar sign ($) before the column and row reference ensures that the reference does not change when the formula is copied or moved to another cell.Rate this question:
-
- 12.
What symbol or phrase is used when concatenating data (joining two character strings together)?
- A.
A) AND
- B.
B) &
- C.
C) #
- D.
D) !
Correct Answer
B. B) &Explanation
The symbol "&" is used when concatenating data or joining two character strings together. This symbol is commonly used in programming languages and represents the logical operator for "AND". In the context of concatenation, it is used to combine two or more strings into a single string. For example, if we have two strings "Hello" and "World", using the "&" symbol we can concatenate them as "Hello" & "World" which would result in "HelloWorld".Rate this question:
-
- 13.
PivotTable reports allow you to:
- A.
A) Organize large amounts of data
- B.
B) Create PivotCharts that show a graphical representation of large amounts of data
- C.
C) Easily change the layout of the report
- D.
D) All of the above
Correct Answer
D. D) All of the aboveExplanation
PivotTable reports allow you to organize large amounts of data, create PivotCharts that show a graphical representation of large amounts of data, and easily change the layout of the report. By selecting "All of the above" as the correct answer, it implies that PivotTable reports offer all of these functionalities.Rate this question:
-
- 14.
Apply an AutoFormat when you want to:
- A.
A) Quickly format a range of cells with a predefined group of formats.
- B.
B) Specify a custom-designed layout for a range of cells.
- C.
C) Quickly format a single cell.
- D.
D) Alter the formula in a cell.
Correct Answer
A. A) Quickly format a range of cells with a predefined group of formats.Explanation
Applying an AutoFormat allows you to quickly format a range of cells with a predefined group of formats. This means that instead of manually applying individual formatting options to each cell, you can simply select the range and apply the AutoFormat to automatically apply a set of predefined formatting styles to the cells. This saves time and effort when formatting a large number of cells with consistent formatting.Rate this question:
-
- 15.
Which one can be the first step for renaming a worksheet tab?
- A.
A) Select the worksheet, and then from the Page Layout tab-->Select Arrange
- B.
B) Double-click the worksheet tab
- C.
C) From the Home tab-->Enter new name in the Name box
- D.
D) All of the above
Correct Answer
B. B) Double-click the worksheet tabExplanation
To rename a worksheet tab, the first step is to double-click on the worksheet tab. This action allows the user to directly edit the name of the tab and replace it with a new name. This is a simple and quick method to rename a worksheet tab without the need to navigate through different tabs or menus.Rate this question:
-
- 16.
To add a header or footer to a worksheet, choose:
- A.
A) From the View tab-->Workbook Views group-->Select Page Layout-->Enter the headers in the worksheet
- B.
B) From the Insert tab in the Text group-->Select Header & Footer
- C.
C) From the Page Layout tab in the Page Setup group-->Select Print Titles-->Select Header and Footer tab
- D.
D) All of the above
Correct Answer
D. D) All of the aboveExplanation
To add a header or footer to a worksheet, you can choose any of the options mentioned. From the View tab, you can select Page Layout and then enter the headers in the worksheet. From the Insert tab, you can select Header & Footer in the Text group. Alternatively, from the Page Layout tab, you can select Print Titles and then go to the Header and Footer tab. All of these options allow you to add a header or footer to the worksheet.Rate this question:
-
- 17.
How do you select multiple cells that are not adjacent to each other?
- A.
A) CTRL key
- B.
B) Selecting each cell while holding down the CTRL key
- C.
C) The ALT key
- D.
D) None of the above
Correct Answer
B. B) Selecting each cell while holding down the CTRL keyExplanation
To select multiple cells that are not adjacent to each other, you can use the CTRL key. By holding down the CTRL key, you can individually select each cell that you want to include in the selection. This allows you to choose non-adjacent cells and create a multiple cell selection. The ALT key and selecting cells without any key modifier (option d) are not the correct methods for selecting non-adjacent cells.Rate this question:
-
- 18.
To print a range of cells, you must first:
- A.
A) Choose File tab-->Print
- B.
B) From the Page Layout tab-->Page Setup group-->Select Range
- C.
C) Select the range of cells
- D.
D) Select a single cell
Correct Answer
C. C) Select the range of cellsExplanation
To print a range of cells, you must first select the range of cells that you want to print. This can be done by clicking and dragging the mouse cursor over the desired cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell in the range. Once the range of cells is selected, you can proceed with the printing process.Rate this question:
-
- 19.
Which tab choice do you use to split a worksheet?
- A.
A) From the Data tab-->Data Tools group-->Split
- B.
B) From the View tab-->Workbook Views group-->Custom Split View
- C.
C) From the View tab-->Windows group-->Split
- D.
D) From the Insert tab-->Hyperlink group-->Split
Correct Answer
C. C) From the View tab-->Windows group-->SplitExplanation
To split a worksheet, you would use the option from the View tab, specifically the Windows group, and select the Split option. This will allow you to divide the worksheet into multiple panes, allowing you to view different parts of the worksheet simultaneously.Rate this question:
-
- 20.
To freeze rows and columns, choose:
- A.
A) From the View tab-->Windows group-->Freeze Panes
- B.
B) From the Data tab-->Data Tools group-->Remove Duplicates
- C.
C) From the View tab-->Workbook Views Group-->Full Screen
- D.
D) From the Insert Tab-->Sparklines group--> Line
Correct Answer
A. A) From the View tab-->Windows group-->Freeze PanesExplanation
To freeze rows and columns in Excel, you need to go to the View tab. Then, in the Windows group, you will find the option to Freeze Panes. This feature allows you to lock specific rows and columns so that they remain visible while scrolling through a large spreadsheet. By selecting this option, you can easily keep important information in view even when navigating through different parts of the worksheet.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 -
Oct 21, 2014Quiz Created by
Tlafferty
Back to top