1) What is the intersection of a column and a row on a worksheet called? a) Column b) Value c) Address d) Cell 2) Which function in Excel specifies the numeric entries made ? a) NUM b) COUNT c) SUM d) CHKNUM 3) A features that displays only the data in column (s) according to specified criteria is a) Formula b) Sorting c) Filtering d) Pivot 4) In Excel, Columns are labelled as _____________ a) A, B, C, etc b) 1,2,3 etc c) A1, A2, etc d) $A$1, $A$2, etc 5) The ____ feature of MS Excel quickly completes a series of data? a) Auto Complete b) Auto Fill c) Fill Handle d) Sorting 6) An Excel file is generally called a / an : a) E-Spreadsheet b) Worksheet c) Workbook d) Sheet 7) To add a new line in an existing cell we use ________________ key a) Alt + Enter b) Shift +Enter c) Ctrl +Tab d) Alt + Tab 8) is the symbol for ___________. a) Function b) Enter Button c) Auto Sum d) Auto Fill 9) ____ appears at the bottom of the Excel window a) Title bar b) Formula bar c) Worksheet tabs d) Name box 10) ______________helps fully display longer text in a cell without it overflowing to other cells. a) Merge & center b) Wrap Text c) Justify d) Fill

Quiz on MS Excel

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?