Food Services Excel Quiz
This quiz was designed by Custom Computer Specialists, Inc. As a followup for Food Services Excel Training. The purpose of this quiz is to see how much information you have retained since Excel Training. You may open Excel to answer the following 10 questions. Take your time and Good Luck!
- 1.What online resource can you use for Excel training videos, help and support?
- A.
Excel.com
- B.
Yahoo Questions and Answers
- C.
Microsoft.com
- D.
Spreadsheet Support
- 2.If a cell displays #######, it means that
- A.
There is a formatting error
- B.
The column is too narrow to dispay all the digits of the number
- C.
There is an error in your formula
- D.
You need to center the text within the cell
- 3.Formulas always start with which symbol?
- A.
(
- B.
$
- C.
#
- D.
=
- 4.The feature that allows you to arrange rows in alphabetical order is
- A.
Sorting
- B.
Conditional Formatting
- C.
Filtering
- D.
Autofill
- 5.The symbol used to multiply in a formula is
- A.
&
- B.
^
- C.
*
- D.
/
- 6.Why might you create a range of cells?
- A.
To begin a formula
- B.
To check spelling
- C.
To type the same information in all of the cells all at one time
- D.
To format, move, copy or delete cells all at one time
- 7.Print Gridlines is found under:
- A.
File > Edit > Page Orientation
- B.
Print Preview > Margins > Print
- C.
Print Preview > Page Setup > Sheet
- D.
Page Layout > Borders and Settings
- 8.A quick way to get to the Home Key (A1) is to
- A.
Press Ctrl + Home
- B.
Press Shift A1
- C.
Use Find and Replace
- D.
Click on File > Home
- 9.What command can fill a selected range of cells with a series of numbers, characters, or dates, months or days of the week?Example: Monday, Tuesday, Wednesday, Thursday, Friday
- A.
Merge and Center
- B.
Fill Series
- C.
Autoformatting
- D.
Dragging and Dropping
- 10.When inserting a column, it will always appear
- A.
To the left of the active cell
- B.
Highlighted
- C.
To the right of the active cell
- D.
As a new A column
Questions: 22 | Attempts: 7481 | Last updated: Mar 22, 2022
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Questions: 10 | Attempts: 4499 | Last updated: Mar 22, 2022
-
Sample QuestionHow do you spell check an Excel worksheet?
Questions: 10 | Attempts: 3584 | Last updated: Mar 22, 2022
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?
Back to top