Computer Applications in Business 3 CFE Review

Where can you typically find the option to add a border to a cell in a spreadsheet program?

• Data Menu

• Format Menu

• Insert Menu

• View Menu

Which of the following is NOT a common option for shading a cell?

• Solid color

• Pattern

• Gradient

• Animated image

What is the primary purpose of adding a header or footer to a spreadsheet?

• To format cell values

• To add information that appears on every page

• To insert charts

• To apply formulas

Which of the following can typically be included in a header or footer?

• Formulas

• Page numbers

• Cell borders

• Graphs

Why might you rotate text in a cell?

• To change the font

• To fit long labels in narrow columns

• To apply shading

• To insert a picture

Which symbol is used for multiplication in most spreadsheet formulas?

• *

• x

• %

What does the formula "=A1+B1" do?

• Multiplies the values in cells A1 and B1

• Adds the values in cells A1 and B1

• Subtracts the value in cell B1 from the value in cell A1

• Divides the value in cell A1 by the value in cell B1

What is the order of operations in most spreadsheet formulas?

• Addition, Subtraction, Multiplication, Division

• Parentheses, Exponents, Multiplication and Division, Addition and Subtraction

• Left to Right

• Right to Left

Which formula correctly calculates (2 + 3) * 4?

• =2+3*4

• =(2+3)*4

• =2+(3*4)

• =4*(2+3)

Which function is used to find the average of a range of cells?

• MAX()

• MIN()

• AVG()

• AVERAGE()