Microsoft Excel

Question 1

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

Accepted Answer

Tax

Question 2

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

Accepted Answer

New

Question 3

Gridlines are horizontal and vertical lines.

Accepted Answer

True

Question 4

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

Accepted Answer

False

Question 5

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

Accepted Answer

False

Question 6

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

Accepted Answer

Wrap Text

Question 7

__orientation means the page is horizontal.

Accepted Answer

Lanscape

Question 8

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

Accepted Answer

True

Question 9

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

Accepted Answer

File

Question 10

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

Accepted Answer

True

Question 11

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

Accepted Answer

View

Question 12

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

Accepted Answer

False

Question 13

You can also set your print area form the __tab.

Accepted Answer

Page Layout

Question 14

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

Accepted Answer

Excel

Question 15

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

Accepted Answer

False

Question 16

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

Accepted Answer

False

Question 17

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

Accepted Answer

pdf

Question 18

The new unit of study is Microsoft Excel.

Accepted Answer

True

Question 19

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

Accepted Answer

True

Question 20

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

Accepted Answer

Formula bar

Question 21

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

Accepted Answer

True

Question 22

Only standard colors are available on the Font color button.

Accepted Answer

False

Question 23

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

Accepted Answer

Home

Question 24

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

Accepted Answer

Formula bar

Question 25

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 26

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

Accepted Answer

False

Question 27

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

Accepted Answer

Ribbon

Question 28

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

Accepted Answer

Drag

Question 29

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

Accepted Answer

Invoice

Question 30

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

Accepted Answer

True

Question 31

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

Accepted Answer

Wrap

Question 32

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

Accepted Answer

True

Question 33

The intersection of a column and a row is a_____.

Accepted Answer

Cell

Question 34

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

Accepted Answer

False

Question 35

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

Accepted Answer

increase the column width

Question 36

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

Accepted Answer

Conversion

Question 37

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

Accepted Answer

Inventory Mangement

Question 38

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

Accepted Answer

False

Question 39

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

Accepted Answer

Recent

Question 40

To group worksheets press and hold the__ key.

Accepted Answer

Ctrl

Question 41

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

Accepted Answer

False

Question 42

__orientation means the page is vertical.

Accepted Answer

Portrait

Question 43

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

Accepted Answer

Inventory

Question 44

=(A2*B2)+10

Accepted Answer

Formula

Question 45

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

Accepted Answer

Cell reference

Question 46

All formulas must start with__.

Accepted Answer

an equal sign

Question 47

Fill color is applied to the __ of a cell.

Accepted Answer

Background

Question 48

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

Accepted Answer

COUNT

Question 49

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

Accepted Answer

True

Question 50

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

Accepted Answer

your column is not wide enough

Microsoft Excel

Questions 50

Microsoft Excel

Questions 50