NEW
Font size
WorksheetsG3 Final 2 MS Excel Review 20/21
Total questions: 35
Worksheet time: 18mins
What do all calculations start with?
=
(
-
\
What symbol should be used to perform an adding calculation?
+
-
*
/
What symbol should be used to perform a subtraction calculation?
-
*
+
/
What symbol should be used to perform a multiplying calculation?
+
-
*
/
What symbol should be used to perform a division calculation?
/
-
*
+
What software do we use to create spreadsheets?
Word
PowerPoint
Sway
Publisher
Excel
What is the name of each "box" on a spreadsheet?
Cell
Box
Rectangle
A cell reference (cell address) is the location of a cell (A1, B2, C3, etc).
True
False
What is the correct order that makes a Cell Reference (Cell
Address) ?
Letter then Number
Number then Letter
What type of chart is this?
Donut
Radar
Bar
Pie
What key is used to select many cells?
Shift
CTRL
ALT
Shift+ALT
Which of the following cursor allows you to select cells?
Which to use to change the size of a column?
The Fill handle?
Which formula can add all numbers in many cells
MIN
MAX
SUM
AVERAGE
What must all formulas start with?
+
=
#
sum
You can select many cells anywhere on the spreadsheet by holding down the ________ key and clicking each cell.
Shift
Ctrl
Alt
Enter
Which of the following is an example of a cell reference (cell address)?
Column C
=SUM
Row 1
A5
Spreadsheet columns are easily known by:
Roman numerals
numbers
letters
colors
Spreadsheet rows are easily known by:
numbers
letters
Roman numerals
colors
A spreadsheet program is used to store data in:
a database
a text document
rows and columns
letters and numbers
A cell address is a column number followed by a row letter.
True
False
You must click a cell before entering data.
True
False
You can edit a cell by double-clicking the cell
True
False
Using the mouse is a quick and easy way to change column width or row height
True
False
To do a calculation in MS Excel, you enter a ____ in a cell.
value
label
sum
formula
The small black square that you drag to copy formulas into other cells is called the ____.
cell pointer
fill handle
cell handle
fill pointer
The ____ bar shows the text/number/formula of the selected cell.
formula
data
name
address
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
To quickly add a lot of numbers you can use the ____
Plus Sum Button
Add Sum Button
Quick Add Button
Auto Sum Button
The letters in Excel stand for ___ ?
columns
rows
data
functions
The numbers in Excel stand for ___ ?
columns
rows
data
functions
When making a graph/chart what's the first thing you need to do?
Pick the type of Graph
Use the function = sign
Highlight your information/data being used.
Double click the active cell
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
