Excel Intermediate Quiz

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