WorksheetsBusiness Information Management II - Semester 2 Exam
Total questions: 50
Worksheet time: 25mins
Name
Class
Date
1.
The option to print a document is found in which of the following locations?
a)
A. Backstage View
b)
B. Home Tab
c)
C. Review Tab
d)
D. Page Layout Tab
2.
Which of the following is NOT a method to delete text?
a)
A. Pressing the Control and A keys and pressing delete
b)
B. Pressing the Control and X keys
c)
C. Selecting the text and pressing the backspace key
d)
D. Pressing the Control and A keys and pressing backspace
3.
Which of the following is the keyboard shortcut for saving a document?
a)
A. Control S
b)
B. Control A
c)
C. Control V
d)
D. Control E
4.
Which of the following is NOT a method which can be used to make a document a PDF?
a)
A. Use the Save As option and select PDF
b)
B. Use the Export option and select create PDF/XPS
c)
C. Use the Share option and select Send as a PDF
d)
D. Use the Open Option and select Open as PDF
5.
Which of the following groups of tabs both hold the command for inserting a page break?
a)
A. Home and Page Layout
b)
B. Design and Insert
c)
C. Page Layout and Insert
d)
D. Design and Page Layout
6.
Which of the following tabs contains the commands to start a mail merge?
a)
A. Home
b)
B. Insert
c)
C. Mailings
d)
D. Developer
7.
Which of the following is used in a mail merge as a placeholder in the main document where a piece of information from the data source will be entered?
a)
A. Merge field
b)
B. Control
c)
C. Record set
d)
D. List box
8.
Which of the following file extensions is a Word template saved as?
a)
A. .doc
b)
B. .wtem
c)
C. .dotx
d)
D. .temp
9.
You want to add a page number to the bottom of each page of your document. Which tab holds the command for this task?
a)
A. Home
b)
B. Insert
c)
C. Design
d)
D. Page Layout
10.
Raj has three shapes in his document and he would like to be able to format and move all of the shapes like they are one object. Which of the following should he do?
a)
A. Link the shapes like text boxes
b)
B. Group the shapes
c)
C. Save the shapes as an image
d)
D. Arrange the shapes so they all appear at the front of the document
11.
Which of the following are labels used to identify illustrations such as tables, charts and figures in a document?
a)
A. Headers
b)
B. Footers
c)
C. Citations
d)
D. Captions
12.
Ivan wants to mark his report as a draft by adding the text “DRAFT” to the background pages of the report. Which of the following commands on the Design tab should he use?
a)
A. Page Color
b)
B. Page Borders
c)
C. Watermark
d)
D. Effects
13.
Which of the following options must be selected in Backstage View to show the button which is used to open the menu which contains the command to run the Document Inspector?
a)
A. Info
b)
B. New
c)
C. Print
d)
D. Export
14.
Which of the following buttons should be clicked to open the menu which contains the command to run the Accessibility Checker?
a)
A. Protect Document
b)
B. Inspect Document
c)
C. Manage Document
d)
D. Export Document
15.
Which of the following is NOT a type of hidden data?
a)
A. Comments
b)
B. Document properties
c)
C. Paragraph styles
d)
D. Hidden text
16.
Which of the following tabs contains the command to compare two versions of a document?
a)
A. Home
b)
B. Review
c)
C. Mailings
d)
D. References
17.
Which of the following paste options should be used to make the content match the formatting of the document it was pasted into?
a)
A. Keep Source Formatting
b)
B. Keep Text Only
c)
C. Merge Formatting
d)
D. Format Painter
18.
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
19.
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
20.
Which command on the Home tab should be clicked to open the menu which contains the command to reuse slides?
a)
A. Layout
b)
B. New Slide
c)
C. Arrange
d)
D. Insert
21.
Which of the following panes contains slides which can be added to a presentation?
a)
A. Notes
b)
B. Reuse Slides
c)
C. Animation
d)
D. Slide Master
22.
Which of the following commands should be chosen from the New Slide menu to create slides based on a Word outline?
a)
A. Slides from Outline
b)
B. Reuse Slides
c)
C. Outline Layout
d)
D. Outline Template
23.
Which of the following commands in the Export option of Backstage View can be used to develop a Word outline from a presentation?
a)
A. Create PDF/XPS Document
b)
B. Change File Type
c)
C. Package Presentation for CD
d)
D. Create Handouts
24.
Barry is reviewing a presentation and wants to insert a comment on a slide. Which of the following should he do?
a)
A. Click the Comment icon in the Comments group on the Insert tab
b)
B. Right-click on the slide and choose New Comment from the menu
c)
C. Clicking Show Comments in the Comments group on the Review tab
d)
D. Clicking Compare in the Compare group on the Review tab
25.
Carlos has received reviews from his peers on his presentation and would like to merge the presentations so he can see their comments and changes all in one location. Which of the following should Carlos do to begin this process?
a)
A. Click Merge on the Review tab
b)
B. Click Compare on the Review tab
c)
C. Click Merge on the Slide Show tab
d)
D. Click Compare on the Insert tab
26.
Which of the following is the file extension for a PowerPoint presentation created in Microsoft® PowerPoint® 2016?
a)
A. .ppt
b)
B. .pptx
c)
C. .ppt16
d)
D. .ppts
27.
The commands to save a file as a PowerPoint show is located in which portion of Backstage View?
a)
A. New
b)
B. Export
c)
C. Options
d)
D. Slide Show
28.
Which of the following file types, when opened, automatically shows the presentation in Slide Show view?
a)
A. PowerPoint Show
b)
B. Presentation
c)
C. Compatibility Mode
d)
D. Presentation Template
29.
Caroline is going to be presenting her slide show on a computer at a conference. Which of the following would be the best method for her to save her presentation to ensure she can show her presentation on the computer?
a)
A. Save as a PDF document
b)
B. Package the presentation to a CD
c)
C. Change the file type to compatibility mode
d)
D. Save the presentation as a template
30.
Which of the following tabs holds the commands to change the worksheet views?
a)
A. File
b)
B. Home
c)
C. View
d)
D. Data
31.
Which of the following is the correct order of operations completed in formulas?
a)
A. Parentheses, Multiplication, Division, Exponents, Addition, then Subtraction
b)
B. Parentheses, Exponents, Division, Multiplication, Addition, then Subtraction
c)
C. Parentheses, Multiplication, Exponents, Division, Addition, then Subtraction
d)
D. Parentheses, Exponents, Multiplication, Division, Addition, then Subtraction
32.
Which of the following functions adds the data found in cells A1 through A4?
a)
A. =SUM(A1,A4)
b)
B. =SUM(A1:A4)
c)
C. =SUM(A1+A4)
d)
D. =SUMA1A4
33.
Which of the following is the range of cells which contain the data you want displayed in the chart?
a)
A. Data source
b)
B. Graphing source
c)
C. Data index
d)
D. Chart index
34.
Which of the following is a chart in the background of a cell?
a)
A. Comments
b)
B. Mini-chart
c)
C. Sparkline
d)
D. Trendline
35.
Alex wants to add a text box to a worksheet. Which tab contains this command?
a)
A. Insert
b)
B. Developer
c)
C. Data
d)
D. Review
36.
Which of the following applies formatting to cells depending upon the contents of the cells?
a)
A. Conditional formatting
b)
B. Conditional sorting
c)
C. Filters
d)
D. Style sets
37.
Which of the following opens when the Manage Rules option is clicked in the Conditional Formatting menu?
a)
A. Conditional Formatting Rules Manager dialog box
b)
B. Conditional Formatting Selection dialog box
c)
C. New Rules dialog box
d)
D. New Rules manager dialog box
38.
In order to create a chart, which of the following must be selected?
a)
A. Data tools
b)
B. Worksheet tab
c)
C. Data source
d)
D. Table styles
39.
Brandon wants to add a legend to his chart. Which of the following should he click to add this item?
a)
A. Quick Style
b)
B. Add Chart Element
c)
C. Shape Styles
d)
D. WordArt Styles
40.
Which group on the Chart Tools Design tab holds the command for switching row and column data?
a)
A. Data
b)
B. Chart Layouts
c)
C. Chart Styles
d)
D. Location
41.
Javier would like to print his chart along with the data in the worksheet. Which of the following should he do?
a)
A. Make sure the chart is NOT selected in the worksheet and press Control P and click the Print button
b)
B. Make sure the chart is selected in the worksheet and press Control P and click the Print button
c)
C. Right-click on the chart and choose Print from the menu
d)
D. Right-click on the worksheet and choose Print from the menu
42.
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
43.
Which of the following is an absolute cell reference?
a)
A. A1
b)
B. A$1
c)
C. $A1
d)
D. $A$1
44.
Which of the following can be used to locate data in a particular column?
a)
A. VLOOKUP
b)
B. HLOOKUP
c)
C. CLOOKUP
d)
D. RLOOKUP
45.
Which of the following can be used to locate data in a particular row?
a)
A. VLOOKUP
b)
B. HLOOKUP
c)
C. CLOOKUP
d)
D. RLOOKUP
46.
Which group on the Table Tools Design tab holds the command for adding a Total Row to a table?
a)
A. Tools
b)
B. External Table Data
c)
C. Table Style Options
d)
D. Table Styles
47.
Which of the following structured references should be used to refer to the data in a table range?
a)
A. [#ALL]
b)
B. [#DATA]
c)
C. [#HEADERS]
d)
D. [#TOTALS]
48.
Kareem has created a spreadsheet for his company to use to file their expense reports. Which of the following file types should he save it as so his company can use it as a starting point for all of their future expense reports?
a)
A. Microsoft® Excel Template
b)
B. Single File Web Page
c)
C. Web Page
d)
D. PDF
49.
Which of the following is NOT true about importing data from Access?
a)
A. The data can be viewed in a table in Excel
b)
B. The data can be placed in a new worksheet
c)
C. The data cannot be saved as an Access database file type in Excel
d)
D. The data cannot be placed in the existing worksheet
50.
When importing from the web, which of the following opens the web page with the selector arrows next to items which can be imported?
a)
A. New Web Query window
b)
B. New Web Import dialog box
c)
C. New Rules window
d)
D. Import Text Wizard
100 %
