Food Services Excel Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Sworonoff
S
Sworonoff
Community Contributor
Quizzes Created: 1 | Total Attempts: 118
Questions: 10 | Attempts: 118

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!

• 1.

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

• A.

Excel.com

• B.

• C.

Microsoft.com

• D.

C. 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:

• 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

B. 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:

• 3.

• A.

(

• B.

\$

• C.

#

• D.

=

D. =
Explanation

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

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

Rate this question:

• 5.

The symbol used to multiply in a formula is

• A.

&

• B.

^

• C.

*

• D.

/

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

D. 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:

• 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

C. 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:

• 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

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:

• 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

B. 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:

• 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

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 +

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

Related Topics