Question 1

Match between columns
                        Premises: Formula bar
Status bar
Cancel
Zoom control
Enter

Accepted Answer

The Answer of Shows the contents of the active cell is...

Question 2

Which of the following is not included when you use a cell style?

Accepted Answer

A) Font 
B) Cell protection 
C) Alignment 
D) Borders 
A) Font 
B) Cell protection 
C) Alignment 
D) Borders

Question 3

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 4

A(n)________ is a collection of one or more related worksheets.

Accepted Answer

workbook,s

Question 5

A(n)________ is a type of file that organizes data in rows and columns.

Accepted Answer

The answer of A(n)________ is a type of file that...

Question 6

Where would you find the command to center the printout both horizontally and vertically on your paper?

Accepted Answer

A) On the Page Setup,Alignment tab 
B) On the Page Setup,Sheet tab 
C) On the Page Setup,Margins tab 
D) On the Page Setup,Page tab 
A) On the Page Setup,Alignment tab 
B) On the Page Setup,Sheet tab 
C) On the Page Setup,Margins tab 
D) On the Page Setup,Page tab

Question 7

The ________ feature displays any values in the column that match what the user has typed so far.

Accepted Answer

AutoComple

Question 8

The intersection between a column and a row is called a(n)________.

Accepted Answer

The answer of The intersection between a column and a...

Question 9

The ________ feature allows you to see how a document would print before you actually print it.

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The fill handle allows you to copy and paste formulas to adjacent cells.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Home
File
View
Insert
Data

Accepted Answer

The Answer of Alt + N and Alt + A is...

Question 13

Match between columns
                        Premises: Range
Value
XFD
Text
Semi-selection

Accepted Answer

The Answer of A group of cells selected at the is...

Question 14

The best way to apply Page Setup options to multiple worksheets is to ________.

Accepted Answer

A) group the worksheets 
B) use the Format Painter 
C) copy and Paste the formatting codes from one sheet to another 
D) use the Apply to Selected Sheets formatting command 
A) group the worksheets 
B) use the Format Painter 
C) copy and Paste the formatting codes from one sheet to another 
D) use the Apply to Selected Sheets formatting command

Question 15

The default number format is ________.

Accepted Answer

A) Number 
B) Left aligned 
C) Two decimal places 
D) General 
A) Number 
B) Left aligned 
C) Two decimal places 
D) General

Question 16

Match between columns
                        Premises: Page Down
End
Home
Ctrl + Home
Right arrow

Accepted Answer

The Answer of This does nothing by itself and Moves is...

Question 17

Number ________ controls how a value appears in a cell.

Accepted Answer

The answer of Number ________ controls how a value appears...

Question 18

What does pressing the Enter key while in a cell,do?

Accepted Answer

A) The value is set,and the active cell remains the active cell 
B) The value is set,and the cell to the right becomes the active cell 
C) The value is set,and the cell below becomes the active cell 
D) The value is set,and the action is the same as pressing the Tab key 
A) The value is set,and the active cell remains the active cell 
B) The value is set,and the cell to the right becomes the active cell 
C) The value is set,and the cell below becomes the active cell 
D) The value is set,and the action is the same as pressing the Tab key

Question 19

It is acceptable to use values in formulas when you know those values will never change.

Accepted Answer

A) True 
 B)False

Question 20

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

Which of the following is not included when you use a cell style?

Where can you find more alignment options?

A(n)________ is a collection of one or more related worksheets.

A(n)________ is a type of file that organizes data in rows and columns.

Where would you find the command to center the printout both horizontally and vertically on your paper?

The ________ feature displays any values in the column that match what the user has typed so far.

The intersection between a column and a row is called a(n)________.

The ________ feature allows you to see how a document would print before you actually print it.

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

The fill handle allows you to copy and paste formulas to adjacent cells.

The best way to apply Page Setup options to multiple worksheets is to ________.

The default number format is ________.

Number ________ controls how a value appears in a cell.

What does pressing the Enter key while in a cell,do?

It is acceptable to use values in formulas when you know those values will never change.

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

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 1: Introduction to Excel

Which of the following is not included when you use a cell style?

Where can you find more alignment options?

A(n)________ is a collection of one or more related worksheets.

A(n)________ is a type of file that organizes data in rows and columns.

Where would you find the command to center the printout both horizontally and vertically on your paper?

The ________ feature displays any values in the column that match what the user has typed so far.

The intersection between a column and a row is called a(n)________.

The ________ feature allows you to see how a document would print before you actually print it.

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

The fill handle allows you to copy and paste formulas to adjacent cells.

The best way to apply Page Setup options to multiple worksheets is to ________.

The default number format is ________.

Number ________ controls how a value appears in a cell.

What does pressing the Enter key while in a cell,do?

It is acceptable to use values in formulas when you know those values will never change.

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

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters