NEW
Font size
WorksheetsICT 2 EOC practice test 4 Access Netiquette Excel
Total questions: 25
Worksheet time: 13mins
Which two chart types are the most interchangeable?
Pie and Area
Bar and Column
Line and Scatter
Pie and Bar
What information appears on the vertical axis?
Data series color definitions
Titles
Even counts of all the values in your data series
Data series headings or time frames
A ___________________ is a visual representation of data.
spreadsheet
border
chart
table
What should you do if you want to alter the "look and feel" of a report?
.
Create a form.
Create a query.
Add a report theme.
Import the report into a presentation application
Google Docs is a free Google Cloud application that you can use online to:
Create, edit, share and store webpages and sites.
Create, edit, share and store forms for user input.
Create, edit, share and store spreadsheet documents.
Create, edit, share and store word-processing documents.
Which of the following charts uses vertical bars to display data?
Bar
Pie
Area
Column
To delete a chart, click once on the chart to select it and then ____________.
click the X in the top of the window
press the X key on the keyboard.
click and drag the chart off the spreadsheet.
press the delete key on the keyboard.
What option is used to combine several objects so that they can be treated as a single unit?
Align
Group
Distribute
Order
What is not a type of error that prevents a join from working correctly?
.
Different data types.
Uncommon fields.
Unmatching values
Primary Key
What operations would you perform to add a record?
From File, click Create, Record, enter the appropriate information and save
From File, click new record type in the information and save
In the Datasheet View, enter the appropriate information for each field in the row of the table.
From the Design View, click add, new record, enter the appropriate information and save
Which function adds up the values in a selected range and then divides that total by the number of nonblank cells in the range?
MEDIAN
MIN
AVERAGE
MAX
Which color is considered a primary color?
Red-purple
Blue-purple
Blue
Purple
What information appears most commonly on the horizontal axis?
Quantities
Data series headings or time frames
Data series color definitions
Titles
____________ are used to show a margin of error for each data point.
b.
c.
Trendlines
Error bars
Gridlines
Vertical axes
Which term describes a set of rules for appropriate behavior while on the Internet?
Identity
Netiquette
Cybersecurity
Social network
What View allows you to make changes to the database?
Table View
Form View
Layout View
Design View
Which of the following is a predefined formula that performs a calculation?
function
cell address
parenthesis
operand
Left, Center, Right, and Justify are options in which tool located on the toolbar?
Zoom
Line Spacing
Bulleted Lists
Text Alignment
How long can your “digital footprint” last online?
Forever
Minutes
Months
Hours
Which of the following statements is not true?
You can change both the height and width of a chart with commands on the FORMAT tab
You can use the sizing handles to change the height and width of a chart.
You must delete an existing chart in order to have the data displayed in a different chart type.
When a chart sheet is created, it no longer appears on the worksheet containing the data series.
What is a field in a related database table that refers to the primary key in the primary table?
.
Secondary key
Table key
Foreign key
Common key
A bar chart represents values as which of the following?
Horizontal bars
Vertical bars
Horizontal lines
Vertical lines
Which is the first step that should be taken when creating a chart?
Providing a name for the chart
Selecting the chart type
Selecting the range of cells that contain the data the chart will use
Choosing the data labels that will be used in the chart
A ___________ is a series of points that are plotted on a chart or graph.
line
data markers
data series
bar
Which color is considered a primary color?
.
Red-purple
Blue-purple
Red
Purple
