NEW
Font size
S
M
L
XL
WorksheetsBusiness Information Management II - Semester 1 Exam
Total questions: 50
Worksheet time: 40mins
Name
Class
Date
1.
1. 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
2.
2. 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
3.
3. Which group on the Page Layout tab contains the commands to adjust the margins and page orientation of a worksheet?
a)
A. Themes
b)
B. Page Setup
c)
C. Scale to Fit
d)
D. Sheet Options
4.
4. Which of the following groups on the Home tab contains the command to insert a worksheet?
a)
A. Cells
b)
B. Font
c)
C. Alignment
d)
D. Number
5.
5. Backstage View can be reached by clicking on which tab of the Ribbon?
a)
A. File
b)
B. Home
c)
C. Insert
d)
D. Page Design
6.
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)
A. Themes
b)
B. Scale to Fit
c)
C. Sheet Options
d)
D. Page Setup
7.
7. Which of the following appears around cells which have been copied?
a)
A. Stationary blue and white dotted lines
b)
B. Moving red and white dotted lines
c)
C. Moving green and white dotted lines
d)
D. Stationary red and white dotted lines
8.
8. Which of the following is NOT a method of changing the height of a row?
a)
A. Dragging the bottom border of the row to a different location
b)
B. Selecting the row and pressing the up arrow
c)
C. Clicking the Format icon and choosing the Row Height option and changing the height
d)
D. Clicking the Format icon and choosing the AutoFit Row Height option
9.
9. Which of the following is NOT a viewing option for a worksheet?
a)
A. Normal
b)
B. Page Layout
c)
C. Page Break Preview
d)
D. Gridline
10.
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)
A. Home tab, Paragraph group
b)
B. Home tab, Font group
c)
C. Home tab, Editing group
d)
D. Page Layout tab, Paragraph group
11.
11. 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
12.
12. Which group on the Formulas tab holds the command to show the formulas in formula view?
a)
A. Function Library
b)
B. Defined names
c)
C. Formula Auditing
d)
D. Calculation
13.
13. Which tab and group contains the option for adding conditional formatting?
a)
A. Home tab, Font group
b)
B. Insert tab, Illustrations group
c)
C. Data tab, Data Tools group
d)
D. Home tab, Styles group
14.
14. Which tab and group on the Ribbon contains the option to add a header to a worksheet?
a)
A. Home tab, Styles group
b)
B. Home tab, Editing group
c)
C. Page Layout tab, Page Setup group
d)
D. Insert tab, Text group
15.
15.Which of the following can be used to copy the formatting applied to a cell?
a)
A. Format bar
b)
B. Format handle
c)
C. Format painter
d)
D. Format cell
16.
16. Which group on the Home tab contains the command for adding a filter?
a)
A. Cells
b)
B. Editing
c)
C. Styles
d)
D. Number
17.
17. 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
18.
18. 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
19.
19. Which of the following types of cell references should you use if you want the cell references in the formula to change to reflect the position of its copied location relative to its original location?
a)
A. Absolute
b)
B. Mixed
c)
C. Relative
d)
D. Stationary
20.
20. Which of the following is an absolute cell reference?
a)
A. A1
b)
B. A$1
c)
C. $A1
d)
D. $A$1
21.
21. All formulas must begin with which of the following symbols?
a)
A. Equals sign (=)
b)
B. Ampersand (&)
c)
C. Plus sign (+)
d)
D. Period (.)
22.
22. 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
23.
23. 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
24.
24. 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?
a)
A. +A1+B1*10
b)
B. .A1+B1*10
c)
C. =(A1+B1)*10
d)
D. &(A1+B1)*10
25.
25. Which of the following adds the values in cells A1 through A10?
a)
A. =SUM(A1:A10)
b)
B. =SUM(A1,A10)
c)
C. =SUM(A1!A10)
d)
D. =SUM($A1$A10)
26.
26. 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
27.
27. Alex wants to find the highest value in a range of cells. Which of the following functions should he use?
a)
A. =MIN( )
b)
B. =AVERAGE( )
c)
C. =MAX( )
d)
D. =MEDIAN( )
28.
28. 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( )
29.
29. Which of the following is a type of equation which returns a value such as TRUE or FALSE?
a)
A. Argument
b)
B. Expression
c)
C. Nest
d)
D. Control
30.
30. Which icon in the Function Library should be clicked to add the NOW function?
a)
A. AutoSum
b)
B. Date & Time
c)
C. Lookup & Reference
d)
D. More Functions
31.
31. The IF Function is an example of which type of function?
a)
A. Financial
b)
B. Text
c)
C. Date & Time
d)
D. Logical
32.
32. 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?
33.
33. Which of the following tabs contains the command for adding a chart to an Excel worksheet?
a)
A. File
b)
B. Home
c)
C. Insert
d)
D. Formulas
34.
34. 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
35.
35. 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
36.
36. 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
37.
37. 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
38.
38. C2 > H12
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
39.
39. L3 = G4
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
40.
40. M14 + 5 > L3 * 10
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
41.
41. H12 = M14 / 10
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
42.
42. C2/8 < L3
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
43.
43. L3 + 300 > M14*2
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
44.
44. L3*G4 < M14-H12
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
45.
45. C2-H12 = (L3*3)+1
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
46.
46. H12 > L3-4
Use the following cell addresses and values:
C2 = 88
G4 = 5
H12 = 15
L3 = 24
M14 = 150
a)
TRUE
b)
FALSE
47.
47. Write cell L23 as a relative reference.
a)
A. L23
b)
B. L$23
c)
C. $L23
d)
D. $L$23
48.
48. Write cell L23 as an absolute reference
a)
A. L23
b)
B. L$23
c)
C. $L23
d)
D. $L$23
49.
49. Write cell L23 as a mixed reference where the column varies
a)
A. L23
b)
B. L$23
c)
C. $L23
d)
D. $L$23
50.
50. Write cell L23 as a mixed reference where the row varies.
a)
A. L23
b)
B. L$23
c)
C. $L23
d)
D. $L$23
Reset
