WorksheetsExcel Spreadsheet Quiz
Total questions: 53
Worksheet time: 29mins
The intersection of a column and a row in an Excel Spreadsheet is called what? *
worksheet
cell
workbook
spreadsheet
AutoFit (Auto Size) automatically adjusts the width of a column so it fits the content exactly.
True
False
You can use Excel to create which of the following? (check all that apply)
Budgets
Invoices
Contact Lists
workbook
Name Tags
Number formats tell Excel exactly what type of data you're using.
True
False
Does Excel recognize January 1st as a number value with the ability to use the Fill Handle?
yes
no
You can edit multiple worksheets at once by doing this.
Inserting
Filtering
Grouping
Adjusting
Other: ________
True or False: When you make a change in one sheet of a group, then all of the sheets are updated.
True
False
What is the default number format used by Excel?
Number
General
Time
Other
Where does the actual value of a formatted number cell appear?
In the formula
On the Ribbon
Other: ________
To add a new column, select the column heading ______ and select Insert from the Cells group.
To the right
To the left
Saving
The ______ can be used to continue a series of dates.
Copy Command
Fill Handle
Select All Command
Format
Other: ________
Does Excel recognize January 1st as a number value with the ability to use the Fill Handle?
yes
no
When you type a percent sign next to your number in a cell, what cell style is applied?
General
Percent
Fraction
Other: ________
If you type the number 8 into a cell and then apply the Percent Normal Style, what number will be displayed in the cell?
8%
800%
When you use the increase or decrease decimal buttons does the actual value entered in the cell change?
yes
no
Write the formula for yearly savings? (Hint: How many months are in a year?)
If the workbook is something you've worked on recently it might be listed under __________ workbooks.
Browse
OneDrive
Add a Place
Recent
_________ a file lets you have access to your most frequently used files.
Printing
Pinning
Deleting
Saving
To use OneDrive, you have to be logged into your Microsoft account.
True
False
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.
True
False
If you want to save a different version of your document, you can select ______ in the Backstage View (File Tab).
Save As
Save
You can select _____ in the Backstage View to convert your spreadsheet to other formats.
Export
Publish
Save
Which of the following methods can you use to share a document?
Invite someone to view the document
Send as an attachment
Get a shareable link
All of the choices are correct
_____ is a feature that automatically saves changes to your file.
Auto Correct
AutoSave
Back space
Delete
The Ribbon is a collection of tools and features at the bottom of the screen.
True
False
The Font Group Tab in Excel is different than the Font Group Tab in Word.
True
False
The Quick Access toolbar may be customized to include frequently used commands.
True
False
The "Tell Me" feature works like a *
text to type feature
large table with multiple commands
search bar
tab similar to File and Insert
A Microsoft Excel workbook is also referred to as a worksheet or *
data sheet
graphic illustration
spreadsheet
SmartArt graphic
The default view for an Excel spreadsheet is
Page Layout view
Normal view
Page Break Preview
How do you get to the Backstage View? *
Click on Backstage View
Click on File Tab
Click the Back Button
Click the Escape Button
Click on the View Tab > Backstage View > Back
The Save and Print commands are located in the *
Backstage view
Normal view
Zoom review
Page Review view
How can the height of rows be adjusted? *
Manually
AutoFit
All answers are correct.
The ____ button allows you to select all content in a workbook. *
Insert
Select All
Highlight
Other: ________________
To add a new row, select the row heading _____ and select Insert from the Cells group. Mark only one oval.
Above
Below
Add a Place
To add a new column, select the column heading _____ and select Insert from the Cells group. Mark only one oval.
To the right
To the left
Saving
To delete a column or row, select the heading and select _____ from the Cells group. Check all that apply.
Delete
Insert
Format
Other: _____
To move a row or column, select the heading, select ____ from the Clipboard, select the location, and select Insert Cut Cells.
Paste
Copy
Cut
Columns and rows can be hidden.
True
False
____ displays text on multiple lines in a cell.
Wrap Text
Merge & Center
Publish
In which Group is the Fill Color feature located on the Ribbon?
Alignment Group
Editing Group
Font Group
Other: _______________
In which Group are the Cell Styles located on the Ribbon?
Number Group
Styles Group
Clipboard Group
Other: _______________
In which Group is the Border feature located on the Ribbon?
Alignment Group
Editing Group
Font Group
Other: _______________
You can use the arrows keys to navigate between cells.
True
False
The location of a cell is called the...
Column D
intersection
cell address
Row 6
Select the items that can placed in the cells. (select all that apply)
formulas
functions
text
formatting elements
When the Narrator typed the letter "X", the letter appeared in both the cell and the ________.
formula bar
navigation ribbon
ribbon
workbook handle
Which feature allows you to remove text from cells? (select all that apply)
Backspace
Spacebar
Clear Contents
Delete
Is there a difference between clearing and deleting?
Yes
No, They are the same.
What are the categories in the Paste drop-down menu? (select all that apply)
Paste Values
Format Painter
Paste
Other Paste Options
What feature, other than cut & paste, can you use to move cells to a new location?
Format Painter
Copy & Paste
Drag & Drop
None, there is no other way
Where is the Fill Handle located?
top left corner
top right corner
bottom left corner
bottom right corner
Can you use the Fill Handle to continue a sequence of numbers?
Yes, most definitely, so COOL!
No. The computer is unable to know what you are thinking or needing in your spreadsheet.
