Exam 2015, questions and answers - excel test PDF

Preview

Summary

Excel Test...

Description

Multiple Choice Question 1:

a. (1 Point) b. c. d.

Question 2:

(1 Point) a. b. c. d.

Question 3:

a. b. (1 Point) c. d.

Question 4:

a. (1 Point) b. c. d.

Question 5:

What is an option for enhancing tab colors?

Icons Abstract Colors Theme Colors Function Colors

What is a preconstructed formula that makes difficult computations less complicated?

Style Feature Function Algorithm

What button is clicked to select all elements of the worksheet? Select All Button Task Bar Active cell Name Box

What is known as the cell the user is working in and where information or data will be inputted? Task cell Formula Bar Active cell Name Box

By default, how many sheet tabs does a workbook contain?

a. b. (1 Point) c. d.

3 2 1 4

Which of the following is the computerized equivalent of a ledger?

Question 6:

a. b. (1 Point) c. d.

Brochure Document Spreadsheet Database

What cell reference stays the same no matter where a formula is copied?

Question 7:

a. (1 Point) b. c. d.

Mixed Relative Absolute Abstract

What appears in a cell when a comment has been inserted?

Question 8:

a. b. (1 Point) c. d.

Green Arrow Red Triangle Black Dashes Yellow Star

What is known as a single spreadsheet consisting of a grid columns and rows that often containing descriptive labels, numeric values, formulas, functions and graphics?

Question 9:

(1 Point) a. b. c. d.

Workbook Document Worksheet Cell

Question 10:

a. (1 Point) b. c. d.

Question 11:

(1 Point) a. b. c. d.

Question 12:

a. b. (1 Point) c. d.

Question 13:

a. b. c. (1 Point) d.

Question 14:

a. b. (1 Point) c. d.

What action allows the user to increase or decrease the width of a column?

Double click Right click Point to Single click

Which function returns one value when a condition is met and returns another value when the condition is not met?

IF MAX TODAY FIND

Which of the following refers to the rules for constructing the function? Syntax Algorithms Cube Types

What is designated by a column letter and a row number? Column designation Cell name Row listing Cell reference

Which shape is green and can be rotated by selecting it? Bullet Arrow Rotation handle Star

Question 15:

a. b. (1 Point) c. d.

Question 16:

a. b. (1 Point) c. d.

Question 17:

(1 Point) a. b. c. d.

Question 18:

a. b. (1 Point) c. d.

Question 19:

a. b. (1 Point) c.

Which Excel Window component is made of tabs, groups and commands? Task bar Reference Page Ribbon Office Menu

What is known as a group of related data points? Data roles Data points Data series Categories

What is a small black square found in the bottom right corner of an selected cell?

Insertion point Fill handle Sizing handle Pointer

Which feature automatically adjust the height and width of cells? QuickFormat Align AutoFit Resize

Where can a user enter or edit cell contents? Formula Bar GoTo Dialog box Task Bar

d.

Question 20:

a. b. (1 Point) c. d.

Question 21:

(1 Point) a. b. c. d.

Question 22:

(1 Point) a. b. c. d.

Question 23:

a. (1 Point) b. c. d.

Question 24:

Name Box

Which funtion counts the number of cells in a range that are not blank? COUNT MAX COUNTA ANALYZE

When comparing the content cells of a specific text, what must it be enclosed by?

Single quote marks Brackets Quotation marks Parentheses

Which Page orientation option prints horizontally across the page and is used when the worksheet is too wide to fit on a portrait page?

Portrait Landscape Life size Thumbnail

Which of the following can a Sheet Tab do?

Rearrange Restrain Rotate Invert

What performs mathematical operations that produce a calculated result?

a. b. c. (1 Point) d.

Question 25:

Program Macro Formula Procedure

Which function determines the highest value of all cells in a list of arguments?

(1 Point) a. b. c. d.

Question 26:

a. b. (1 Point) c. d.

Question 27:

(1 Point) a. b. c. d.

Question 28:

(1 Point) a.

MAX AVERAGE CALCULATE AutoSum

What is a rectangular group of cells? Range Macro Location Style

Which function looks up an answer from a vertical table of possible answers.

FIND VLOOKUP SEARCH HLOOKUP

Which of the following is known as the lowest numeric value for a category or series in a lookup table to produce a corresponding result for a lookup function? Results point

b. c. d.

Question 29:

Start point Breakpoint. Final point

What is an example of a formula?

a. (1 Point) b. c. d.

Question 30:

=A6 + Z35 4G * G1 A52 + 43 =55H ~ 3

Which function calculates the payment purchasing on a loan?

a. b. (1 Point) c. d.

IF TODAY PMT MIN

True and False Question 31:

(1 Points) Question 32:

(1 Points)

Question 33:

Logical functions help in decision making.

True False Data must be entered as values to be used in calculations.

True False Text and values are types of data that can be entered into an Excel worksheet.

(1 Points) True False Question 34:

(1 Points) Question 35:

To determine the number of cells in a range that contain numerical data, use the COUNTA function. True False The value that displays in the Name Box is the result of a formula calculation.

(1 Points) True False Question 36:

(1 Points) Question 37:

The fill handle is a small red triangle in the bottom corner of a selected cell.

True False Microsoft Excel can be considered an electronic version of a general ledger used by Accountants.

(1 Points) True False Question 38:

(1 Points)

Question 39:

The F2 key can be used to edit a cell as long as the cell has been selected.

True False Letters, numbers, symbols and space are considered text in Excel.

(1 Points) Question 40:

(1 Points)

True False The VLOOKUP function analyzes a value and looks up this value in a horizontal table to return a result.

True False...