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
Correct Answer
C. Microsoft.comExplanation
You can find training videos, printable materials, as well as help and support at microsoft.com for all microsoft products. You may also use ccsexcel2003.wikispaces.com, google.com and youtube.com as additional resources.Rate this question:
-
- 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
Correct Answer
B. The column is too narrow to dispay all the digits of the numberExplanation
Excel will never cut off numbers - it will display ###### to indicate to you that the column is not wide enough.Rate this question:
-
- 3.
Formulas always start with which symbol?
- A.
(
- B.
$
- C.
#
- D.
=
Correct Answer
D. =Explanation
Formulas and functions all start with the = symbol.Rate this question:
-
- 4.
The feature that allows you to arrange rows in alphabetical order is
- A.
Sorting
- B.
Conditional Formatting
- C.
Filtering
- D.
Autofill
Correct Answer
A. SortingExplanation
Sorting allows you to arrange rows either in ascending or descending orderRate this question:
-
- 5.
The symbol used to multiply in a formula is
- A.
&
- B.
^
- C.
*
- D.
/
Correct Answer
C. *Explanation
The * is used for multiplication. The / is used for division.Rate this question:
-
- 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
Correct Answer
D. To format, move, copy or delete cells all at one timeExplanation
Selecting a range of cells allows you to format, move, copy or delete a specific area of a worksheet.Rate this question:
-
- 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
Correct Answer
C. Print Preview > Page Setup > SheetExplanation
The correct answer is "Print Preview > Page Setup > Sheet". This option is where you can find the setting to print gridlines on a sheet. The Print Preview allows you to see how the document will look when printed, and the Page Setup option within it provides various settings for the printout, including the option to include gridlines.Rate this question:
-
- 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
Correct Answer
A. Press Ctrl + HomeExplanation
The keystroke Ctrl + Home will always bring you to the Home Key (A1). Another way to get to your Home Key is to type "A1" in the name box and press Enter.Rate this question:
-
- 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
Correct Answer
B. Fill SeriesExplanation
Using the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.), you can quickly fill cells in a range with a series of numbers or dates or with a built-in series for days, weekdays, months, or years.Rate this question:
-
- 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
Correct Answer
A. To the left of the active cellExplanation
You can insert rows above and columns to the left of the active cell on your 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 20, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 23, 2009Quiz Created by
Sworonoff
Back to top