Font size
WorksheetsExcel - Fuctions and Charts
Total questions: 20
Worksheet time: 10mins
An Excel spreadsheet is primarily used for calculating which of the following options
A. Data
B. Finances
C. Numbers
D. All of the above
A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
Which button do you click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
Vertical axis of a chart is _______
X axis
Y axis
P axis
B axis
__________ is a area that holds all the elements of a chart.
Plot Area
Chart Title
Chart Area
Legends
What are the two additional tabs that appears after inserting a chart
INSERT, FORMAT
LAYOUT, DESIGN
FORMAT, LAYOUT
DESIGN, FORMAT
A chart is also called as graph.
true
false
Observe the given image and choose the correct answer.
Scatter Chart
Pie Chart
Radar Chart
_______ represents the different data series of the chart.
Axis Title
Legend
Data table
Chart area
A function contains function name and the _______ in the parenthesis.
Formula
group
arguments
series
