Free Printable OSM II Diagnostic Assessment

1.

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

a)

a. MIN

b)

b. AVERAGE

c)

c. COUNT

d)

d. MAX

2.

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

a)

a. SUM

b)

b. COUNTA

c)

c. MIN

d)

d. MAX

3.

Which of the following can you not copy using Format Painter?

a)

a. Font color

b)

b. Bold

c)

c. Font size

d)

d. Cell content

4.

Which of the following is not useful for changing the font size?

a)

a. Font Size drop-down list

b)

b. Increase Font Size button

c)

c. Decrease Font Size button

d)

d. Increase Indent button

5.

Which of the following dialog boxes is used to transpose rows and columns?

a)

a. Page Setup

b)

b. Paste Special

c)

c. Column Width

d)

d. Row Height

6.

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

a)

a. It’s the easiest way to make a backup before making changes.

b)

b. It lets you reuse formats and formulas in a new sheet.

c)

c. It helps Excel learn where your data ranges are located.

d)

d. You should keep one worksheet hidden in case of an error.

7.

To render twice the normal amount of worksheet displayed for any given area of the screen, which of the following settings would you need to change the Zoom to?

a)

a. 200%

b)

b. 120%

c)

c. 75%

d)

d. 50%

8.

Which of the following functions automatically counts cells that meet a specific condition?

a)

a. COUNTIF

b)

b. COUNT

c)

c. COUNTIFS

d)

d. SUMIFS

9.

Which of the following functions returns one value if a condition is true and a different value when the condition is not true?

a)

a. AND

b)

b. OR

c)

c. IF

d)

d. SUM

10.

Adding, deleting, and viewing comments are performed from the commands on which ribbon tab?

a)

a. Comments

b)

b. Review

c)

c. File

d)

d. View

11.

Which of the following is the intersection of a row and column?

a)

a. range

b)

b. tab

c)

c. bar chart

d)

d. cell

12.

Which of the following is considered the strongest password?

a)

a. 02Feb2016 (your dog’s birthdate)

b)

b. DenVer (the city in which you were born, with odd capitalization)

c)

c. 679KrDj! (the last three digits of your social security or social insurance number and first names of each of your siblings with an exclamation point)

d)

d. BruinsO6 (your high school mascot and year you graduated using the letter O for a zero)

13.

Which chart type shows values as parts of a whole?

a)

a. Column

b)

b. Bar

c)

c. Area

d)

d. Pie

14.

Which of the following is the first step that should be taken when creating a chart?

a)

a. Providing a name for the chart

b)

b. Selecting the chart type

c)

c. Selecting the range of cells that contain the data the chart will use

d)

d. Choosing the data labels that will be used in the chart

15.

When drawing lines, which of the following statements accurately describes how to change line thickness?

a)

a. Right-click the line and choose Thickness.

b)

b. In the Shape Outline menu, select Weight.

c)

c. You must set the thickness before drawing the line.

d)

d. In the Shapes menu, select the Thicker Line option.

16.

The Shape Styles group is found on which of the following tabs?

a)

a. Insert

b)

b. Drawing Tools Format

c)

c. Home

d)

d. Styles

17.

Which of the following buttons is clicked to apply a shadow to a shape or line?

a)

a. Shape Effects

b)

b. Picture Effects

c)

c. Artistic Effects

d)

d. 3D Effects

18.

Which of the following consists of details that describe or identify a file, including the author?

a)

a. Paste

b)

b. Document properties

c)

c. Copy

d)

d. Range

19.

Which command is used to insert a cut or copied selection to a cell or range of cells?

a)

a. Paste

b)

b. Document properties

c)

c. Copy

d)

d. Range

20.

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

a)

a. Backstage

b)

b. Print

c)

c. Edit

d)

d. Windows

21.

Which predesigned file already has a significant amount of formatting, text, and other features?

a)

a. Blank workbook

b)

b. Preset file

c)

c. Text file

d)

d. Template

22.

Which of the following can be customized for quicker access to your most commonly used commands?

a)

a. Print Preview

b)

b. Quick Access Toolbar

c)

c. Printer setup

d)

d. Workbook

23.

Per the order of operations, which of the following is calculated first?

a)

a. Addition (+) and subtraction (−) (left to right)

b)

b. Exponentiation (ˆ)

c)

c. Percent (%)

d)

d. Negative number (−)

24.

Which of the following is an example of an absolute cell reference?

a)

a. A9

b)

b. A$9

c)

c. $A$9

d)

d. A9:E9

OSM II Diagnostic Assessment

Total questions: 24

Worksheet time: 12mins

Similar Resources on Wayground