INFORMATICS

a ______starts with the sign "=" and is used to calculate cells

Which options can you use to merge cells?

When merging cells, only data in the _____ will remain

What function finds the minimum value in a set of data?

What is the result of the formula =(5+2)*3?

To copy the selected cells, hold down _____ and drag it with your mouse

Two of the of Excel Paste Special options

A cell may include contents, comments, hyperlinks and _____

What can you apply to cells?

You use ____ when you need to find things in a table or range by row

You can ____ worksheets to enter and edit data on several worksheets at the same time

If you want to display numbers as monetary values you must format those numbers as...

When you insert a cell, the other cells move to the right or left?

Two methods for referencing cells in excel, one is relative, What is the other?

In excel, what is a chart?

To add together a list of 25 numbers and then divide this sum by 25, use the______ function

When a cell is formatted to _____ text, any data automatically breaks to fit the column width

In Excel, the _____ tab contains formatting commands

Tabs that identify the worksheets in an Excel workbook?

vertical reference on a spreadsheet and is labelled with letters?

To erase the contents of cell M25, select the cell and then press _____

Where is the fill handle located?

You can unhide cells, rows or columns

What does the H in HLOOKUP stand for?

A1:A20 is an example of a ______

To____a filter from a set of data (and see the data again) you click on the filter button again

what do you get with the COUNT function?

the____tool remove duplicate values in a worksheet

Which tool is used to copy formatting?

In excel is it called sheets or pages?

What excel function calculates the largest value?

Which format should be chosen to display a cell value as $15,000.00?

Which are the options to sort data?

One or more continuous cells is a ______

Data displays in the _____ as you type

Any set of characters containing a letter, hyphen, or space is considered a______

A duplicate value occurs when the data in at least 2 different ____ are identical

what excel formula counts the cells that are not empty?

Select two options of the Excel’s Clear button

The____is used to test a value bases on a condition, and determines whether it's true or false

What options are in the Paste Special dialogue box?

In excel you can enter text, formulas and _________

Describes the structure or order of the elements in an Excel formula?

When you remove duplicates in a worksheet, any duplicate value is _____ the worksheet

To represent a proportion of each value to the total in a a data series use a ____ chart

Color scales, icon sets and data bars make up Excel's ........

Is the merge option located in the alignment group?

In a formula, excel performs_____after multiplications

What excel formula add up a column of numbers?

what is the type of cell reference that does not change wen copied or filled?