Which function counts cells that contain a certain criteria e.g. all the cells containing "Halloween", sumif, countif, min , max , Which function sum the values in a range of data that meet certain criteria?  , countif , sum, sumif, average , Every formula begins with an…, *, (, :, =, To multiply in Excel you use the…, x, *, \, >, Sally works in a cinema. She wants to know how many of the tickets sold for a movie were for adults and how many were for children. Which function will she use? , average , countifs , max , vlookup, Tim needs to calculate the best selling product for today. Which function should be used? , average , min , max, countif, Which function has been used here to return the price of the items?, countif, countifs , sumif, vlookup, Which symbol is used before the before both the column letter and the row number to prevent it from changing when the formula is copied or filled to other cells?, €, $, @, =, To calculate a percentage you can use  , =part*total  , =part/total , =sum(), =max(), A5, B2, C10 are all , formulae , functions , cell references , rows , Which tool is best to duplicate information from one cell to another? , fill handle , sort , filter , format , Which of the following would be used to organise names in a spreadsheet alphabetically? , filter , format , merge and centre , sort , Which function counts cells in a range that are NOT empty?, COUNTIF , COUNTIFS, COUNT, COUNTA , Zoe needs to format a cell to currency. Which option should she select?, , , , , Tom is calculating a percentage. His formula is =c2/b2. How should he format the cell to show the answer as a percentage?, , , , , When text is too long in a cell what should be used?, bigger font, border, text wrap, format to currency , This is used to..., wrap text , add colour to cells , add a border around data , to make text bold, What has been used here to make the data stand out?, conditional formatting , data validation , Conditional formatting is used to..., make data / trends stand out , prevent errors , to confuse the audience , to show currency values , What has been used here to reduce the chance of an error?, Conditional formatting , Data Validation (drop down list), text wrap , border , What has been used here to visually show the trend / variation in the data?, sparklines, data validation, conditional formatting, a border .

Task 2 Excel

af
Trykke
Integrere

Rangliste

Visuel stil

Indstillinger

Skift skabelon

)
Gendan automatisk gemt: ?