Excel Formula, Functions and Working with Data Test Prep

Question 1

If data is organized A-Z that means it is sorted in what order?

Accepted Answer

Ascending

Question 2

What keyboard combination can you use to display the formula you entered instead of the result?

Accepted Answer

Ctrl + `

Question 3

A more complex formula has?

Accepted Answer

Multiple mathematical operators

Question 4

You should double check your formula to make sure it is calculating data correctly.

Accepted Answer

True

Question 5

You have to start a formula or function with?

Accepted Answer

Equals sign

Question 6

Which feature allows you to automatically insert the most common functions into your formula?

Accepted Answer

AutoSum

Question 7

What type of sort can you choose to be able to sort multiple columns by specific values?

Accepted Answer

Custom Sort

Question 8

Addition

Accepted Answer

+

Question 9

What feature in Excel makes you easily visualize comparisons and trends of data?

Accepted Answer

Charts

Question 10

When you use the filter option you are doing what to your data?

Accepted Answer

Narrowing Down

Question 11

The formatting option that allows you to alternate row colors of a table is called?

Accepted Answer

banded rows

Question 12

If you are needed to “backup” (need to get out of a cell in Excel) you press what key?

Accepted Answer

Esc

Question 13

The benefit of a function instead of a formula is?

Accepted Answer

Performs multiple tasks more efficiently

Question 14

This function adds all of the values of the cells in the argument.

Accepted Answer

SUM

Question 15

On the design tab after clicking in a table what option will remove the formatting of a table?

Accepted Answer

Convert to range

Question 16

What method can you use to enter a formula easily?

Accepted Answer

Point and click

Question 17

Which of the following operations is done first in the order of operations?

Accepted Answer

Operations enclosed Parentheses

Question 18

The formatting option that alternates row colors of a table with one click is called?

Accepted Answer

Banded row

Question 19

The difference between the syntax of a function and a formula is that a function has?

Accepted Answer

Equals sign, Function name

Question 20

The difference between the syntax of a function and a formula is that a function has?

Accepted Answer

Function name

Question 21

When entering a formula cell addresses have to be typed in.

Accepted Answer

False

Question 22

Division

Accepted Answer

/

Question 23

What can you select to format all the cells fill and text color to your table with one click?

Accepted Answer

Table Styles

Question 24

What should you reference in a formula to automatically update your spreadsheet values?

Accepted Answer

Cell address

Question 25

Subtraction

Accepted Answer

-

Question 26

The data points are connected with lines, making it easy to see whether increases and decreases

Accepted Answer

Line Charts

Question 27

The easy way to remember the order of operations is?

Accepted Answer

PEMDAS

Question 28

Multiplication

Accepted Answer

*

Question 29

This function determines the lowest cell value included in the argument.

Accepted Answer

MIN

Question 30

The fill handle is not able to be used for formulas

Accepted Answer

False

Question 31

You can edit a formula anytime by?

Accepted Answer

Double clicking the cell

Question 32

Parenthesis can affect the overall result of a formula.

Accepted Answer

True

Question 33

If you have ####### in a cell this means that?

Accepted Answer

Columns widths are too narrow

Question 34

Exponents

Accepted Answer

^

Excel Formula, Functions and Working with Data Test Prep

Questions 34

Excel Formula, Functions and Working with Data Test Prep

Questions 34