WHAT IS SPREADSHEETS-40 QUESTIONS AND ANSWERS 2024 LATEST UPDATE ALREADY GRADED A+

What tool did the Chinese invented and what did it do? The abacus was invented by the Chinese to help keep track of large numbers. What tool did students have 30 years ago to help them with math exams? Pen, paper, slide rulers and log books Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:15 Full screen What did calculators help do once they were created? Speed up calculations and improve accuracy Calculators are good, but according to the website, what were they not good at? Solve complex problems or deal with large amounts of repetitive work. Once the technology was available, what was created to do what calculators can't do? Spreadsheets What is a spreadsheet? A spreadsheet is a piece of software which is used to work out calculations What can spreadsheets do? Handle all of the financial calculations for a large business, work with statistics and to calculate probability or other statistical information, complex trigonometry, make pretty snazzy graphs and charts that you can use to impress people At the end of the day, what is a spreadsheet really? A glorified calculator In your opinion, how will learning spreadsheets help you with math homework? It can help me calculate probabilities of numbers What is a formula used for? To do every single calculation in the spreadsheet How simple can formulas get? As adding up two numbers in different cells How complex can formulas get? As working out a statistical result from millions of pieces of data collected over months Why are formulas so important in spreadsheets? Once you have set them up, they will track any changes that you make in the spreadsheet What sign does a spreadsheet have to begin with and why? An equal sign because it is the trigger to tell the spreadsheet that a calculation is needed. What does a function do? A very specific job within a spreadsheet What does the function SUM do? Add up a set of numbers for you What does the function AVERAGE do? Give you the average of a set of numbers What is created when functions are combined? A formula What type of spreadsheets can get very large and complex? Ones that are used to keep track of projects or company finances According to the Charts & Graphs page, why are graphs and charts easier to study sometimes instead of a large spreadsheet? Because it is in a picture format. According to the chart in the Chart & Graphs page, when was ice cream sales the highest? When was it the lowest? It was highest on August and lowest on January. Define the word Automate To convert a process or workplace to automation, or utilize the techniques of automation What does a Macro do? A series of instructions and/or actions that can be recorded and then set to run whenever you need to perform the task in the future List the examples of the uses of a Macro: Producing a graph from a table of data, importing data from another program e.g prices from a spreadsheet into a flyer, exporting data to another program, sorting data in a table, saving the contents of a worksheet as an archive file and then clearing the worksheet ready for the next day/week, and printing a workbook/invoice List three features of a Macro: Keystrokes or mouse clicks can be recorded to make the macro, the actions are saved as Visual Basic code which can be edited by hand, and shortcuts keys can be allocated to macros, e.g. cont+C to copy, cont+V to paste. List three advantages of using Macros: A large number of tasks or actions can be recorded in a single macro, a single click of a button or shortcut key can be used to see the macro running, and macros easily automate repetitive processes List three problems with using Macros: A mistake made whilst recording the macro will be repeated every time the macro is run, if something needs to be changed in the macro, the whole macro must be re-recorded, and if there are a large number of macros, the wrong macro might be chosen by mistake What does a model allow you to do? Try out different scenarios to see what would happen if you made a change without any of the risks of actually having to do them in real life