NEW
Font size
WorksheetsBIM Sem 2 Final
Total questions: 45
Worksheet time: 15mins
In Excel, which tab is located in between the Page layout tab and the Data tab?
mailings
formulas
review
tables
In Excel, what does the Wrap Text command do?
Organizes data so it is easier to analyze
Combines and centers the content of selected cells in a new larger cell
Wraps extra-long text into multiple lines so you can see all of it
Displays the formulas in each cell instead of the resulting value
In Excel, which of the following groups on the Home tab contains the commands to insert, delete and format cell width and height?
number
styles
cells
editing
Which of the following is a temporary storage area where all cut and copied items are stored?
formula bar
copy box
clipboard
workbook
In Excel, a line of horizontal cells is called what?
a row
a cell cluster
a column
a group
In Excel, a vertical line of cells is called what?
a row
a group
a line
a column
Justin wants to create a formula which adds the values in cells A1 and B1 together and then multiplies the sum by 10. Which of the following formulas should he enter?
+A1+B1*10
.A1+B1*10
=(A1+B1)*10
(A1+B1)*10
All formulas must begin with which of the following symbols?
equal sign (=)
period (.)
backslash (\)
ampersand (&)
Which of the following can be created between two tables which share a common field?
field report
relationship
datasheet
spreadsheet
Carlos needs to combine words in a First Name and a Last Name column. Which of the following functions should he use?
IF
MAX
MIN
CONCATENATE
Which of the following adds the values in cells A1 through A10?
=SUM(A1:A10)
=SUM(A1,A10)
=SUM(A1!A10)
=SUM($A1$A10)
Alex wants to find the highest value in a range of cells. Which of the following functions should he use?
=MIN( )
=AVERAGE( )
=MAX( )
=MEDIAN( )
In Excel, which of the following tabs contains the command to create a chart?
File
Home
Insert
Page Layout
What type of chart is this?
pie chart
bar chart
treemap chart
sunburst chart
What type of charts are these?
treemap charts
line charts
bar charts
waterfall charts
In PowerPoint, which tab is located in between the Design tab and Animation tab?
Table Tools
Transitions
Formulas
Shapes
Which of the following arranges the content of a PowerPoint slide?
Theme
Style Set
Design
Slide Layout
In PowerPoint, which of the following is not a type of slide layout?
Title and Content
Two Content
Comparison
Title and Compare
Animation-like effects which occurs when moving from one slide to another during a presentation are called?
Slide effects
Animations
Transitions
Themes
In order to select multiple slides in a presentation, which of the following keys can be pressed?
Tab
Control
Alt
Enter
In a slide, the movements which can be applied to objects such as text and shapes are called?
Text effects
Transitions
Motion effects
Animations
Which of the following should be clicked to open Backstage View?
File Tab
Home Tab
Insert Tab
Animations Tab
Shane wants to add an entrance effect to a SmartArt object in his PowerPoint presentation. Which of the following tabs should he look on to find the entrance effects available?
Design
Transitions
Animations
Slide Show
A picture used as a background must be saved to your computer before inserting the image as a background.
True
False
Which of the following is not a type of transition you can add to a slide?
wipe
split
fly in
curtains
Which of the following is not a type of animation you can add to an object?
push
fly in
brush color
wave
You can only add one animation to each object on a slide.
True
False
You can reorder the animation sequence by using the Animation Pane.
True
False
In PowerPoint, clicking on this icon will...
quickly quit PowerPoint.
start the slide show.
save your presentation.
print your presentation.
To delete a slide, you would do which of the following?
Click on the slide thumbnail and press the delete key
Right click on the slide thumbnail and select the Delete Slide option
Click on the slide and press the Backspace key
Both A and B
A shape cannot be filled with a picture.
True
False
To duplicate a shape or picture, select the item and press...
Shift + D
Alt + D
Ctrl + D
Fn + D
What type of slide layout is pictured?
Title and Content
Two Content
Blank
Comparison
You used the word “company” several times in your presentation, but would like to change it to the word “organization.” What is the quickest way to accomplish this?
Double click on the word “company” each time it is used and type the word “organization.”
Use the Reset icon.
Use the Find and Replace feature.
None of the above.
What is this animation control called? It allows you to edit and change the timeline of animations on the slide.
Animation Timeline
Animation Pane
Animation Control
Animation Playback
You can email your presentation from within PowerPoint.
True
False
What type of database is Access?
Hierarchical database
Relational database
Network database
Object Oriented database
In Access, databases are made up of 4 basic objects. Which of the following in not one of them?
sheets
tables
forms
queries
In Access, which object is used to store all data and is also considered the heart of any database?
tables
forms
queries
reports
In Access, rows are called what?
files
records
sheets
lines
In Access, columns are called what?
pillars
lines
tables
fields
In Access, which object is used for entering, modifying, and viewing records?
tables
forms
queries
reports
In Access, each record has its own ID.
True
False
In Access, which object is used for searching and compiling data? Kind of like asking a detailed question of your database.
reports
forms
tables
queries
In Access, which object gives you the ability to customize and printout your data in an easy-to-read format?
forms
tables
queries
reports
