Food Services Excel Quiz

10 Questions | By Sworonoff | Updated: Mar 20, 2022 | Attempts: 113

Questions

Settings

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!

Questions and Answers

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