NEW
Font size
WorksheetsExcel Final Exam
Total questions: 34
Worksheet time: 17mins
When you create a new workbook, you always start with five blank worksheets.
true
false
Functions start with =.
True
False
A cell with an Absolute Cell Reference does not change when you copy the formula.
True
False
Excel always starts spell-checking from the beginning of the worksheet.
True
False
The Comma Style button inserts commas, and two decimal places.
True
False
The COUNTA function ignores text.
True
False
You can create a chart on its own sheet or within a worksheet containing data.
True
False
A data point is a single value or piece of data from the data series.
True
False
An Annotation is text you enter to further describe data.
True
False
Alignment within a cell moves the value of the cell left, right or center.
True
False
When deleting a row, the data will move to the next remaining row.
True
False
When inserting a column, the new column will always be to the right.
True
False
Conditional formatting within a cell can be the background or the data/text.
True
False
You cannot delete sheets on a workbook.
True
False
Spell-checker is automatic to all sheets.
True
False
The container for the entire chart and all of its elements is the Chart Area.
True
False
The region containing the graphical representation of the values in the data series is the Plot Area.
True
False
The horizontal border that provides a frame of reference for measuring data left to right is the X-Axis.
True
False
The vertical border that provides a frame of reference for measuring data up and down is the Y-Axis.
True
False
The key that identifies the color, gradient, picture, texture, or pattern is assigned to each data series in a chart is the legend.
True
False
Line charts could be helpful in viewing:
Your families height
A single list of data
Percentages of a whole
Company revenue vs. time
Which of the following is best presented using a spreadsheet?
a memo
a Trial balance
an address list
a presentation
A file extension for excel is?
.xlw
.exl
.xls
.mxl
To print a worksheet:
Click the print button
Choose print from the file menu
Press [Ctrl] + P
All of the above
Which formatting tool helps users by formatting values that fall into certain range?
Google Search
Natural Language
Conditional
Scenario
To exit Excel:
Choose exit from the file menu
Turn off your computer
Triple-click the mouse
Double-click the title bar
As you key data, it appears in the active cell in the:
formula bar
status bar
menu bar
name box
If you see a range address of A1:B3, the range would include___?
6 cells on 3 rows and in 2 columns.
6 cells on 2 rows and in 3 columns
4 cells on 6 rows and in 3 columns
4 cells on 3 rows and in 6 columns
To change a column width:
Drag the row border to a different size
Double-click the column's right border to Autofit
Double-Click a row's bottom border to Autofit
None of these
To show a percentage on a slice of a pie chart, use this tab in the Format Data Series Dialog Box:
Axes
Gridline
Data Labels
Data Table
Charts that show trends in data over a period of time are:
Bar Charts
Column Charts
Line Charts
Pie charts
A guide that explains the symbols, patterns, or colors used to differentiate data series is a:
Legend
Plot area
Value Axis
Data Series
The horizontal axis is generally the:
Y axis
Z axis
T axis
X axis
When you select a chart, the data menu is replaced by the :
insert menu
tools menu
format menu
chart menu
