Bus Tech- Excel Assessment

Question 1

Why are formulas used in Excel?

Accepted Answer

To calculate a variety of mathematical outputs

Question 2

What must you follow when creating complex formulas?

Accepted Answer

Order of operations

Question 3

How do you center words in an Excel Spreadsheet

Accepted Answer

Click Merge & Center

Question 4

Formulas in Excel begin with what?

Accepted Answer

=

Question 5

In a complex formula you will perform the task in parenthesis first.

Accepted Answer

True

Question 6

Which are not a mathematical operation?

Accepted Answer

@, ?

Question 7

B3 is called a Cell Reference?

Accepted Answer

True

Question 8

Which of the following are Constants?

Accepted Answer

Months in a year, Number of days in a year, Days of the week

Question 9

By clicking Format you are able to adjust the row height and column width.

Accepted Answer

True

Question 10

Using a calculator will create a formula

Accepted Answer

False

Questions 10