Microsoft Excel Assessment Test Quiz!
Microsoft Excel is a spreadsheet program developed by Microsoft; it has calculation, graphing tools and pivot tables, and a Visual Basic for Applications macro programming language. It is a reliable, multi-purpose software downloadable tool. If you want to learn more about Microsoft Excel, look no further than this quiz.
- 1.
What is an Excel Workbook?
- A.
A table of data that holds information.
- B.
A Microsoft Office Application file that contains worksheets.
- C.
A file where you can enter practice data.
Correct Answer
B. A Microsoft Office Application file that contains worksheets.Explanation
An Excel Workbook is a Microsoft Office Application file that contains worksheets. It is a file format used by Microsoft Excel to store and organize data. Workbooks can contain multiple worksheets, each of which can hold different sets of data or information. This file format allows users to input, manipulate, and analyze data using various formulas, functions, and formatting options provided by the Excel software.Rate this question:
-
- 2.
A range in Excel refers to:
- A.
A group of tabs.
- B.
A group of cells.
- C.
A way of arranging a series of data.
Correct Answer
B. A group of cells.Explanation
A range in Excel refers to a group of cells. In Excel, a range allows you to select and manipulate multiple cells at once. This is useful for performing calculations, applying formatting, or entering data in a specific area of a worksheet. By selecting a range, you can easily perform actions such as copying and pasting data, applying formulas or functions, and formatting cells uniformly. A range can be defined by selecting a starting cell and an ending cell, and it can be a single row, column, or a combination of both.Rate this question:
-
- 3.
Double-clicking between two column headings will auto-size the column to the widest width.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Double-clicking between two column headings in a spreadsheet program will automatically adjust the width of the column to fit the widest content within that column. This feature is useful when working with large amounts of data and wanting to ensure that all the content in a column is visible without having to manually adjust the width.Rate this question:
-
- 4.
You can insert a row or column by right-clicking on the row number or column letter and selecting Insert.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
To insert a row or column in a spreadsheet, you can right-click on the row number or column letter and select the "Insert" option. This action will add a new row or column to the spreadsheet at the desired location. Therefore, the statement "You can insert a row or column by right-clicking on the row number or column letter and selecting Insert" is true.Rate this question:
-
- 5.
You can select multiple non-adjacent cells by holding the __________________ button and selecting the cells.
- A.
Alt
- B.
Shift
- C.
Ctrl
- D.
Enter
Correct Answer
C. CtrlExplanation
To select multiple non-adjacent cells, you need to hold down the Ctrl button on your keyboard while selecting the desired cells. Ctrl allows you to make multiple selections without deselecting the previous ones. Holding down Alt or Shift does not have the same effect, and pressing Enter is used to confirm a cell entry. Therefore, the correct button to hold is Ctrl.Rate this question:
-
- 6.
How can you open a spreadsheet?
- A.
Click File then Open
- B.
Click Ctrl + O
- C.
Click the Open Folder Icon on the Standard Toolbar
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
All of the options provided are correct ways to open a spreadsheet. You can open a spreadsheet by clicking on the "File" tab and selecting "Open", using the keyboard shortcut "Ctrl + O", or by clicking on the Open Folder Icon on the Standard Toolbar.Rate this question:
-
- 7.
All formulas in Excel begin with:
- A.
A plus (+) sign
- B.
Parenthesis ( )
- C.
A minus (-) sign
- D.
An equal sign (=)
- E.
None of the above
Correct Answer
D. An equal sign (=)Explanation
In Excel, all formulas must begin with an equal sign (=). This is because the equal sign tells Excel that the following characters are part of a formula and not just regular text. By using the equal sign, Excel knows to interpret the characters that follow as a calculation or function to be performed. Therefore, the correct answer is an equal sign (=).Rate this question:
-
- 8.
The Auto-Fill Handle can be used to:
- A.
Copy formulas.
- B.
Copy text.
- C.
Fill in a series of numbers or dates.
- D.
None of the Above
- E.
All of the Above
Correct Answer
E. All of the AboveExplanation
The Auto-Fill Handle in Excel can be used to perform all the mentioned tasks. It allows users to copy formulas by dragging the handle across cells, copy text by dragging the handle, and fill in a series of numbers or dates by dragging the handle. Therefore, the correct answer is "All of the Above."Rate this question:
-
- 9.
Please select the correct answer to the following question. The name box can be used to:
- A.
Navigate to a specific cell with in the workbook
- B.
Indicate to the user the active cell
- C.
Navigate to a specific cell within the worksheet
- D.
Name a cell or range of cells
- E.
All of the Above
Correct Answer
E. All of the AboveExplanation
The name box in Excel can be used for multiple purposes. It can be used to navigate to a specific cell within the workbook or within the worksheet. It can also indicate to the user the active cell. Additionally, the name box can be used to name a cell or range of cells. Therefore, the correct answer is "All of the Above".Rate this question:
-
- 10.
Which function is used to add up a range of cells?
- A.
Add
- B.
Sum
- C.
Plus
Correct Answer
B. SumExplanation
The correct answer is "Sum". The Sum function is used to add up a range of cells in Excel. It allows you to easily calculate the total of a selected range of cells by simply typing "=SUM(" followed by the range of cells you want to add. This function is commonly used in financial calculations, data analysis, and creating reports.Rate this question:
-
- 11.
The following icon is used to change the font color of text.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is false. The icon mentioned is not used to change the font color of text.Rate this question:
-
- 12.
A cell address is identified using a row and column label.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A cell address in a spreadsheet is indeed identified using a row and column label. Each cell in a spreadsheet is assigned a unique address based on its position, with the row number indicating the vertical position and the column letter indicating the horizontal position. This allows users to easily reference and locate specific cells within a spreadsheet by using the corresponding row and column labels. Therefore, the statement that a cell address is identified using a row and column label is true.Rate this question:
-
- 13.
The following icon is used to paste data into a spreadsheet.
- A.
True
- B.
False
Correct Answer
B. False -
- 14.
The shift button in conjunction with the mouse can be used to select a range of non-adjacent cells.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because the shift button in conjunction with the mouse cannot be used to select a range of non-adjacent cells. The shift button is used to select a range of adjacent cells, while the Ctrl button is used to select non-adjacent cells.Rate this question:
-
- 15.
You can attach a file to an e-mail by opening Lotus Notes, creating a new mail message, clicking the open folder, browse to find the file to attach, click the open button.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true. In Lotus Notes, to attach a file to an email, you need to open Lotus Notes, create a new mail message, click on the open folder icon, browse to find the file you want to attach, and then click the open button to attach the file to the email.Rate this question:
-
- 16.
How can you save a new or existing workbook?
- A.
Ctrl+S
- B.
File Save
- C.
File Save As
- D.
F12
- E.
All of the above
Correct Answer
E. All of the aboveExplanation
All of the options listed are valid ways to save a new or existing workbook. Ctrl+S is a keyboard shortcut that can be used to quickly save the workbook. "File Save" and "File Save As" are options available in the File menu that allow you to save the workbook with its current name or with a new name, respectively. F12 is another keyboard shortcut that can be used to save the workbook. Therefore, all of the options mentioned are correct ways to save a workbook.Rate this question:
-
- 17.
You must always edit cell data from the formula bar.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Editing cell data can be done from both the formula bar and directly in the cell itself. Therefore, the statement that you must always edit cell data from the formula bar is false.Rate this question:
-
- 18.
You can use the left and right arrows or the tab and shift+tab buttons to navigate left or right in the spreadsheet.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true. It is stating that in a spreadsheet, one can use the left and right arrows or the tab and shift+tab buttons to navigate left or right. This means that users can easily move between cells or columns in a spreadsheet by using these keyboard shortcuts.Rate this question:
-
- 19.
The is used to sort text data from A to Z and Numbers from the highest to the lowest.
- A.
True
- B.
False
Correct Answer
B. False -
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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 14, 2009Quiz Created by
Lacent03
Back to top