Exam 8: Using Complex Formulas, Functions, and Tables

You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale. How can you change the color of the cells that contain values under one dollar in the lowest priced column?

(Essay)

4.8/5

(42)

Question 41

Functions save time and help ensure accuracy, and they are available for both simple calculations and extremely complex ones.

(True/False)

4.9/5

(39)

Question 42

There are four parts to every formula

(True/False)

4.9/5

(34)

Question 43

As in database tables, Excel table columns are often called ____.

(Multiple Choice)

4.8/5

(35)

Question 44

____ formulas perform more than one calculation at a time.

(Multiple Choice)

4.9/5

(38)

Question 45

Formulas that contain more than one operator are called ____________________ formulas.

(Short Answer)

4.8/5

(41)

Question 46

Functions are prewritten formulas that come with Excel

(True/False)

4.8/5

(22)

Question 47

Which of the following is NOT a conditional formatting option?

(Multiple Choice)

4.7/5

(40)

Question 48

List the six common categories of functions in Microsoft Excel.

(Essay)

4.9/5

(31)

Question 49

When a formula contains multiple operators, Excel uses standard algebraic rules to determine which calculation to perform first.

(True/False)

4.7/5

(31)

Question 50

Excel ____________________ let you manage and analyze rows of data that have the same kind of information.

(Short Answer)

4.9/5

(35)

Question 51

Formula AutoComplete is a feature that offers a list of valid functions and names beginning with the letter that you type following the = sign.

(True/False)

4.8/5

(26)

Question 52

The _________ gallery contains popular conditional formatting options like data bars and color scales.

(Multiple Choice)

4.8/5

(33)

Question 53

Excel allows you to analyze a separate range of worksheet data in a(n) ____.

(Multiple Choice)

4.7/5

(39)

Question 54

You can identify the largest value in a range of cells using the ____________________ function.

(Short Answer)

4.7/5

(31)

Question 55

The TODAY function requires no arguments

(True/False)

4.9/5

(29)

Question 56

When you are ready to specify criteria in the list of available filters, you click the _____ check box to first remove all of the existing check marks.

(Multiple Choice)

4.7/5

(45)

Question 57

Once you've written a complex formula, you can drag it to adjacent cells using the fill handle pointer.

(True/False)

4.8/5

(36)

Question 58

An absolute cell reference contains a # symbol before the column letter and row number.

(True/False)

4.9/5

(39)

Question 59

Date & Time functions are available in the Date & Time Library group

(True/False)

4.9/5

(28)

Question 60

Showing 41 - 60 of 66

Functions save time and help ensure accuracy, and they are available for both simple calculations and extremely complex ones.

There are four parts to every formula

As in database tables, Excel table columns are often called ____.

____ formulas perform more than one calculation at a time.

Formulas that contain more than one operator are called ____________________ formulas.

Functions are prewritten formulas that come with Excel

Which of the following is NOT a conditional formatting option?

List the six common categories of functions in Microsoft Excel.

When a formula contains multiple operators, Excel uses standard algebraic rules to determine which calculation to perform first.

Excel ____________________ let you manage and analyze rows of data that have the same kind of information.

Formula AutoComplete is a feature that offers a list of valid functions and names beginning with the letter that you type following the = sign.

The _________ gallery contains popular conditional formatting options like data bars and color scales.

Excel allows you to analyze a separate range of worksheet data in a(n) ____.

You can identify the largest value in a range of cells using the ____________________ function.

The TODAY function requires no arguments

When you are ready to specify criteria in the list of available filters, you click the _____ check box to first remove all of the existing check marks.

Once you've written a complex formula, you can drag it to adjacent cells using the fill handle pointer.

An absolute cell reference contains a # symbol before the column letter and row number.

Date & Time functions are available in the Date & Time Library group

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters