NEW
Font size
WorksheetsDay 1 - Wrap up (Workforce Excel)
Total questions: 20
Worksheet time: 12mins
Which symbol must you use to begin a formula ?
$
#
@
=
The numbers in Excel represent the...
Rows
Columns
Cells
Data
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
These are known as
workbooks
worksheets
formula bar
cell
What is the purpose of the SUM function in Excel?
To add up a range of numbers or cells.
To multiply a range of numbers or cells.
To divide a range of numbers or cells.
To subtract a range of numbers or cells.
What function was used to find the lowest grade?
average
sum
min
max
What function was used to find the highest grade?
average
min
sum
max
Greater Than
Less Than
Equal To
Above Average
1
2
3
4
Color Scales
Icon Sets
Data Bars
Top/Bottom Rules
How can you highlight cells based on specific criteria in spreadsheets?
Conditional formatting
Manual formatting
Random formatting
Unconditional formatting
An Excel file format extension is
doc
xls
txt
mp3
When creating a chart in Excel, what is the first thing you need to do?
Select the data to be graphed.
Select the Insert Tab
Choose a chart from the ribbon
Double click the active cell
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
Which of the following is the correct way to write a function in a spreadsheet?
=SUM(A1-A5)
=SUM A1+A5
SUM (A1:A5)=
=SUM(A1:A5)
Which error is obtained when a formatted number does not fit within a cell?
a.#####
b.#DIV/0
c.#DIV@
d.#VALUE!
