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
Log in required
Log in required
This leaderboard is currently private. Click
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
More formats will appear as you play the activity.