1) ___________ are used to keep an area of a worksheet visible while you scroll to another area of the worksheet? a) Lock Panes b) Solid Panes c) Stop Panes d) Freeze Panes 2) Freeze Panes can used on both rows and columns? a) True b) False 3) Comments can NOT be added to a spreadsheet workbook? a) True b) False 4) _____________ cell referencing means that as a formula is copied and pasted somewhere else in your spreadsheet , the cell reference in the formula is changed to reflect the new location? a) Relative b) Absolute 5) _____________ cell referencing means a formula is copied and pasted somewhere else in your spreadsheet, the cell reference in the formula do not change? a) Relative b) Absolute 6) Which sign is used to indicate an absolute cell reference? a) % b) = c) $ d) £ 7) A ____________________ is a pre-defined formula? a) Cell b) Sort c) Function d) Worksheet 8) What function counts a value depending on a certain condition? a) Countif b) Count c) AutoSum d) Average 9) What function search for a value in the first column of a specified table, and returns a value from the specified adjacent column? a) VLookup b) Countif c) Average d) Sort 10) _________________ is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria? a) Additional formatting b) Conditional formatting c) Standard formatting d) Auto formatting

Intermediate Excel Quiz

by
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?