Font size
WorksheetsExcel Review Quiz
Total questions: 20
Worksheet time: 14mins
Which tab to you press to find charts?
Home
Review
Insert
Formulas
This is an example of what kind of chart?
Scatter
Column
Line
Pie
why would an Admin Assistant use charts?
To make formulas look better
To make comparisions
To present data easier
To hide data
=A4/A2 is an example of what formula?
Division
Adding
Multiply
Subtraction
=A1*A2 is an example of what formula?
Subtraction
Adding
Multiply
Divison
Draw the symbol for SUM (AUTOSUM)
In Excel you can add formulas and (a) when performing calculations, so you do not have to use a calculator
True or false - you need to highlight the data you want first before creating a chart?
True
False
A program that can be used to do calculations and graphing
PowerPoint
Spreadsheet
Word
Outlook
What is the purpose of the following command?
Change the background color of a cell
Change the color of text in a cell
Change the border color around the cell
Answer not listed.
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?
cell bar
formula bar
status bar
name box
The cell that is currently selected for data entry
Cell Address
Active Cell
Cell Range
Values
A preprogrammed formula
Formula
Spreadsheet
Function
Cell Range
A graph that shows trends over time
Bar graph
Pie Graph
Line graph
Graph
A graph that compares values
Bar graph
Pie Graph
Line graph
Graph
Every formula starts with what?
=
+
-
( )
To put data in a certain order is to _____________.
Label
Sort
Cell Range
Select data
If you change the value in a cell then the associated graph will NOT change.
True
False
What would the formula be if I wanted to add cells B4 and C4?
(a)
