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.
- 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.
- 3.Double-clicking between two column headings will auto-size the column to the widest width.
- A.
True
- B.
False
- 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
- 5.You can select multiple non-adjacent cells by holding the __________________ button and selecting the cells.
- A.
Alt
- B.
Shift
- C.
Ctrl
- D.
Enter
- 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
- 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
- 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
- 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
- 10.Which function is used to add up a range of cells?
- A.
Add
- B.
Sum
- C.
Plus
- 11.
![The following icon is used to change the font color of text. - ProProfs]( "The following icon is used to change the font color of text.")
The following icon is used to change the font color of text.- A.
True
- B.
False
- 12.A cell address is identified using a row and column label.
- A.
True
- B.
False
- 13.
![The following icon is used to paste data into a spreadsheet. - ProProfs]( "The following icon is used to paste data into a spreadsheet.")
The following icon is used to paste data into a spreadsheet.- A.
True
- 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
- 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
- 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
- 17.You must always edit cell data from the formula bar.
- A.
True
- B.
False
- 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
- 19.
![The is used to sort text data from A to Z and Numbers from the highest to the lowest. - ProProfs]( "The is used to sort text data from A to Z and Numbers from the highest to the lowest.")
The is used to sort text data from A to Z and Numbers from the highest to the lowest.- A.
True
- B.
False
Questions: 10 | Attempts: 62207 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Questions: 10 | Attempts: 59827 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Questions: 10 | Attempts: 44527 | Last updated: Feb 12, 2021
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top