NEW
Font size
S
M
L
XL
WorksheetsBusiness Information Management I - Semester 2 Exam
Total questions: 50
Worksheet time: 50mins
Name
Class
Date
1.
Which tab contains the command to save the presentation as a different file type?
a)
A. File
b)
B. Home
c)
C. Insert
d)
D. Transitions
2.
Which view should be used to preview how a presentation will be viewed when presenting?
a)
A. Slide Sorter
b)
B. Slide Show
c)
C. Outline
d)
D. Normal
3.
Which of the following is a box with dotted borders which contain content?
a)
A. Slide box
b)
B. Placeholder
c)
C. Graphic box
d)
D. Slide Sorter
4.
Which of the following should you edit if you want to make changes on all of the slides in a presentation?
a)
A. Slide Transitions
b)
B. Slide Sorter
c)
C. Slide Master
d)
D. First slide of a presentation
5.
Which of the following is a variation of a theme which uses different color schemes?
a)
A. Deviations
b)
B. Backdrops
c)
C. Theme Effects
d)
D. Variants
6.
Which graphic type should be used if you want to illustrate information, concepts or ideas through the use of a diagram?
a)
A. Table
b)
B. Photo Album
c)
C. WordArt
d)
D. SmartArt
7.
Which of the following is an animation which affects how the object or text is removed from a slide during a presentation?
a)
A. Entrance
b)
B. Emphasis
c)
C. Exit
d)
D. Motion
8.
Which of the following appears on the Ribbon when WordArt, shapes or text boxes are added or selected in presentation?
a)
A. Drawing Tools
b)
B. Formatting Tools
c)
C. Chart Tools
d)
D. Style Tools
9.
Which tab on the Ribbon holds the commands for creating a motion path?
a)
A. Design
b)
B. Transitions
c)
C. Animations
d)
D. Slide Show
10.
Which of the following arranges the content of a slide?
a)
A. Theme
b)
B. Style set
c)
C. Design
d)
D. Slide Layout
11.
In which of the following locations can notes be added to a presentation and then printed out for the presenter to use?
a)
A. Comments pane
b)
B. Notes pane
c)
C. Review pane
d)
D. Slides pane
12.
Which of the following opens when adding a chart to a presentation?
a)
A. Word document
b)
B. Access database
c)
C. Excel spreadsheet
d)
D. Access report
13.
Which group on the Home tab contains the command to format the text on a slide into a numbered list?
a)
A. Font
b)
B. Drawing
c)
C. Text
d)
D. Paragraph
14.
Which file type should be used if you want to create a file which automatically shows the presentation as a slide show?
a)
A. PowerPoint Show
b)
B. Template
c)
C. Presentation
d)
D. Compatibility mode
15.
Which of the following shows the location of the cell which you have selected?
a)
A. Formula bar
b)
B. Cell name box
c)
C. Worksheet tab
d)
D. Dialog box
16.
Which of the following are composed of a grid system of rows and columns which cross to make cells?
a)
A. Worksheets
b)
B. Table guides
c)
C. Graphs
d)
D. Formulas
17.
Which of the following is the correct formula to add cells A1 and B2?
a)
A. A1+B2
b)
B. =A1+B2
c)
C. SUM(A1:B2)
d)
D. =$A1,$B2
18.
Which of the following is an absolute cell reference?
a)
A. A1
b)
B. A$1
c)
C. $A1
d)
D. $A$1
19.
Which of the following finishes an entry based on previous entries made in the column containing the active cell?
a)
A. AutoFinish
b)
B. FillComplete
c)
C. Conditional formatting
d)
D. AutoComplete
20.
Which of the following is NOT a type of conditional formatting?
a)
A. Data bar
b)
B. Icon set
c)
C. Highlight
d)
D. Comment
21.
Which of the following functions finds the lowest value in a range of cells?
a)
A. =AVG( )
b)
B. =MAX( )
c)
C. =LOW( )
d)
D. =MIN( )
22.
Which of the following cell references is read as “cell A1 through D6?”
a)
A. A1,D6
b)
B. A1!D6
c)
C. A1$D6
d)
D. A1:D6
23.
Which of the following cell references is read as “cell A1 and D6?”
a)
A. A1,D6
b)
B. A1!D6
c)
C. A1:D6
d)
D. A1-D6
24.
Which of the following CANNOT be used as a math operator in a formula?
a)
A. * asterisk
b)
B. + plus sign
c)
C. : colon
d)
D. / slash
25.
Which of the following formulas returns the current date and time?
a)
A. =DATE( )
b)
B. =TIME( )
c)
C. =NOW( )
d)
D. =TODAY( )
26.
Which of the following error messages would appear if the cell reference is not valid?
a)
A. Railroad Tracks Error, #####
b)
B. #REF!
c)
C. #NAME?
d)
D. #CELL?
27.
The IF Function is an example of which type of function?
a)
A. Financial
b)
B. Text
c)
C. Date & Time
d)
D. Logical
28.
Which of the following is NOT a comparison operator?
a)
A. > greater than arrow
b)
B. < less than arrow
c)
C. / slash
d)
D. = equals sign
29.
All formulas must begin with which of the following symbols?
a)
A. Equals sign (=)
b)
B. Ampersand (&)
c)
C. Plus sign (+)
d)
D. Period (.)
30.
José notices cell A5 of his worksheet contains the railroad tracks (#####) formula error. What should he do?
a)
A. Delete the formula and just enter the value he wants in the cell
b)
B. Resize the cell to fit the contents
c)
C. Clear the formatting on the cell
d)
D. Filter the cell
31.
Which of the following describes Microsoft® Access?
a)
A. Spreadsheet management system
b)
B. Database management system
c)
C. Personal scheduling system
d)
D. Word processing program
32.
Which of the following is a collection of information and objects associated with a specific subject?
a)
A. Database
b)
B. Form
c)
C. Filter
d)
D. Report
33.
Which of the following is NOT correct concerning database design?
a)
A. Identify all fields needed to produce the required information
b)
B. Organize each piece of data into its largest useful part
c)
C. Group related fields into tables
d)
D. Determine each table’s primary key
34.
Which of the following are complete sets of data and are the rows of the table?
a)
A. Files
b)
B. Fields
c)
C. Queries
d)
D. Records
35.
Which of the following is a single piece of information in a table?
a)
A. Field
b)
B. Record
c)
C. Record set
d)
D. Query
36.
Which of the following views allows you to build the structure of the table but not enter data in the records?
a)
A. Datasheet
b)
B. Design
c)
C. Layout
d)
D. Report
37.
Which of the following is a field whose value uniquely identifies each record in a table?
a)
A. Main key
b)
B. Primary key
c)
C. Element key
d)
D. Value key
38.
Which of the following is a database object which allows you to ask the database about the information it contains?
a)
A. Filter
b)
B. Query
c)
C. Sort
d)
D. Report
39.
Which of the following is a database object you can use to enter, edit or display data from a table or query?
a)
A. Report
b)
B. Filter
c)
C. Sort
d)
D. Form
40.
Which of the following tabs on the Ribbon contains the command to import data from an Excel workbook?
a)
A. Home
b)
B. Create
c)
C. Database Tools
d)
D. External Data
41.
Which tab contains the ability to open the Query Wizard?
a)
A. Home
b)
B. File
c)
C. Database Tools
d)
D. Create
42.
Which tab holds the option to back up a database?
a)
A. Home
b)
B. Create
c)
C. File
d)
D. External Data
43.
Microsoft® Publisher is best described as which of the following types of programs?
a)
A. Word processing
b)
B. Desktop publishing
c)
C. Graphics
d)
D. Database
44.
Which of the following can serve as a template for the pages in your publication?
a)
A. Header
b)
B. Footer
c)
C. Text box
d)
D. Master Page
45.
Which of the following is a Publisher file containing the colors, background format, font styles and accent colors for a publication?
a)
A. Master Page
b)
B. Design
c)
C. Style
d)
D. Template
46.
Which of the following is a container for text in a publication?
a)
A. Layout
b)
B. Business information set
c)
C. Text box
d)
D. Placeholder
47.
Which of the following is the ability of the text to be around a graphic in a publication?
a)
A. Word wrapping
b)
B. Arrangement
c)
C. Design
d)
D. Text wrapping
48.
Which of the following CANNOT be added to a publication?
a)
A. Pictures
b)
B. Text
c)
C. Videos
d)
D. Shapes
49.
A shape can function as a text box.
a)
A. True
b)
B. False
50.
Amado would like to have all of the shapes in his publication be able to be formatted or moved as one object. He should do which of the following?
a)
A. Apply text wrapping
b)
B. Group the objects
c)
C. Link the shapes together like text boxes
d)
D. Merge the layers
Reset
