NEW
Font size
WorksheetsExcel Intermediate Quiz
Total questions: 16
Worksheet time: 8mins
What is an Excel file called?
Document
Worksheet/spreadsheet
Presentation
Page
Several worksheets make up a ...
Database
Graph
Workbook
Chart
What term refers to mathematical equations used in Excel to perform calculations?
Cell
Functions
Formulas
Summations
In order to multiply items in Excel you would use:
^
*
@
#
In Excel, all formulas must begin with what symbol?
=
#
@
!
To add the numbers in cells b3 to b7, which formula is the only one that will work?
=Add b3 to b7
=Sum(b3:b7)
Sum(b3:b7)
Add b3 to b7
What is the formula to subtract D7 from C7?
=D7+C7
=C7-D7
=D7-C7
=C7+D7
You want to enter a series of numbers down a column. What would be the best tool for the job?
Cut and Paste
Find and Replace
Spelling Checker
Autofill
What does this symbol Σ stand for?
AutoSum
Format Cells
Insert Function
Align Text
Can you change the colour of a cell?
Only with a plugin
Only in certain versions
No
Yes
It is not necessary to enter the equal sign prior to entering a formula.
False
True
Sometimes
Only for certain functions
As you enter data in cells it appears automatically in the ___ which is located above the worksheet.
Title bar
Menu bar
Formula bar
Status bar
How does numerical data appear in the cells of your spreadsheet?
Right Aligned
Centered
Aligned Left
Justified
How do you alphabetically sort information?
Click insert and then hit group
Click the column you need to sort. Hit Data tab and then Sort
Click on the column wanted to sort and then go to Insert.
Right Click. Go to format cells. Click alignment
Cells can not perform mathematical calculations. True or False
False
True
How can you quickly adjust the width of a column to fit its content?
Double-click the right border of the column header
Right-click and select 'Fit to Content'
Use the 'Format' menu
Drag the column border manually
