Food Services Excel Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Sworonoff
S
Sworonoff
Community Contributor
Quizzes Created: 1 | Total Attempts: 124
| Attempts: 124
SettingsSettings
Please wait...
  • 1/10 Questions

    The symbol used to multiply in a formula is

    • &
    • ^
    • *
    • /
Please wait...
About This 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!

Food Services Excel Quiz - Quiz

Quiz Preview

  • 2. 

    Formulas always start with which symbol?

    • (

    • $

    • #

    • =

    Correct Answer
    A. =
    Explanation
    Formulas and functions all start with the = symbol.

    Rate this question:

  • 3. 

    The feature that allows you to arrange rows in alphabetical order is

    • Sorting

    • Conditional Formatting

    • Filtering

    • Autofill

    Correct Answer
    A. Sorting
    Explanation
    Sorting allows you to arrange rows either in ascending or descending order

    Rate this question:

  • 4. 

    If a cell displays #######, it means that

    • There is a formatting error

    • The column is too narrow to dispay all the digits of the number

    • There is an error in your formula

    • You need to center the text within the cell

    Correct Answer
    A. The column is too narrow to dispay all the digits of the number
    Explanation
    Excel will never cut off numbers - it will display ###### to indicate to you that the column is not wide enough.

    Rate this question:

  • 5. 

    A quick way to get to the Home Key (A1) is to

    • Press Ctrl + Home

    • Press Shift A1

    • Use Find and Replace

    • Click on File > Home

    Correct Answer
    A. Press Ctrl + Home
    Explanation
    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:

  • 6. 

    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

    • Merge and Center

    • Fill Series

    • Autoformatting

    • Dragging and Dropping

    Correct Answer
    A. Fill Series
    Explanation
    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:

  • 7. 

    What online resource can you use for Excel training videos, help and support?

    • Excel.com

    • Yahoo Questions and Answers

    • Microsoft.com

    • Spreadsheet Support

    Correct Answer
    A. Microsoft.com
    Explanation
    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:

  • 8. 

    Why might you create a range of cells?

    • To begin a formula

    • To check spelling

    • To type the same information in all of the cells all at one time

    • To format, move, copy or delete cells all at one time

    Correct Answer
    A. To format, move, copy or delete cells all at one time
    Explanation
    Selecting a range of cells allows you to format, move, copy or delete a specific area of a worksheet.

    Rate this question:

  • 9. 

    Print Gridlines is found under:

    • File > Edit > Page Orientation

    • Print Preview > Margins > Print

    • Print Preview > Page Setup > Sheet

    • Page Layout > Borders and Settings

    Correct Answer
    A. Print Preview > Page Setup > Sheet
    Explanation
    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:

  • 10. 

    When inserting a column, it will always appear

    • To the left of the active cell

    • Highlighted

    • To the right of the active cell

    • As a new A column

    Correct Answer
    A. To the left of the active cell
    Explanation
    You can insert rows above and columns to the left of the active cell on your worksheet.

    Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 23, 2009
    Quiz Created by
    Sworonoff
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.