wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Spreadsheet Quiz

Total questions: 53

Worksheet time: 29mins

Name
Class
Date
1.

The intersection of a column and a row in an Excel Spreadsheet is called what? *

a)

worksheet

b)

cell

c)

workbook

d)

spreadsheet

2.

AutoFit (Auto Size) automatically adjusts the width of a column so it fits the content exactly.

a)

True

b)

False

3.

You can use Excel to create which of the following? (check all that apply)

a)

Budgets

b)

Invoices

c)

Contact Lists

d)

workbook

e)

Name Tags

4.

Number formats tell Excel exactly what type of data you're using.

a)

True

b)

False

5.

Does Excel recognize January 1st as a number value with the ability to use the Fill Handle?

a)

yes

b)

no

6.

You can edit multiple worksheets at once by doing this.

a)

Inserting

b)

Filtering

c)

Grouping

d)

Adjusting

e)

Other: ________

7.

True or False: When you make a change in one sheet of a group, then all of the sheets are updated.

a)

True

b)

False

8.

What is the default number format used by Excel?

a)

Number

b)

General

c)

Time

d)

Other

9.

Where does the actual value of a formatted number cell appear?

a)

In the formula

b)

On the Ribbon

c)

Other: ________

10.

To add a new column, select the column heading ______ and select Insert from the Cells group.

a)

To the right

b)

To the left

c)

Saving

11.

The ______ can be used to continue a series of dates.

a)

Copy Command

b)

Fill Handle

c)

Select All Command

d)

Format

e)

Other: ________

12.

Does Excel recognize January 1st as a number value with the ability to use the Fill Handle?

a)

yes

b)

no

13.

When you type a percent sign next to your number in a cell, what cell style is applied?

a)

General

b)

Percent

c)

Fraction

d)

Other: ________

14.

If you type the number 8 into a cell and then apply the Percent Normal Style, what number will be displayed in the cell?

a)

8%

b)

800%

15.

When you use the increase or decrease decimal buttons does the actual value entered in the cell change?

a)

yes

b)

no

16.

Write the formula for yearly savings? (Hint: How many months are in a year?)

4 lines
17.

If the workbook is something you've worked on recently it might be listed under __________ workbooks.

a)

Browse

b)

OneDrive

c)

Add a Place

d)

Recent

18.

_________ a file lets you have access to your most frequently used files.

a)

Printing

b)

Pinning

c)

Deleting

d)

Saving

19.

To use OneDrive, you have to be logged into your Microsoft account.

a)

True

b)

False

20.

If you are saving a new workbook, you will be taken to the Backstage View when you click the Save button on the Quick Access Toolbar.

a)

True

b)

False

21.

If you want to save a different version of your document, you can select ______ in the Backstage View (File Tab).

a)

Save As

b)

Save

22.

You can select _____ in the Backstage View to convert your spreadsheet to other formats.

a)

Print

b)

Export

c)

Publish

d)

Save

23.

Which of the following methods can you use to share a document?

a)

Invite someone to view the document

b)

Send as an attachment

c)

Get a shareable link

d)

All of the choices are correct

24.

_____ is a feature that automatically saves changes to your file.

a)

Auto Correct

b)

AutoSave

c)

Back space

d)

Delete

25.

The Ribbon is a collection of tools and features at the bottom of the screen.

a)

True

b)

False

26.

The Font Group Tab in Excel is different than the Font Group Tab in Word.

a)

True

b)

False

27.

The Quick Access toolbar may be customized to include frequently used commands.

a)

True

b)

False

28.

The "Tell Me" feature works like a *

a)

text to type feature

b)

large table with multiple commands

c)

search bar

d)

tab similar to File and Insert

29.

A Microsoft Excel workbook is also referred to as a worksheet or *

a)

data sheet

b)

graphic illustration

c)

spreadsheet

d)

SmartArt graphic

30.

The default view for an Excel spreadsheet is

a)

Page Layout view

b)

Normal view

c)

Page Break Preview

31.

How do you get to the Backstage View? *

a)

Click on Backstage View

b)

Click on File Tab

c)

Click the Back Button

d)

Click the Escape Button

e)

Click on the View Tab > Backstage View > Back

32.

The Save and Print commands are located in the *

a)

Backstage view

b)

Normal view

c)

Zoom review

d)

Page Review view

33.

How can the height of rows be adjusted? *

a)

Manually

b)

AutoFit

c)

All answers are correct.

34.

The ____ button allows you to select all content in a workbook. *

a)

Insert

b)

Select All

c)

Highlight

d)

Other: ________________

35.

To add a new row, select the row heading _____ and select Insert from the Cells group. Mark only one oval.

a)

Above

b)

Below

c)

Add a Place

36.

To add a new column, select the column heading _____ and select Insert from the Cells group. Mark only one oval.

a)

To the right

b)

To the left

c)

Saving

37.

To delete a column or row, select the heading and select _____ from the Cells group. Check all that apply.

a)

Delete

b)

Insert

c)

Format

d)

Other: _____

38.

To move a row or column, select the heading, select ____ from the Clipboard, select the location, and select Insert Cut Cells.

a)

Paste

b)

Copy

c)

Cut

39.

Columns and rows can be hidden.

a)

True

b)

False

40.

____ displays text on multiple lines in a cell.

a)

Wrap Text

b)

Merge & Center

c)

Publish

41.

In which Group is the Fill Color feature located on the Ribbon?

a)

Alignment Group

b)

Editing Group

c)

Font Group

d)

Other: _______________

42.

In which Group are the Cell Styles located on the Ribbon?

a)

Number Group

b)

Styles Group

c)

Clipboard Group

d)

Other: _______________

43.

In which Group is the Border feature located on the Ribbon?

a)

Alignment Group

b)

Editing Group

c)

Font Group

d)

Other: _______________

44.

You can use the arrows keys to navigate between cells.

a)

True

b)

False

45.

The location of a cell is called the...

a)

Column D

b)

intersection

c)

cell address

d)

Row 6

46.

Select the items that can placed in the cells. (select all that apply)

a)

formulas

b)

functions

c)

text

d)

formatting elements

47.

When the Narrator typed the letter "X", the letter appeared in both the cell and the ________.

a)

formula bar

b)

navigation ribbon

c)

ribbon

d)

workbook handle

48.

Which feature allows you to remove text from cells? (select all that apply)

a)

Backspace

b)

Spacebar

c)

Clear Contents

d)

Delete

49.

Is there a difference between clearing and deleting?

a)

Yes

b)

No, They are the same.

50.

What are the categories in the Paste drop-down menu? (select all that apply)

a)

Paste Values

b)

Format Painter

c)

Paste

d)

Other Paste Options

51.

What feature, other than cut & paste, can you use to move cells to a new location?

a)

Format Painter

b)

Copy & Paste

c)

Drag & Drop

d)

None, there is no other way

52.

Where is the Fill Handle located?

a)

top left corner

b)

top right corner

c)

bottom left corner

d)

bottom right corner

53.

Can you use the Fill Handle to continue a sequence of numbers?

a)

Yes, most definitely, so COOL!

b)

No. The computer is unable to know what you are thinking or needing in your spreadsheet.