Rush Post Excel Assessment Test
Settings
This test is designed to test your basic knowledge of Excel concepts. Please read each question carefully and select the BEST answer. Upon successful completion of the quiz, you will have the option of printing a certificate. This test is not timed. Good Luck.
- 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
Back to top