1) What is the Sum formula? a) Sum( ) b) Sum( )= c) =Sum( ) d) =( )Sum 2) When starting a formula what is the first thing you type in the cell? a) + b) - c) % d) = 3) Excel spreadsheets that are already created and ready for you to edit are known as? a) spreadsheets b) templates c) data inputs d) pages 4) Excel is useful for using ________ as opposed to words or presentations? a) Excel is useful in presenting b) Excel is useful in documents c) Excel is useful in numbers d) Excel is useful in publishing 5) The letters in Excel represent the _______? a) columns b) rows c) data d) functions 6) The numbers in Excel represent the _____? a) columns b) rows c) data d) functions 7) A function in Excel is represented by what to letters? a) f( ) b) xF c) xf d) fx 8) How would you write a cell reference formula for cell A1 subtracted by Cell C3? a) A1-C3 b) A1-C3= c) =A1-C3 d) =C3-A1 9) What version of Excel are we using in class? a) Excel 2016 b) Excel 2017 c) Excel 2018 d) Excel 2015 10) 2 or more cells that are selected to create a source to be used in a formula a) Range b) Max c) Filter d) Colums 11) Adding two cells a) A1+A13= SUM b) =SUM(__) c) =SUM(A1+A13) d) Total 12) A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole. a) Line Chart b) Pie Chart c) Column Chart d) Bar Chart 13) A Graphic representation of data. What is the type of this chart? a) Line Chart b) Pie Chart c) Column Chart d) Bar Chart 14) A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. a) Pie Chart b) Column Chart c) Bar Chart d) Line Chart 15) Making a change in the default settings a) Format b) Average c) Chart d) Design 16) The sum of all numbers divided by the amount of numbers. a) Maximun b) Median c) Minimum d) Average

MS Excel

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?