Font size
WorksheetsBCA 2nd Semester POD's
Total questions: 61
Worksheet time: 1hrs 1mins
A(n) electronic is an application you use to perform numeric calculations and to analyze and present numeric data.
(a)
You are in Edit Mode any time you are entering or changing the contents of the cell.
True
False
is identified by the coordinates of the intersecting column and row.
(a)
A dark rectangle, the outlines of the cell you are working in is the .
(a)
A(n) is an entry in a cell that contains text such as “2016 Sales” or Travel Expenses.”
(a)
A(n) is a built-in formula that uses arguments to calculate information.
(a)
In the formula =(G15-G14) *$M$¾, which mathematical operation in preformed first?
Division 3/4
Subtraction (G15-G14)
Multiplication *$M
Division & Multiplication
*$M$3/4
The $ symbol placed before a row or column address indicates a(n) reference.
(a)
When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
They remain the same
They delete
They become absolute
They are automatically updated or adjusted
All functions begin with the formula prefix which is a(n) .
(a)
An Excel user should use a relative cell reference when it is important to .
(a)
The default file extension for Excel is .
(a)
Which method of entering a function requires the user to know the name and initial characters of the function?
AutoComplete
AutoFill
When you manually type the function
When you copy paste the function
With Autofill, dragging the Fill Handle on a cell copies the cell’s contents or continues a series of data into adjacent cells.
True
False
You can change the of labels to be left, right, or center.
(a)
A predefined set of attributes that gives your Excel worksheet a professional look is a .
(a)
What has a default value of 8.43 characters, a little less than one inch?
Row Width
Column Width
Row Height
Column Height
Double-clicking the column line to the right of a column activates the feature for the column.
(a)
A small triangle appears in the upper right corner of a cell containing a note.
(a)
The Format Painter button copies both the cell’s contents and formatting.
False
True
To check the spelling in more than one sheet of a multiple sheet workbook, you need to display each sheet and run the spelling checker again.
True
False
The x-axis and the y-axis are respectively the .
(a)
A chart that is inserted directly in the current worksheet is a(n) chart.
(a)
To enter text notes on a slide, click in the pane and then type.
(a)
In a slide show the font should never be smaller than points.
(a)
It is a good idea to limit each slide to six words per line and lines per slide.
(a)
During a slideshow which key is pressed to pause the show?
P
Spacebar
S
X
Combing visual messages with verbal messages can increase memory retention by as much as .
(a)
The primary view that is used to write, edit, and design a presentation is view.
(a)
The New Slide button is in the Slides group on the tab.
(a)
After you enter text in a placeholder it becomes a text .
(a)
is an exception to copyright and permits the public to use copyrighted material for certain purposes without obtaining prior consent of the owner.
(a)
Pressing Ctrl + ; will insert the current date in a date field.
False
True
Tables contain all of the data in a database.
True
False
Tables, queries, and forms are examples of Access .
(a)
What data type is used for sequential integers controlled by Access?
AutoFill
Ascending
Numbering
AutoNumber
A purchase price field should be what data type?
Currency
Money
Short Text
A relationship describes when a record from one table is related to several records in another table.
(a)
Which Access object provides an easy to use data entry screen?
Query
Form
Report
Table
An Access database is limited to a size of 1 gigabyte.
False
True
A(n) is a fundamental building block of a relational database because this object stores all the data.
(a)
A group of related fields, such as all the demographic information for one customer is called a(n) .
(a)
A specific category of data such as a customer’s name, city, state, and phone number is called a(n) .
(a)
Microsoft Access can best be described as software.
(a)
You can create multiple charts based on the same worksheet data.
False
True
Which chart type would be the best candidate to emphasize sales trends over a period of six months?
Scatter Plot
Bar chart
Pie chart
Line chart
A(n) chart compares distinct object levels using vertical bars which is the Excel default.
(a)
In a pie chart, slices that are pulled away are said to be exploded.
(a)
Microsoft Edge and FireFox are two examples of home pages.
True
False
An Excel complex formula uses more than one arithmetic operator.
Fasle
True
Which of the following is NOT a Web search engine?
Edge
Bing
Yahoo
Use colors for slide background and text to make the text readable.
(a)
Enterance and Exits are .
(a)
A purchase price field should be which data type?
Money
Time
Currency
Dollars
Which chart type would be the best candidate to emphasize sales trends over a period of 6 months?
Circle
Pie
Bar
Line
The x-axis and y-axis are, respectively, the .
(a)
You can use a spreadsheet to by using variable values to investigate and sample different outcomes.
(a)
When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
Cell references become incorrect
They stay the same
Cell references are automatically adjusted
They automatically go backwards
A type of conditional formatting that visually illustrates differences among values.
Data Bar
Pie Chart
Scatter Plot
Between
The button on the formula bar is one way to easily insert a function into a worksheet cell.
(a)
A(n) is a predefined worksheet formula that enables Excel users to easily perform complex calculations.
(a)
