Business Information Management II - Semester 1 Exam

1. Which of the following are composed of a grid system of rows and columns which cross to make cells?

• A. Worksheets
• B. Table guides
• C. Graphs
• D. Formulas

2. Which of the following shows the location of the cell which you have selected?

• A. Formula bar
• B. Cell name box
• C. Worksheet tab
• D. Dialog box

3. Which group on the Page Layout tab contains the commands to adjust the margins and page orientation of a worksheet?

• A. Themes
• B. Page Setup
• C. Scale to Fit
• D. Sheet Options

4. Which of the following groups on the Home tab contains the command to insert a worksheet?

• A. Cells
• B. Font
• C. Alignment
• D. Number

5. Backstage View can be reached by clicking on which tab of the Ribbon?

• A. File
• B. Home
• C. Insert
• D. Page Design

6. Karl wants to change the page orientation of the printed worksheet. Which group on the Page Layout tab contains the command to complete this action?

• A. Themes
• B. Scale to Fit
• C. Sheet Options
• D. Page Setup

7. Which of the following appears around cells which have been copied?

• A. Stationary blue and white dotted lines
• B. Moving red and white dotted lines
• C. Moving green and white dotted lines
• D. Stationary red and white dotted lines

8. Which of the following is NOT a method of changing the height of a row?

• A. Dragging the bottom border of the row to a different location
• B. Selecting the row and pressing the up arrow
• C. Clicking the Format icon and choosing the Row Height option and changing the height
• D. Clicking the Format icon and choosing the AutoFit Row Height option

9. Which of the following is NOT a viewing option for a worksheet?

• A. Normal
• B. Page Layout
• C. Page Break Preview
• D. Gridline

10. Which tab and group on the Ribbon holds the command to change the font of the text of the cells of a worksheet?

• A. Home tab, Paragraph group
• B. Home tab, Font group
• C. Home tab, Editing group
• D. Page Layout tab, Paragraph group