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

tarafından
Yazdır
Yerleştir

Skor Tablosu

Görsel stil

Seçenekler

Şablonu değiştir

Otomatik olarak kaydedilen geri yüklensin mi: ?