1) Excel is .. ? a) A database b) A word processor  c) A presentation program d) A spreadsheet program 2) A spreadsheet is ... ? a) A program that modifies pictures b) A program that performs mathematical work c) A program that creates text based documents d) A website to watch videos 3) A spreadsheet workbook consists of ? a) Boxes b) Squares c) Cubes d) Cells 4) Which of the following is a correct cell reference (name)? a) %4 b) XX c) 4C d) C4 5) Using _________ in spreadsheets can allow you to quickly make calculations? a) Formulas b) Images c) Charts d) WordArt 6) A formula always starts with? a) - b) = c) * d) / 7) What is the symbol for multiplication on a spreadsheet? a) - b) + c) * d) / 8) What is the symbol for division on a spreadsheet? a) - b) + c) * d) / 9) Which tool is used to colour a cell? a) Shape Fill b) Alignment tool 10) What button can you click on to create a SUM formula? a) CreateSum b) AutoSum c) TotalSum d) Sum 11) What button do you press on the keyboard to absolute a cell? a) F7 b) F4 c) F5 d) 4F 12) What function do you use to find the highest value of a set of data? a) =MIN() b) =SUM() c) =MAX() d) =COUNT() 13) What function do you use to find the smallest value of a set of data? a) =MIN() b) =SUM() c) =MAX() d) =COUNT() 14) What function do you use to find the average of a set of data? a) =MIN() b) =AVERAGE() c) =MAX() d) =COUNT() 15) What does ascending order mean when sorting? a) Z-A b) A-Z 16) What does descending order mean when sorting? a) Z-A b) A-Z 17) How many print outs does an excel task require? a) 3 b) 2 18) What does it mean when you are asked to embed a chart? a) Separate print out for chart. b) Print Chart on a new sheet c) Print chart covering the data on the excel worksheet d) Print chart on the same page of the excel worksheet 19) Chart titles should always be typed in ... a) Sentence case b) Uppercase (ALL CAPS) c) Lowercase 20) Bar/line charts should include a) Data, chart title, legend and axis-titles b) Data, Chart title, Data Labels, Legend 21) Pie charts should include a) Data, chart title, legend and axis-titles b) Data, Chart title, Data Labels, Legend

Basic Excel Quiz

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?