MS Excel Quiz

MS Excel. A basic element of spreadsheets is

• table

• a line

• a sheet

• a cell

• a column

MS Excel. What cell in Excel is active

• any cell reflected the screen

• a cell which specifies the cursor

• the active cell in excel is not present

• a cell in which you carry out calculations

• the cell, which contents is displayed in a line of formulas

MS Excel 2007. The group of the diagram is located on the tab

• view

• home

• insert

• references

• page layout

MS Excel. When the background formula checker finds a rule that might be in violation, it places a ____ triangle in the cell

• red

• blue

• grey

• green

• yellow

MS Excel. To add borders to a range of cells, right-click the selected range, select ____ on the shortcut menu, then click the border tab

• cut

• insert

• format cells

• border contents

• borders and shading

MS Excel.The relative address in Excel, is

• such address is not present

• the address containing cyclic references

• the address depending on type of data in a cell

• the address to which it is impossible to refer in the formula

• the address which is corrected at moving formulas from one cell to another

The absolute address in Excel, is

• such address is not present

• the address containing cyclic references

• the address depending on type of data in a cell

• the address to which it is impossible to refer in the formula

• the address which is not changing when copying formulas from one cell to another

MS Excel. The element of the diagram showing the name of markers of data

• a file

• a kind

• a format

• a legend

• a command

MS Excel. In a line of formulas it is showed

• figures

• symbols

• the formula

• value of cells

• the address of a cell

MS Excel. For construction of schedules and drawing up of formulas it is necessary to use the master

• forms

• reports

• drawing

• diagrams

• functions