Exam 96: Functions

When you copy and paste a formula one cell below its current spreadsheet location,the cells referenced in the formula change to reflect its new location.This is an example of a(n)____.

(Multiple Choice)

4.9/5

(91)

Question 41

Given the formula =IF(X4="NO","CHARGE","FREE"),when the value of X4 is NO,the formula result is FREE.

(True/False)

4.9/5

(69)

Question 42

You are reviewing the screen results after clicking the Trace Precedents button in Excel.To hide the arrows appearing on the screen,you should click the ____________________ button on the Formulas tab.

(Short Answer)

4.8/5

(79)

Question 43

Excel provides five different counting functions.

(True/False)

4.9/5

(77)

Question 44

The result of the PMT function returns a(n)____________________ number that displays in a red font on the screen.

(Short Answer)

4.8/5

(86)

Question 45

When creating a VLOOKUP formula,the table range entry should be based on relative references so the formula produces correct results when copied to a new location.

(True/False)

4.9/5

(81)

Question 46

To determine the average score in a range of test scores,you should use the ____ function.

(Multiple Choice)

4.8/5

(85)

Question 47

Showing 41 - 47 of 47

Exam 96: Functions

When you copy and paste a formula one cell below its current spreadsheet location,the cells referenced in the formula change to reflect its new location.This is an example of a(n)____.

Given the formula =IF(X4="NO","CHARGE","FREE"),when the value of X4 is NO,the formula result is FREE.

You are reviewing the screen results after clicking the Trace Precedents button in Excel.To hide the arrows appearing on the screen,you should click the ____________________ button on the Formulas tab.

Excel provides five different counting functions.

The result of the PMT function returns a(n)____________________ number that displays in a red font on the screen.

When creating a VLOOKUP formula,the table range entry should be based on relative references so the formula produces correct results when copied to a new location.

To determine the average score in a range of test scores,you should use the ____ function.

Intellectual Property Rights

Digital Literacy

Windows 7 Navigating

Computing Platforms

Windows 7 File Management

Digital Life

Processing

Windows 8 Navigating

Storage

Windows 8 File Management

Input/Output (I/O)

Freedom of Speech

Software Development

Mac OS X Layout

System Software

Mac OS X Tools

Application Software

Mac OS X File Management

Managing Software

Privacy

Internet Technologies

Common Application Components

Web Technologies

Working with Files and Documents

Cloud Computing

Common Editing Functions

Web Resources

Common Formatting Functions

Working with Graphics

Working with Tables

Printing & Publishing

Sharing Content Between Applications

Collaborating with Office 2013

Customizing Office Applications

Ethics

Infrastructure

Overview of Word Processing

Cellular Network

Document Formatting Techniques

Wireless Data Communications

Academic Publishing Tools

Globalization

Machine-Level Security

Overview of Spreadsheets

Network Security

Cells and Cell Data

Internet Security

Formulas

Functions

Formatting Spreadsheets

Spreadsheet Graphics

Advanced Spreadsheet Tools

Digital Publications

Overview of PowerPoint

Digital Audio

Working with Slides and Text

Digital Graphics

Using Graphics Objects

Digital Photography

Formatting a Slide Show

Digital Video

Presenting and Publishing

Interactive Media

Database Structure

Overview of Databases

Database Tools

Database Tables

Industrial Databases

Data-sheets and Forms

Queries and Reports

E-commerce Implementation

Outlook