Microsoft Excel

Question 1

__orientation means the page is horizontal.

Accepted Answer

Lanscape

Question 2

If a cell contains more text than can be displayed, use the __text command to display the info.

Accepted Answer

Wrap

Question 3

Fill color is applied to the __ of a cell.

Accepted Answer

Background

Question 4

You can also set your print area form the __tab.

Accepted Answer

Page Layout

Question 5

A compulsory contribution to state revenue, levied by the government on workers' income.

Accepted Answer

Tax

Question 6

Changing a word document into a PDF file is an example of ...

Accepted Answer

Conversion

Question 7

To change the order of worksheets in a workbook,__the tab to the new position.

Accepted Answer

Drag

Question 8

Choose the Save command, if you open an existing file in Excel & want to keep the original one.

Accepted Answer

False

Question 9

A list of goods sent or services provided, with a statement of the sum due for these; bill.

Accepted Answer

Invoice

Question 10

To group worksheets press and hold the__ key.

Accepted Answer

Ctrl

Question 11

To freeze a column, select the column to the left of the columns you want frozen.

Accepted Answer

False

Question 12

In order to drag and drop a selected group of cells, your mouse must change to ___.

Accepted Answer

a four-sided black cross with arrows

Question 13

In word processing, a facility allowing text to surround embedded features such as pictures.

Accepted Answer

Wrap Text

Question 14

Excel has an option to save Excel workbooks as a PDF.

Accepted Answer

True

Question 15

You can rename, move, or copy a worksheet by right-clicking on the sheet tab.

Accepted Answer

True

Question 16

Contains multiple tabs with groups of commands you will need to perform common tasks.

Accepted Answer

Ribbon

Question 17

All formulas must start with__.

Accepted Answer

an equal sign

Question 18

Currency is system of money in general use in a particular country.

Accepted Answer

True

Question 19

Fill Color is the coloring of cell or a range of cells with solid coloring or patterns.

Accepted Answer

True

Question 20

The data in the active cell can also be seen in the ____.

Accepted Answer

Formula bar

Question 21

The practice of overseeing and controlling of quantities of finished products for sale.

Accepted Answer

Inventory Mangement

Question 22

To unfreeze panes, click the __tab, click the freeze panes button, and select unfreeze panes.

Accepted Answer

View

Question 23

__orientation means the page is vertical.

Accepted Answer

Portrait

Question 24

Only standard colors are available on the Font color button.

Accepted Answer

False

Question 25

Gridlines are horizontal and vertical lines.

Accepted Answer

True

Question 26

To conveniently view the last files you opened in Excel, select__on the File tab.

Accepted Answer

Recent

Question 27

To create a new blank workbook click File tab select_, select blank workbook and click Create.

Accepted Answer

New

Question 28

COUNTA is a function that counts the number of cells that are not empty in a range.

Accepted Answer

True

Question 29

Another way to select a cell to include in a formula is the point-and-right click method.

Accepted Answer

False

Question 30

To edit a formula, you can double-click the cell or edit in the __.

Accepted Answer

Formula bar

Question 31

If you see pound sign (#####) in a cell, it means__.

Accepted Answer

your column is not wide enough

Question 32

To insert a row, select the row number above where you want the new row to appear.

Accepted Answer

False

Question 33

If pounds signs (####) appear instead of a value__.

Accepted Answer

increase the column width

Question 34

To center a title across multiple rows of information, select the range of cells that you want.

Accepted Answer

False

Question 35

PMD calculates the payment for a loan based on constant payment and a constant interest rate.

Accepted Answer

False

Question 36

To edit the size of a row or column, you can manually drag the border to adjust the size.

Accepted Answer

True

Question 37

The intersection of a column and a row is a_____.

Accepted Answer

Cell

Question 38

The new unit of study is Microsoft Excel.

Accepted Answer

True

Question 39

Uses formulas to count the numbers in the range A1:A20

Accepted Answer

COUNT

Question 40

A file format that allow anyone to view the contents of your workbook without Excel is called_.

Accepted Answer

pdf

Question 41

A complete list of items such as property, goods in stock, or the contents of a building...

Accepted Answer

Inventory

Question 42

=(A2*B2)+10

Accepted Answer

Formula

Question 43

Fill color is used to apply color to graphics such as a rectangle, circle or other shapes.

Accepted Answer

True

Question 44

Buttons for formatting numbers, dates, and text are located on the __tab.

Accepted Answer

Home

Question 45

To ungroup worksheets, right-click on all of the worksheets.

Accepted Answer

False

Question 46

When you click the Copy command, the border of the selected cell turns yellow?

Accepted Answer

False

Question 47

Merge & Center divides 2 or more cells in a spreadsheet or table into one cell.

Accepted Answer

False

Question 48

When a formula contains a cell address, it is called a __.

Accepted Answer

Cell reference

Question 49

You can change the page orientation from the page layout tab and the __tab.

Accepted Answer

File

Question 50

A spreadsheet program that allows you to store, organize, and analyze information?

Accepted Answer

Excel

Microsoft Excel

Questions 50

Microsoft Excel

Questions 50