WorksheetsExcel Quiz
Total questions: 15
Worksheet time: 5mins
An Excel formula begins with what symbol?
#
@
&
=
What chart is best used to show movement and trends of data over a period of time?
Bar chart
Pie chart
Column chart
Line chart
To _________ cells means to combine multiple selected cells into a single cell.
merge
fuse
form
mix
TRUE or FALSE. A sheet that is deleted can still be recovered.
True
False
Row headings in Excel are displayed as:
numbers
letters
What symbol is placed before a number to convert it from a value to a label?
/
'
!
*
What part of the active cell can you use the fill handle?
Upper right
Upper left
Lower right
Lower left
What is the shortcut key to get the sum of values in cells?
Ctrl +
Alt =
Alt +
Ctrl =
To change how the chart will look like visually, what area of the Chart Design will be used?
Chart styles
Chart type
Chart elements
Chart location
This is the main working area, a single "page" in MS Excel
(a)
This is a built-in formula used for quick, specific computation.
(a)
The data shows five values: 27, 35, 32, 41 and 36. The result after using a function shows 41. Which of the five basic functions was used to display the result?
(a)
What is the chart element "Quarters" refer to?
Vertical axis title
Horizontal axis title
Vertical axis
Horizontal axis
The Hispanic, White, African American and other race shown in the picture is called the (a) of the chart.
What do you call this part of the Excel interface?
Name box
Sheet tab
Active cell
Formula bar
