Spreadsheet formulas and functions
87 resources created by 78 users
Top Spreadsheet formulas and functions resources
Quizzes
-
20 questionsExcel 2 Which of the following characters always starts a formula?
-
12 questionsHow much can you remember about Excel? Part 2. You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
-
19 questionsCAT PAT What is the function of this formula? =sum(A1:B1)
-
20 questionsSpreadsheet quiz An instruction used to carry out operations on numerical data
-
19 questionsExam 2 Tutorial 3
-
10 questionsChapter 2 Study Guide If you hide columns 7-10 in your worksheet, column 8 will print.
-
12 questionsUntitled To let Excel know that you want to enter a formula, what is the symbol to type?
-
1 questionsSpreadsheets L3 Learning Review
Mind maps
Flashcards
-
29 cardsSpreadsheet Flash Cards
-
25 cardsIT - Topic 10 What is a workbook
-
24 cardsSpreadsheets
-
30 cardsExcel Module 6
-
8 cardsUntitled Define a spreadsheet
-
15 cardsMicrosoft Excel flashcards A function within Microsoft Excel that adds together the contents of a number of cells.
-
17 cardsCAT Practical - Excel What is the function of this formula? =sum(A1:B1)
-
3 cardsConditional Functions What is a CONDITIONAL FUNCTION?
Flowcharts
Notes
-
Advanced Excel Training Notes
-
Untitled A spreadsheet application such as Excel can store all its data in a single file. This file is called a 'workbook'. A workbook is made up of one or more 'worksheets'. A worksheet is a single tab in the spreadsheet work...
-
Volume 1b Spreadsheet:Used in accounting for presenting business data like item quantity, cost and revenue in rows and columnsProduce accounting reports, financial models, inventory reports, quotation and personal mail listsE.g...
-
Excel (Theory) - A formula in excel always starts with =. - Whenever working in a spreadsheet, always press the sqaure above row 1 and next to column A to autofit the whole spreedsheet. - Refer to a cell by the column heading ...
-
Spreadsheet definitions Functions: Ready made formulas representing a complex calculations.Formulas: A formula is typed directly into the formula barNested Formula: Included more than one function or formula. Surrounded by brackets and will ...