Question 1

Which of the following is not one of the recommendations when first designing a spreadsheet?

Accepted Answer

A) Decide what your purpose is 
B) Decide what inputs you will need 
C) Estimate the amount of time required to complete the spreadsheet 
D) Decide what outputs you will need 
A) Decide what your purpose is 
B) Decide what inputs you will need 
C) Estimate the amount of time required to complete the spreadsheet 
D) Decide what outputs you will need

Question 2

The cell at row 4 and column B, would be identified as 4B.

Accepted Answer

A) True 
 B)False

Question 3

What can you not do from the Page Setup, Sheet tab?

Accepted Answer

A) Set margins 
B) Set a print area 
C) Print gridlines 
D) Change the page order 
A) Set margins 
B) Set a print area 
C) Print gridlines 
D) Change the page order

Question 4

Which of the following is not a valid number format?

Accepted Answer

A) $1,000.00 
B) $ 1,000.000 
C) (1,000.00) 
D) $ -1,000.00 
A) $1,000.00 
B) $ 1,000.000 
C) (1,000.00) 
D) $ -1,000.00

Question 5

Where can you find more alignment options?

Accepted Answer

A) Format Cells dialog box 
B) Format Alignment dialog box 
C) Format dialog box 
D) Format Rows and Columns dialog box 
A) Format Cells dialog box 
B) Format Alignment dialog box 
C) Format dialog box 
D) Format Rows and Columns dialog box

Question 6

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

Accepted Answer

The answer of The ________ area contains the formulas which...

Question 7

What should you do if there are columns you need, but do not want to display?

Accepted Answer

A) Delete the columns you do not want to display then undo your action when finished. 
B) Move the columns you want to see so that they are together then move them back to their original locations with finished. 
C) Cut and paste the columns you do not want to display to another area of the worksheet. 
D) Hide the columns you do not want to display, then unhide them when finished. 
A) Delete the columns you do not want to display then undo your action when finished. 
B) Move the columns you want to see so that they are together then move them back to their original locations with finished. 
C) Cut and paste the columns you do not want to display to another area of the worksheet. 
D) Hide the columns you do not want to display, then unhide them when finished.

Question 8

New workbooks typically contain how many worksheets?

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 3 
A) 0 
B) 1 
C) 2 
D) 3

Question 9

One point is how big?

Accepted Answer

A) 1\72 of an inch 
B) 1\36 of an inch 
C) The same as a pixel 
D) The same as one character 
A) 1\72 of an inch 
B) 1\36 of an inch 
C) The same as a pixel 
D) The same as one character

Question 10

Bottom Align is the default vertical alignment.

Accepted Answer

A) True 
 B)False

Question 11

Make sure to enter all cell reference in upper case when putting them in formulas.

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ is a group of cells which have been selected at the same time.

Accepted Answer

The answer of A(n)________ is a group of cells which...

Question 13

Match the following terms with their description:
I. Name Box
II. Order of operations
III. Formula
IV. Fill handle
V. Pointing
A. Always begins with an equals sign (=)
B. Small green square used to perform various actions
C. Displays the address of the active cell
D. Also known as semi-selection
E. PEMDAS

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 14

In the formula, =1+(2-3)+5\6-6^2, what will Excel evaluate first?

Accepted Answer

A) 5\6 
B) 1+ 
C) (2-3) 
D) 6^2 
A) 5\6 
B) 1+ 
C) (2-3) 
D) 6^2

Question 15

When cells are merged, the merged cell's address becomes the address of the range.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not a valid Cell Style?

Accepted Answer

A) Heading 5 
B) Accent 3 
C) Input 
D) Calculation 
A) Heading 5 
B) Accent 3 
C) Input 
D) Calculation

Question 17

Where is the Show Formulas command found?

Accepted Answer

A) Formula Auditing group on the Formulas tab 
B) Formula Auditing group on the Data tab 
C) Formula Auditing group on the Review tab 
D) Formula Auditing group on the Developer tab 
A) Formula Auditing group on the Formulas tab 
B) Formula Auditing group on the Data tab 
C) Formula Auditing group on the Review tab 
D) Formula Auditing group on the Developer tab

Question 18

The ________ feature allows you to move some text to another line in the same row.

Accepted Answer

The answer of The ________ feature allows you to move...

Question 19

In Excel, columns are identified by numbers and rows by letters.

Accepted Answer

A) True 
 B)False

Question 20

When you insert rows or columns all relative references are updated but not any absolute references.

Accepted Answer

A) True 
 B)False

Which of the following is not one of the recommendations when first designing a spreadsheet?

The cell at row 4 and column B, would be identified as 4B.

What can you not do from the Page Setup, Sheet tab?

Which of the following is not a valid number format?

Where can you find more alignment options?

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

What should you do if there are columns you need, but do not want to display?

New workbooks typically contain how many worksheets?

One point is how big?

Bottom Align is the default vertical alignment.

Make sure to enter all cell reference in upper case when putting them in formulas.

A(n)________ is a group of cells which have been selected at the same time.

In the formula, =1+(2-3)+5\6-6^2, what will Excel evaluate first?

When cells are merged, the merged cell's address becomes the address of the range.

Which of the following is not a valid Cell Style?

Where is the Show Formulas command found?

The ________ feature allows you to move some text to another line in the same row.

In Excel, columns are identified by numbers and rows by letters.

When you insert rows or columns all relative references are updated but not any absolute references.

Access: Introduction to Access

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters

Exam 5: Excel : Introduction to Excel

Which of the following is not one of the recommendations when first designing a spreadsheet?

The cell at row 4 and column B, would be identified as 4B.

What can you not do from the Page Setup, Sheet tab?

Which of the following is not a valid number format?

Where can you find more alignment options?

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

What should you do if there are columns you need, but do not want to display?

New workbooks typically contain how many worksheets?

One point is how big?

Bottom Align is the default vertical alignment.

Make sure to enter all cell reference in upper case when putting them in formulas.

A(n)________ is a group of cells which have been selected at the same time.

In the formula, =1+(2-3)+5\6-6^2, what will Excel evaluate first?

When cells are merged, the merged cell's address becomes the address of the range.

Which of the following is not a valid Cell Style?

Where is the Show Formulas command found?

The ________ feature allows you to move some text to another line in the same row.

In Excel, columns are identified by numbers and rows by letters.

When you insert rows or columns all relative references are updated but not any absolute references.

Access: Introduction to Access

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters